|UPDATE database record after/just before report closes [message #1067190]
||Sun, 07 July 2013 12:44
Registered: February 2013
I have a requirement to make the details of a report visible if database field RPTEXEC==0. In addition, once the report is run, RPTEXEC must be updated to 1 so the next time the report is run, the details do not show. |
The report updates the database & displays data correctly when shown in the web viewer, but when it's exported to PDF, the report seems to execute again & RPTEXEC now equals 1, so the details of the report are no longer visible.
I have tried putting the code that updates RPTEXEC in functions fetch, beforeClose, afterClose & close, but the database update is still occuring when the report is exported to PDF.
Any idea where to put code that updates the database so it fires AFTER the report is run? Thanks so much for your suggestions!
Powered by FUDForum
. Page generated in 0.02912 seconds