Using Birt to update mysql table

I know this sounds like a tall order but if somebody could help this out I would be very thankful to you all.

I have 5 report parameters letc call them p1 p2 p3 p4 p5

p1 is the database name
p2 to p5 are my inputs

now I have an mysql table called say T1

what I want to do is have a birt report with p1 p2 p3 p4 p5 as report parameters
and then after the user has input or selected P1 P2 p3 p4 p5 I want to take them and insert a record into the table T1

The table T1 is in the report so that the user can view the data input

thanks

Find more posts tagged with

Comments

birtq

Hi,

Is this is wat you are looking for?

have a look at the attachment.

Regards,
birtq

Lesbea

<blockquote class='ipsBlockquote' data-author="birtq">Hi, 
 
Is this is wat you are looking for? 
 
have a look at the attachment. 
 
Regards, 
birtq</blockquote>
 
I understand how to show parameters on a report that is the easy bit. 
 
I wanted to know if it was possible for JAVA/SQL script to use the parameters to insert a record into a MYSQL table as part of the BIRT report process.

aswin

Probably you can call a stored procedure to do this for you?