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 BI Developer Extensions 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:
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: