Update after execute and show the report [message #1755503] |
Fri, 03 March 2017 20:52 |
Luis Lianza Messages: 1 Registered: March 2017 |
Junior Member |
|
|
Hi,
Currently I do not know what version of BIRT I use, but I do not think it will influence the development of what I come to present.
I need to run an update statement after generating and opening the report, the problem is that as I currently have it tied to the class that opens the report, the update statement is executed earlier and alters the results of the report.
What I am doing for now is to place a Thread.sleep (10000) and then the update statement, so that the report can be executed and after 10 seconds update what you have to update (but it is not the best practice).
Place a script in the after open field "myTxn =
MXReportTxnProvider.create (this.getDataSource (). GetName ());
MyStmt = myTxn.createStatement ();
MyStmt.setQuery ("update ... set .... = ....");
MyTxn.save (); ", but it did not work.
What I need is an alternative to execute the update statement within what is the .rptdesing and this is executed after the report query is executed so that it shows the results without alterations.
Sorry for my bad English.
Thanks.
Luis Lianza.
|
|
|
Powered by
FUDForum. Page generated in 0.02425 seconds