Keep Birt from Re-running Stored Procedure When Printing

nimebejo

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?

micajblock

How are you printing. Why do you think it is being executed again? If you are using the viewer to print the report is should be using the report document and no re-execution should happen.