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.