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
Try setting the table’s “Visibility.Hidden” property to this expression: =CountRows() = 0
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
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
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
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
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
UseEnvironment.NewLine instead of vbcrlf
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)
You can use the “Join” function to create a single string out of the array of labels, like this: =Join(Parameters!Product.Label, “,”)
Ultimate solution (works in SSRS 2012 too!) Append the following script to “C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\js\ReportingServices.js” (on the SSRS Server): function pageLoad() { var element = document.getElementById(“ctl31_ctl10”); if (element) { element.style.overflow = “visible”; } } Actually I don’t know if the div’s name is always ctl31_ctl10: in my case it is (instead over SQL … Read more