Hello Tessitura collective Mind!
Has anyone written scripts or found strait forward code based ways to find out each of their reports -- and what procedures they use? We've got a multitude of versions, and updates and new and old reports. These reports are a combination of SSRS and Infomaker formats. What would be amazing to do is have some query to filter on to be able to find if a given procedure is linked to a certain report/SSRS or Infomaker file? Any and all suggestions are appreciated. Many thanks, -Lisa
Hi Lisa, I have written a report that returns the Report Name, and the command text (whether it be T-SQL or a Stored Procedure call) for all SSRS reports. I can share that with you if you are interested.
Debbie
I'm not Lisa but I'm interested!
Ditto what Nancy said.
3rded for me. That sounds awesome
I would also be interested!