Hi, I'm guessing someone may have found a way to do this so I thought this would be the place to ask.
At SFO we're finding the migration reports to be a big help with our V11 upgrade. However, we were wondering if there might be a way to easily cross reference the Tessiture V11 Customizations Review (Which lists LP Stored Procedures that may need v11 attention) with the Custom Report Run Frequency report (Which lists custom report run frequency).
What would be helpfull would be a way to view the actual stored procedures that the custom reports are using (as listed in the T11 Customizations review). The report does show the Report Name and Datawindow objecet, but going into each infomaker report to find the stored procedure name can be pretty labor intensive.
Has anyone found an easy way to do this? It would help us a lot to know the SP names of our most commonly used custom reports (we have quite a few).
Thanks in advance!
Porter Venn (San Francisco Opera)
Unknown said: Has anyone found an easy way to do this? It would help us a lot to know the SP names of our most commonly used custom reports (we have quite a few).
I wanted an easier way to do this, and came up with the following: I copied some code from MP_REPORT_FREQUENCY, and sent that output to a temp table. I then made another temp table matching the column output of MP_review_customizations, and ran its output into that second table. I then query the first table, referencing the second.I then wind up with the most frequently executed reports, plus the report_id, report_name, datawindow, etc.
The code is pretty quick-and-dirty, but has been helpful to me. Happy to share if anyone is interested.
Hi Chris,
I have just started down the road of customization and v.11 and would be extremely grateful for the code you mention here. Could you email to npurkiss@publictheater.org ?