nice2cu Posted September 30, 2009 Share Posted September 30, 2009 Hi,i make an Application with Oracle APEX and make an HTML tunnel from APEX to JASPER Server to print invoices.What i want, in the invoices table the invoices have an Status PRINTED=0With iReport query i open this not printet invoices and generate an PDF.So, all is nice working :-)But i want that i want an SQL UPDATE statement in iReport (later jasper server) to set this PRINTED=1Did anybody hnow how i can do this?????? Greetings, Robert Link to comment Share on other sites More sharing options...
svenn Posted September 30, 2009 Share Posted September 30, 2009 You can create a Scriplet with the Java code required to perform a database update. Link to comment Share on other sites More sharing options...
nice2cu Posted September 30, 2009 Author Share Posted September 30, 2009 ufff, i have total not expiriences with this. what it that and how i can create this? Link to comment Share on other sites More sharing options...
svenn Posted September 30, 2009 Share Posted September 30, 2009 First you need to know a bit of Java.Try looking at the examples herehttp://jasperforge.org/website/jasperreportswebsite/JR%20Website/jasperreports_samples.html?group_id=252&header=project&leftnav=yes&target=jasperreports Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now