There is any way to identify the reports name, in which all I have used one Stored Procedure?
Hi, In my project, I have one Stored Procedure (SP) & that SP I have used in various reports. I have not maintained any documents for the same. Now for one report, I want to modify my Existing SP but this modification will affect other reports, in which I have used this SP. There is any simple way to find out the reports name, in which I used this SP. All suggestions are welcome Thanks Shiven:)
October 7th, 2010 12:25pm

One option is to write a code (say in .NET or a scripting language) to browse through all the rdl files in your folder and search for your stored procedure's name using the FileIO. Write the rdl file names in a separate text file where the stored procedure name is found. Open these rdls in BIDS and modify the dataset as per your requirements. I can't think of any other option as of now. Hope this helps. Cheers, ShalinShalin P. Kapadia
Free Windows Admin Tool Kit Click here and download it now
October 7th, 2010 12:56pm

You need to know all data sets that use that SP..... I have my doubt that it is possible http://sqlninja.blogspot.com/2009/01/querying-reportserver-database.htmlBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
October 7th, 2010 1:02pm

Hi, We have one more Option (If all reports are in same solution): Go to -Solution -> Reports(Which contains all RDLs) -> Open 1st Report -> View Code -> (Edit->Find & Replace-OR Ctrl+F) -> Quick Find -> Find In Files (Just click on Quick Find option in Find & Replace Windows, You will have 3 options, Quick Find, Find In Files & Find In Symbol. Select Find In Files) -> Give the SP name in Find What: and Select Entire Solution in Look In: and in Result Options check Find Result 1 Window -> Find all -> It will Display all Reports Name in Result Window Thanks Shiven:)
Free Windows Admin Tool Kit Click here and download it now
October 7th, 2010 1:17pm

Yes, thats what I was referring to; just that you're saying to do it manually and I suggested to automate it. Since the rdl files are in xml form, you would be able to use the FileIO programming and search for your stored procedure's name. The code to do this wouldn't be very difficult and wouldn't take much time, so I would prefer going this way rather than checking all the reports manually (I'm assuming that the number of reports are much more. If the reports in your solution are around 15, I too would do it manually). Regards, ShalinShalin P. Kapadia
October 7th, 2010 1:23pm

actually it looks like doing it manually is the best option. When you search for it manually, in the Find dialog box, see if you get the option for "Search in the solution". If you get this option, use it. Search for your stored procedure's name in the entire solution. BIDS would search for the keywords in the entire solution i.e. all the rdl files in your solution and wherever it finds it, it'll show it. Cheers, ShalinShalin P. Kapadia
Free Windows Admin Tool Kit Click here and download it now
October 7th, 2010 1:29pm

Hi Uri, I want to Know Reports Name those use that SP.Thanks Shiven:)
October 7th, 2010 1:31pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics