reporting-services – Page 5

Passing a parameter via URL to SQL Server Reporting Services

May 25, 2023 by Tarik

First, be sure to replace Reports/Pages/Report.aspx?ItemPath= with ReportServer?. In other words, instead of this: http://server/Reports/Pages/Report.aspx?ItemPath=/ReportFolder/ReportSubfolder/ReportName Use this syntax: http://server/ReportServer?/ReportFolder/ReportSubfolder/ReportName Parameters can be referenced or displayed in a report using @ParameterName, whether they’re set in the report or in the URL. You can attach parameters to the URL with &ParameterName=Value. To hide the toolbar where parameters … Read more

SSRS the definition of the report is invalid

May 24, 2023 by Tarik

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.

Set a table’s visibility to false when it has no rows (in reporting services)

May 14, 2023 by Tarik

Try setting the table’s “Visibility.Hidden” property to this expression: =CountRows() = 0

Forward dependencies are not valid in SSRS

May 9, 2023 by Tarik

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

how to remove time from datetime

May 6, 2023 by Tarik

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

May 6, 2023 by Tarik

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

Could not load file or assembly ‘Microsoft.ReportViewer.Common, Version=11.0.0.0

April 30, 2023 by Tarik

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

April 23, 2023 by Tarik

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

April 21, 2023 by Tarik

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

April 20, 2023 by Tarik

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