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
reporting-services
SSRS the definition of the report is invalid
I just received this obscure message when trying to deploy a report from BIDS. After a little hunting I found a more descriptive error by going into the Preview window.
how to remove time from datetime
First thing’s first, if your dates are in varchar format change that, store dates as dates it will save you a lot of headaches and it is something that is best done sooner rather than later. The problem will only get worse. Secondly, once you have a date DO NOT convert the date to a … 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
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
Could not load file or assembly ‘Microsoft.ReportViewer.Common, Version=11.0.0.0
Dont know if this is good to anyone, but search all these dlls: Microsoft.ReportViewer.Common.dll Microsoft.ReportViewer.ProcessingObjectModel.dll Microsoft.ReportViewer.WebForms.dll Microsoft.ReportViewer.WinForms.dll Microsoft.ReportViewer.DataVisualization.dll You find them in C:\Windows\assembly\GAC_MSIL\…, and then put them in the references of your project. For each of them say: local copy, and check for 32 or 64 bit solution.
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
Viewing SSRS Reports in an ASP.net MVC Site
No, not in a MVC view. But you can have a web forms pages which have server controls in them mixed in with your MVC site. Hmm, just googled “mix asp.net mvc and web forms” to find some examples, and google questioned whether I’m human or not 🙂 Anyway, here’s a link – http://www.packtpub.com/article/mixing-asp.net-webforms-and-asp.net-mvc – … 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