asifinet

 Profile Answers by asifinet 

• Feb 15th, 2013

 

Dynamic Reports are the Reports which is based on the GLOBAL_TEMPORARY TABLE. can be used in BEFORE RUN REPORT Trigger to populate the Data into that table by calling function/procedure. After report is generated you can use commit; statment in the AFTER RUN REPORT Trigger to clear off the Table release the Storage from the Temporary Table. Please check the Command how to create the Global Temporary Table below.

CREATE GLOBAL TEMPORARY TABLE admin_work_area
(startdate DATE,
enddate DATE,
class CHAR(20))
ON COMMIT DELETE ROWS;