Dataset Usage Reports

All datasets in Reporting Services reports are executed, regardless of whether they are all used. Identifying unused datasets can allow you to delete the unused datasets, thus speeding report performance and scalability. Also, identifying where in a report datasets are used can help you understand an unfamiliar report. This BIDS Helper feature lets you view a list of used and unused Reporting Services datasets.

Right-clicking on the project node or the solution node of any Visual Studio 2005 or 2008 project with .rdl or .rdlc files (e.g. C# projects with .rdlc files, not just SSRS projects) reveals the following menu:

UnusedDatasetsMenu.png

Unused Report Datasets...
This report lists all Reporting Services datasets which are not used anywhere in the report.

Used Report Datasets...
This report lists all Reporting Services datasets which are used. It lists which parts of the report use this dataset. Download a sample showing the results of this feature run against the Adventure Works sample reports, or look at the following screenshot:

UsedDatasetsReport.png

Notes:
  • This feature runs entirely offline without touching ReportServer and without connecting to any of your datasources. It simply navigates the XML in the RDL file and parses expressions.
  • Sanity check any dataset that BIDS Helper reports as unused before deleting it. If you do encounter any datasets that BIDS Helper incorrectly identifies as unused, please create an issue and attach the RDL file.

Last edited Jan 28, 2009 at 2:43 AM by furmangg, version 3

Comments

jgoers Dec 6, 2010 at 2:56 PM 
Just what I needed. Huge report got changed and some datasets wheren't in use anymore.