[news.eclipse.newcomer] Use java class as a datasource

[tcheong3@xxxxxxxxx (Tae Su Cheong)]

Hi... I just start to learn how to use BIRT because I need to generate 
nice reports with less programming in our project. 

Anyhow, I encounter a problem. My report contents cannot be obtain by just 
querying SQL to DB. I need to extract some statistical summary (a list of 
summary results) from Query ResultSet and then display the information on 
the BIRT report. 

Thus, I decided to define two basic java class,
(i) a value object 'A' representing the statistical summary and 
(ii) a java class 'B' defined a method 'q' which consists of JDBC methods 
so that I can obtain a DB result set. In the method, I execute a SQL query 
and get a result set and then I work on processing on the resultset to 
obtain a list of statistical summary 

and I would like to get results from java class and display them on the 
report.

In order to use the list of java value object for the report, I create a 
data source with "scripted data source" option and also create a data set 
so that I can obtain the list of statistcal summary by calling the java 
class 'B.q()' on 'open()' and 'fetch()' pre-defined function(or property 
of 'data set'). 

The problem is that BIRT throws an exception related to reflection error. 
In order to check the programming fault, in the method 'q' of the java 
class 'B', if I return the list of value objects 'A' with dummy data (not 
created by DB query), BIRT displays the result without any problem.

I would like to know what kind of problem I have. Do I need to add 
external jar files in the BIRT report project? But, I couldn't find any UI 
for that.

BIRT doesn't support this kind of approach?

Would you please help me? It's very important for our project.

I have a workspace consisting of two project - one for java project and 
the other for report project....and I need to use BIRT report designer.

Thank you in advance.