Stack Overflow
Stack Overflow

Questions tagged [ssrs-2014]

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2014.

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2014 in March 2014. More info in the tag.

192 questions
0
votes
2 answers

Performing Count() and Avg() within a Case statement

I am using this CASE statement to show a total count of visits and average length of visit grouped by age groups: CASE WHEN AgeCalcSort = 0 AND AgeCalcSort <= 1 then ( Count(VisitID), AVG(DATEDIFF(dd,StartDate,EndDate )) …
Baratier ErebusDuHalm
  • 111
  • 1
  • 7
0
votes
1 answer

SSRS Chrome error "Parameter cannot be blank" but works fine in I/E and in Visual Studio

Thanks in advance for reviewing! We have a multi-valued parameter that should allow a blank value. When we choose only the blank value option, Chrome is displaying a message stating the parameter cannot be blank. However, this error doesn't…
BIEMER19
  • 11
  • 1
0
votes
0 answers

SqlServerReportingServices (SSRS) Character reference "&#

We have created some report template (RDL file) and it's working fine for some of the clients. But one client is getting issue while processing the report through web service. org.xml.sax.SAXParseException; lineNumber: 1; colu mnNumber: 149133;…
user6526744
0
votes
2 answers

ssrs report report filter with no duplicates used in query

I am having an issue and I'm not sure how to solve it. I have an SSRS report that pulls from a table. I want a parameter filter to show de-duplicated values based on available options in one of the columns. So my dataset with a query like: SELECT *…
IMTheNachoMan
  • 5,343
  • 5
  • 40
  • 89
0
votes
1 answer

pdf Export Timeout issue -ssrs 2014

The Reports which have less than 5 MB size, it is downloading fine.When the size exceeds 5MB, it through below error. **The operation has timed out. Description: An unhandled exception occurred during the execution of the current web request. Please…
kumar
  • 130
  • 1
  • 7
0
votes
1 answer

Dynamically compare columns in a matrix ssrs

I've never done this for a matrix and it's going a little over my head. Trying to make a sales report, and I can do the matrix just fine. The part I'm having trouble with and I haven't been able to find a direct answer for through googling is how to…
Dale Kingston
  • 1
  • 2
0
votes
1 answer

What license do I need to connect SSRS 2014 to Azure SQL Database

I want to create a new VM with SSRS 2014 that will be able to connect to Azure Database. When setting up this VM, what SQL license do I need to choose? Will I be able to connect with standard or do I need enterprise?
Jon Kump
  • 574
  • 7
  • 19
0
votes
1 answer

SSRS Web Config - maxRequestLength

Can someone happen to let me know what the maximum value that can be set for maxRequestLength in the SSRS web.config file. I currently have it set to 2097151 but if I increase it any further the SSRS Reports homepage stops working and just displays…
PJD
  • 743
  • 2
  • 12
  • 38
0
votes
1 answer

SSRS Subscriptions don't work for AD groups but do work for individual users

A user created email subscription fails with the "permissions granted to user domain\name are insufficient" The user is a member of an AD group that has "Browser" and "Manage Subscriptions" role. This person can browse and can create and manage…
RogerG
  • 258
  • 1
  • 7
0
votes
1 answer

SSRS Only Showing 1 Instance of Report, Expecting Multiple

I'm new to SSRS so forgive me if this is an obvious answer. I'll try and simplify my problem as best I can: I have a report that's based off of a query. On that report it has the fields Account ID and Mail Date from that query on the page. Not a…
J.Cart
  • 519
  • 1
  • 8
  • 19
0
votes
1 answer

Column sorting in SSRS report

I want to sort my column numbers at report level in SSRS instead of my query as I have some other columns sorted at query level and doing both sorts at query level don't work well. At the moment I get Columns order like 1, 10,2,3,4,5,6 instead of…
Sanj
  • 35
  • 2
  • 9
0
votes
1 answer

Cascading parameters in SSRS reports doesn't work with one parameter value set to a default value

I'm trying to run an SSRS report with cascading parameters. I have 2 parameters para1, para2. I have made para1 as a hidden field and assigned para1 a default value. I have set para2 to take available values from a dataset. I'm trying to populate…
LearnCodeFun
  • 61
  • 1
  • 2
  • 9
0
votes
1 answer

How do I keep the header (column names) visible while scrolling in an SSRS report USING SQL SERVER REPORT BUILDER 2014?

I have looked at many questions that have already been answered but none of them have helped me solve my problem. I believe its because most of them were using SQL Server 2008. I am using SQL Server Report Builder 2014 and would like to have my…
Tommy
  • 9
  • 6
0
votes
1 answer

SSRS Report grouping values on a table

I'm executing a query and getting about 250 pages of data in my table but most of it (I guess my primary key "Contract") is the same value for many rows, Is there a way to group all my "contract" variable results into one row only? executed…
Alex Alcala
  • 17
  • 3
0
votes
1 answer

Print all group footer rows on the next page if they won't all fit on the first page

I have a purchase order form in SSRS. It's grouped on the Purchase Order number. There are four rows in the group footer for totals. Is there a way to keep all rows in the footer together? That is, if all of them won't fit on the page, that all of…
jim31415
  • 8,588
  • 6
  • 43
  • 64
1 2 3
…
12 13