Binding same dataset for 2 different tables

aswin

Hi all,

I have recently migrated from BIRT 2.1 to BIRT 2.3. The problem I am having is, I have a dataset that returns a status column along with other columns.the status could be any one of "Delivered","Failed", "QUEUED" etc..I needed to show the consolidated count of no.of messages delivered, failed queued etc. For this, I have bound the same dataset which I have got to a different table on the top of the datatable and wrote some code in dataset`s onFetch method. The code will have an if condition that matches the strings and depending upon what it is, it will increment the respective variable. Then, I am storing the total count into a report parameter and displaying this report parameter(parameters one for each status) in a table. This worked fine in 2.1. And also works fine when I preview the report in eclipse. Even works fine when I view report in eclipse`s default browser.But when I view report from my application, it dosent. It gives me an exception saying " java.sql.SQLException: setMaxRows() out of range. 2147483647 > 50000000. " I did try changing the setMaxRows() property that is visible when I preview the report to 2147483647 also, but that didnt work.Can any one please tell me is there any other location where I have to change this property?Am i doing it in the wrong place as it works only when I preview report in eclipse? Or is it a bug? Kindly help me out as it is critical for me, because something that worked in previous release should nt stop working in a new version(Both in the context of BIRT and also my reports) Any help(immediate will be really great) will be greatly useful for me.Thanks in advance.

Regards,
Aswini.

rogertu

It's just a bug with BIRT2.3.0., see<br />
<a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=247799'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=247799</a&gt;