SSRS 2013 - Finding Datasets/StoredProcedures

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....
Amour22015Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
I believe that "SSRS Diagnostics Report Pack" that can be found here http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/69257/ is an excellent source for all you need in order to admin your SSRS reporting server with many admin reports.
0
Amour22015Author Commented:
Hi Experts,

The link is what I think I am looking for but I have a problem with uploading into a secure environment a zip file.  So I take it there is no option (or way) to produce such a report from SSRS?  If I recall MS Access Reports has this as an option off the menu bar, a detailed report.

please help and thanks
0
lcohanDatabase AnalystCommented:
You can unzip the file and copy/paste them (they are less than 100K in total) into the SSRS server assuming you have RDP to that location and that in my opinion should not be a problem as I did the same into a PCI compliant environment so...all you'll need is to create that data source and edit each of those reports to bind to it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Amour22015Author Commented:
Great thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.