4
Vote

SSRS: finding unused dataset fields

description

I know BIDSHelper can find datasets that aren't used in a report. What about finding fields that are no longer used?
 
We're re-working a number of our reports and removing a bunch of report items that use expressions based on different dataset fields. Would like to be able to clean-up the dataset as well so only the data that is used in the report is retrieved from the
database.
 
Cheers
 
Phil

comments

RickInAtl wrote Apr 4, 2013 at 11:06 AM

This would be an ideal enhancement since it will allow us to remove unneeded fields from stored procedures or views that feed the different reports in the project. Even more ideal would be a way for BIDS Helper to see if that same Stored Procedure is being used in other reports in the project and determine if it uses some fields that another report doesn't. But just the first feature that Phil mentions would be wonderful.

Thanks for a great enhancement to the best reporting tool money can buy (IMHO).
Rick