doubt on Crosstab

Hi, I am now using Version: 2.2.1 BIRT-crosstab function to build a report.
The details are sth like that:
Dataset : Dataset_1, Dataset_2, Dataset_3,
all of them contain 2 params (datefrom, dateto) adding by before open script on each dataset.
And 2 joint dataset (joint_a, joint_b):
joint_a is form by join Dataset_1 and Dataset_2
joint_b is form by join joint_a and Dataset_3.

After built the report, the data is correct in the first preview.
(Let say the params datefrom=20080101, dateto=20080105 are used in the first run)
And while trying to have a second run with diff. params value, the result still remain the first run one whatever which date range used.

And I found that the report result run correct after close and re-launch the eclipse platform. and the time it still only correct at the first run.

since I am new in using crosstab, can anyone give me some suggestions to solve the problem.

thanks alot

Find more posts tagged with

Comments

mwilliams

Hi kennethhui, 
 
It looks like there were some issues with crosstabs, parameters, and data caching in BIRT 2.2. Both of these bugs having to do with crosstabs and parameters were set to be fixed in the latest release, BIRT 2.3. 
 
<a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=205621'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=205621</a> 
 
<a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=211219'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=211219</a> 
 
Hope this helps.