Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » Update database field when report complete
Update database field when report complete [message #1065978] Fri, 28 June 2013 11:16 Go to next message
Eclipse UserFriend
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 17:09 Go to previous messageGo to next message
Eclipse UserFriend
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 10:50 Go to previous messageGo to next message
Eclipse UserFriend
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 15:17 Go to previous messageGo to next message
Eclipse UserFriend
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 02:43 Go to previous messageGo to next message
Eclipse UserFriend
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 11:19 Go to previous message
Eclipse UserFriend
Hi Kristopher

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

Thanks
Paul
Previous Topic:WebViewer on RAP
Next Topic:How to get hyperlinks in BIRT report viewer
Goto Forum:
  


Current Time: Sun Mar 16 10:06:39 EDT 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly