how to run a sql-statement in an handler/java resource

shazia

I run birt reports in my web application.<br />
<br />
After the user has specified the parameters in a report, I run a dataset/sql-statement to get some result back. This part is ok.<br />
<br />
<strong class='bbc'>But I want to achieve this:</strong><br />
i want to run another sql-statement to some other database (before the report sql-statement stated over) to validate that the user has the right to run this report with the parameters given.<br />
<br />
Can this be achieved by using a handler ?<br />
<br />
Please guide me how I can access a mysql-database and run sql-statement from an handler, java resource or javascript within a birt report ?

johnw

Yes. There is a validate event handler on parameters you can use. It is also possible to populate parameters with values from a dataset so that the user can only see parameters that they are entitled to. You can override the event handlers on the data set itself to verify that the user has rights to run that query, and throw an exception if they do not.

The easiest route is going to be to only display parameters from a data set that they have access to. Take a look in the Resources/Documentation section of the site. There are plenty of tutorials on how to do data driven parameters in the report developers documentation.