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
UPDATE database record after/just before report closes
Migrateduser
<p><span>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! </span></p>
Find more posts tagged with
Comments
There are no comments yet