While expressions allow you to use limited VB.Net to create advanced dynamic functionality in your SQL Server Reporting Services (SSRS) reports, custom code allows you to leverage much more of the power of VB.Net. The focus of this article is not on writing VB.Net code, but on how to create and use code in SSRS. … Continue reading Using Custom Code in SSRS
Tag Archives: SSRS
How to Audit Report Execution in SSRS
Do you need to know how often a report runs, who or what processes run the report, how long it takes to run, statistics on report parameters, which reports are not being used, and so on? SQL Server Reporting Services has built-in audit logging that can give you this type of information pretty easily. Audit … Continue reading How to Audit Report Execution in SSRS
How to Implement Expand All/Collapse All for Drill-Down in SSRS
While SSRS allows drill-down into individual groups in a Tablix, there is no built-in, direct support for an “expand all/collapse all” capability that would allow all groups to be simultaneously expanded or collapsed. No problem. We can create our own pretty easily. Here’s what it will do: The user will interact with two radio buttons. … Continue reading How to Implement Expand All/Collapse All for Drill-Down in SSRS
Adding a Secondary Axis to a SSRS Chart
What happens when you use the same scale to compare values that are actually in different scales? Have a look at this chart that was generated using Reporting Services and notice that you can barely see the gold columns for the Average Sales values. The data (see the table next to the chart) tells us … Continue reading Adding a Secondary Axis to a SSRS Chart
Using XML to Find Errors in a SSRS Report
As we see in the BI779 SQL Server Reporting Services course, a report’s rdl file is actually an XML file. One of the benefits of an XML file is that, since it is text and includes all the objects of our report, we can use it to help us find solutions to certain errors that … Continue reading Using XML to Find Errors in a SSRS Report