SSRS expression replace NULL with another field value
=iif(isNothing(Fields!FV1.Value), Fields!FV2.Value, Fields!FV1.Value)
reporting-services
Set a table’s visibility to false when it has no rows (in reporting services)
Try setting the table’s “Visibility.Hidden” property to this expression: =CountRows() = 0
Forward dependencies are not valid in SSRS
The other reason you will see this error is if you have the order of report-wide parameters incorrect. For instance if you have the following: @Param1 @Param2 @Param3 and you are trying to use @Param3 in a query populating @Param1, it will throw this error. You need to use the up/down arrows at the top … Read more
Report Builder 3.0 SWITCH expression DEFAULT/ELSE
There is no default clause in the SSRS Switch expression. However, you can always modify your expression slightly: =Switch ( Parameters!UserFranNr.Value = “99”,”ID99″, Parameters!UserFranNr.Value = “87”,”ID87″, true, “ID0” ) Since any time the last condition is hit it will be explicitly evaluated to true, the last row will effectively act as a default value. I’ve … Read more
Reporting Services export to Excel with Multiple Worksheets
To late for the original asker of the question, but with SQL Server 2008 R2 this is now possible: Set the property “Pagebreak” on the tablix or table or other element to force a new tab, and then set the property “Pagename” on both the element before the pagebreak and the element after the pagebreak. … Read more
Tracking report usage
There is some good advice and queries for generating reports on this in the following article. For example, if you want to see the most used reports, you can do the following: SELECT COUNT(Name) AS ExecutionCount, Name, SUM(TimeDataRetrieval) AS TimeDataRetrievalSum, SUM(TimeProcessing) AS TimeProcessingSum, SUM(TimeRendering) AS TimeRenderingSum, SUM(ByteCount) AS ByteCountSum, SUM([RowCount]) AS RowCountSum FROM (SELECT TimeStart, … Read more
Where does a published RDL file sit?
It is not a file on the server. It stored as a BLOB in the ReportServer database. (In the Catalog table to be precise on SSRS 2005) Extended Answer
Line break in SSRS expression
UseEnvironment.NewLine instead of vbcrlf
Reporting Services Remove Time from DateTime in Expression
Something like this: =FormatDateTime(Now, DateFormat.ShortDate) Where “Now” can be replaced by the name of the date/time field that you’re trying to convert.) For instance, =FormatDateTime(Fields!StartDate.Value, DateFormat.ShortDate)
Display Parameter(Multi-value) in Report
You can use the “Join” function to create a single string out of the array of labels, like this: =Join(Parameters!Product.Label, “,”)