BIRT Reports - Integration using ResultSet

Is it possible for an integration of the report data through Result Sets to an application?

Is it the correct way to perform the integration? Does the BIRT developer set approve of it? If not, what else are my options?

Find more posts tagged with

Comments

JasonW

Can you give a little more description on what you want to do?

Jason

Clemente

Hi,
I resolved the problem of passing a ResultSet to a report with:

ReportDesignHandle handle = (ReportDesignHandle) runnable.getDesignHandle();
OdaDataSetHandle ds = (OdaDataSetHandle) handle.findDataSet("Data Set");
if (! query.isEmpty()) {
ds.setQueryText("SELECT * FROM TABISCRITTI WHERE "+query);
} else {
ds.setQueryText("SELECT * FROM TABISCRITTI");
}

Where runnable is my rptdesign file opened with:

runnable = engine.openReportDesign(filereport);
and query is a public class variable that I use to query the database and obtain the ResultSet.

I hope this will help you!

Bye
Clemente Carlucci

coolguy

How about passing JDBC resultset as a parameter to the report. <br />
Please refer to <a class='bbc_url' href='http://techieocean.blogspot.com/2009/06/how-to-pass-resultset-to-birt-report.html'>Techie.Ocean: How to pass a ResultSet to BIRT report</a>

JasonW

Great Post!

Jason