Post reply

Particular column from Table used in Reports

  • April 22, 2016 at 8:36 am

    #315903

    Is there a way to Query / figure out if a particular column from a table/View is being used in all SSRS Reports.

    Someway where I can provide view name and /or column name and it returns a list of reports using it?

  • April 22, 2016 at 8:52 am

    #1873931

    Two ways:

    1. Use a trace to capture when tables are queried. Takes time, and not necessarily correct.

    2. Use a file search mechanism against all of your .RDL files in the file system. This only works if the tables/views are stored as queries, and not if they are pulled from stored procedures.

    I guess there's a third way. Rename some of them and see if things break.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply