Post reply

How to find the specific table used in many reports

  • January 12, 2011 at 5:04 am

    #233128

    Hi,

    We have around 1000 reports created for a project. Those were deployed and running successfully.

    Now my requirement is to the change the table name from XX to YY in the datasets being used by the reports.

    But not sure how many reports were being used by the table XX.

    How to find the report names that were being used by the table XX out of 1000 reports.

    Any help would be appreciated.

    Thank you,

    Venubabu.

  • January 12, 2011 at 6:22 am

    #1272331

    Probably what I would do first is to use the Windows search and search for rdl files containing the text of the table name.

  • January 13, 2011 at 1:56 am

    #1272853

    Hi Venuba,

    As the rdl files are saved in an xml format you can easily search through the entire report using any text searcher or even windows search as Daniel suggests.

    My preferred is Notepad++ (freeware) where you have the ability to search and replace text strings in all files at once. I believe UltraEdit and a lot of other tools can do the same magic.

    Hope this helps.

    Kind regards,

    Linda

  • January 13, 2011 at 9:27 am

    #1273128

    Thanks for the reply folks.

    As all the RDL files have been uploaded to VSS. I used the search condition on VSS and got the reports that what are all the reports that were being used by the specified table.

    Once again thank you very much for your valuable replies.

    Thank you,

    Venubabu.

Viewing 4 posts - 1 through 3 (of 3 total)

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