Running custom queries directly from the scriptlet

[muqker]

Hi.

 

I have a stacked bar chart that I need to fill with some data that comes from different queries. There is no way I can get all the data I need for the one chart with only one query.

 

What I would like to do is to have a scriptlet function that executes a number of queries, fetches the results, processes the data and then hydrates the chart. I already have a function that feeds the chart some dummy data, I just need to run the queries and fetch the results.

 

Is this possible? If not, can you suggest any other way to solve this?

 

Some code samples would be greatly appreciated, of course :) , but some URL, documentation, even some class names I can search for would also be great.

 

Thanks.

 

-Mihai

[mshoe]

Here is some code to get you started.

 

It gets the connection the report is using:

 

final java.sql.Connection conn = (java.sql.Connection)getParameterValue("REPORT_CONNECTION");

 

Then using the Connection object just create your Statement object and execute a query.

 

Hope that helps,

Mike

Post edited by: mshoe, at: 2007/12/28 19:59