Birt Javascript plug-in ?

Lesbea

Has anyone developed a method to use SQL INSERT into a MYSQL as a script within BIRT. My idea is to use report parameters as a means to capture input from the report user and then to store the data in a MYSQL table.

This feature although is not a reporting feature would in some allow a 'logging' feature of what parameters were used to run a report. Which could subsequently be reported on.

I am stuck at present as I cannot find any use of writing to a table in any Birt script information. Surely the use of SQL is not 'fixed' to be just one way i.e. retrieval from a database in the BIRT usage of Rhino.

Virgil Dodson

Hi Lesbea,<br />
<br />
Since BIRT allows you to run your own Java or Javascript code, there is nothing stopping your from creating a JDBC connection, and INSERTing into a database when a BIRT report runs. Just pick an event, like the onCreate of a table and try your code. <br />
<br />
I found a page on the net for creating a JDBC connection with Rhino script that help get you started.<br />
<a class='bbc_url' href='http://developer.mozilla.org/En/Server-Side_JavaScript/Walkthrough'>Back to the Server: Server-Side JavaScript On The Rise - MDC</a><br />
<br />
Let us know how it turns out.