Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Update database field when report complete
Update database field when report complete [message #1065978] Fri, 28 June 2013 15:16 Go to next message
Paul Cockerill is currently offline Paul Cockerill
Messages: 12
Registered: August 2012
Junior Member
Hi

Is it possible to update a database column from 0 to 1 after the user has run the report for all the id's that I have listed in the report?

Ideally there would be a prompt asking the user to confirm they wish to update the database for the listed id's, if not just update the database when its run would be a step in the right direction!!.

Any suggestions how to do this?

Regards
Paul
Re: Update database field when report complete [message #1067103 is a reply to message #1065978] Fri, 05 July 2013 21:09 Go to previous messageGo to next message
Kristopher Clark is currently offline Kristopher Clark
Messages: 130
Registered: January 2013
Senior Member
Take a look at the example I attached from the birt-exchange devshare. It uses a servlet to write back to the DB.
Re: Update database field when report complete [message #1071203 is a reply to message #1067103] Fri, 19 July 2013 14:50 Go to previous messageGo to next message
Paul Cockerill is currently offline Paul Cockerill
Messages: 12
Registered: August 2012
Junior Member
Thanks for your reply.

I was hoping for something a little less complicated!!. Is using a servlet the only way to write back to the database using BIRT?

Regards
Paul
Re: Update database field when report complete [message #1071296 is a reply to message #1071203] Fri, 19 July 2013 19:17 Go to previous messageGo to next message
Kristopher Clark is currently offline Kristopher Clark
Messages: 130
Registered: January 2013
Senior Member
Paul,
The only two ways to write back to a db would be writing a servlet or you could import the packages and write back to the DB directly from script similar to how the servlet is setup in the example I posted. I can write an example report showing how to do it from script if you'd like.

-Kris
Re: Update database field when report complete [message #1071463 is a reply to message #1071296] Sat, 20 July 2013 06:43 Go to previous messageGo to next message
Paul Cockerill is currently offline Paul Cockerill
Messages: 12
Registered: August 2012
Junior Member
If you could write a sample report that would be great.

Thanks for your help.

Paul.
Re: Update database field when report complete [message #1085186 is a reply to message #1071463] Mon, 12 August 2013 15:19 Go to previous message
Paul Cockerill is currently offline Paul Cockerill
Messages: 12
Registered: August 2012
Junior Member
Hi Kristopher

Have you been able to write a report to show how to do it from script?

Thanks
Paul
Previous Topic:Newspaper/Multi Column layout in BIRT
Next Topic:How to get hyperlinks in BIRT report viewer
Goto Forum:
  


Current Time: Sat Oct 25 15:20:54 GMT 2014

Powered by FUDForum. Page generated in 0.03822 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software