troubleshooting Question

SSRS 2013 - Finding Datasets/StoredProcedures

Avatar of Amour22015
Amour22015 asked on
SSRSMicrosoft SQL Server 2005
4 Comments1 Solution238 ViewsLast Modified:
Hi Experts,

Is it possible to search many Solutions/Reports for content within many dataset(s)?

I created a Common Stored Procedure:
Common_Scandate  <== Stored Procedure for dropdown on the SSRS report .rdl   All current reports that use the Scandate dropdown will be using this SP.  
There are many reports (.rdl) that use random Scandate SP's Like:
UniqueScandateTop3 <== Stored Procedure that will be deleted
UniqueScandate <==== Stored Procedure that will be deleted
Scandate_Top1 <===Stored Procedure that will be deleted
Etc(what ever the creator of the report used to name the SP's).....

All (.rdl)'s that use Scandate Dropdown will be changed within the (.rdl) file Dataset to the SP Named: Common_Scandate

Currently I am manually going into each (.rdl) file and changing the Dataset to "Exec Common_Scandate"   I don't mind doing this part manually but finding the reports that use the Scandate Dropdown and having a list is what I need.  

Does SSRS provide a report that shows All Report name(s), DataSet Name(s) and DataSet Content  within a solution?  

Example would be:
HistoricalMap.rdl <== This report would have a Scandate Dropdown for when each Map was Scanned.
DataSet Name: Main "Exec MainStoredProcedure"
DataSet Name: Scandate  "Exec UniqueScandate " <== Finding this I could change to: Common_Scandate

Thank You....
Database Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros