Top "Ssrs-2012" questions

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft.

Replace Zero with Blank in SSRS

Is it possible to replace 0 with blank in ssrs matrix. The expression =IIF(IsNothing(Count(Fields!referralNo.Value)),0,Count(Fields!…

reporting-services ssrs-2008 ssrs-2008-r2 ssrs-2012
How to add row group headers to a "headerless" style report?

For the following Query SELECT * FROM (VALUES ('England','London',9787426), ('England','Manchester',2553379), ('Scotland','Edinburgh',452194), ('Scotland','Glasgow',1168270), ('Wales','Cardiff',447287)) V(Country, City, …

reporting-services ssrs-2012
Specify thousand separator in ssrs without specifying decimal

MY database have values like 3302540.8200 748712.9600 584879.2400 20787.5300 1338075.0000 I need the above values like below in my SSRS reports 3,302,540.82 748,712.96 584,879.24 20,787.53 1,338,075 I tried custom format …

reporting-services number-formatting ssrs-2012
Automated deployment options for SSRS

I have been tasked to look into ways to automate the deployment process for our SSRS 2012 reports. Are there any …

reporting-services ssrs-2012
Download SSRS Report and save in specific location (C#) (Unauthorized)

Question I am attempting to download an SSRS report via its URL into a data buffer (byte array), so therefore …

c# reporting-services ssrs-2012
Update Shared Datasource Path of all SSRS reports to different path

I'm working on SSRS Report. Recently I have changed my folder location of all SSRS report to different path. Also …

sql-server reporting-services ssrs-2008-r2 ssrs-2012 ssrs-2014
What is the difference between Today() and Now() in SSRS?

Is there a difference between Today() and Now()? When I searched online for date expressions I noticed that both are …

reporting-services ssrs-2012 ssrs-expression
SQL Server Reporting Studio report showing "ERROR#" or invalid data type error

I struggled with this issue for too long before finally tracking down how to avoid/fix it. It seems like …

sql sql-server reporting-services ssrs-2012
How to repeat text box in every page in ssrs

Is it possible to repeat textbox in every page without giving it on the page header in SSRS. Because before …

reporting-services ssrs-2008 ssrs-2012
SSRS Line Chart Dynamic Y Axis

I have a line chart where the Y value is set to =CountRows() and I have a Category Group which …

reporting-services linechart ssrs-2012