Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Keep Birt from Re-running Stored Procedure When Printing
Migrateduser
After running a report the user wants to print it. When printing the report, BIRT reruns the report. Because Maximo uses a scripted database we can't execute stored procedures in the normal method. Instead, we kick it off using a Begin End; statement inside of the Fetch on our data source. The stored procedure writes some data to a temp table that is displayed in the report. The temp table is cleared each time the report is run. The problem we are encountering is that we need to run the stored procedure once only and then print it without the stored procedure being run again.
Any ideas how to print a report without running the stored procedure again?
Find more posts tagged with
Comments
There are no comments yet