Eclipse Community Forums: BIRT » UPDATE database record after/just before report closes

Home

Home » Archived » BIRT » UPDATE database record after/just before report closes(conditionally show report section)

UPDATE database record after/just before report closes [message #1067190]

Sun, 07 July 2013 08:44

Eclipse Guest

Messages: 93
Registered: February 2013
Location: Vienna

Member

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! Very Happy

Re: UPDATE database record after/just before report closes [message #1067483 is a reply to message #1067190]

Mon, 08 July 2013 23:29

Eclipse User

Edit:
I reread the message and saw that it's updating the database. When you are exporting to PDF are you doing this from the webviewer or the toolbar in eclipse? I'm assuming from the webviewer since you are saying that it's working there.

[Updated on: Mon, 08 July 2013 23:33] by Moderator

Re: UPDATE database record after/just before report closes [message #1067577 is a reply to message #1067483]

Tue, 09 July 2013 08:18

Eclipse Guest

Messages: 93
Registered: February 2013
Location: Vienna

Member

Hi Kristopher!
I am exporting to PDF from the webviewer. This is when it seems to run for a 2nd time.
Thanks for your help!
Ashley