How Do I Obtain the Report Stored Procedure Name from CMS database?

[markcm]

We are currently running BO XI and I need to retrieve the report and stored procedure names from the CMS Database. Currently, I'm retrieving the Report Title, Report start and end time, et cetera. In the previous versions of BO (CE), the report stored procedure name was retrieved by opening the active x report object. I would like to avoid opening the report object and retrieve the store proc name from the CMS Infostore database. Anyone know how to do this??

Thanks in Advance,
Mark.

 

[synapsevampire]

I'm not sure that the SP is stored within the database.

I suspect that you'll need some code to open the reports and read the name.

Check out APOS for 3rd party products, if their products read the SP name then you're in luck and you can probably figure it out, if not use one of their products to do so.

http://www.apos.on.ca/Products/APOSBITools.shtml

They have some very useful freeware as well.

-k