Eclipse BIRT: Problem with number of rows in a dataset

Question

Hello!:-) My new Problem is the following: An sql-query to a database (DB2) returns 1500 rows but BIRT shows me only 500 in the dataset-editior. To count them i used a computed column (Integer) with the following logic:

Total.count(row["VPK"]) I'm using the RCP-Designer (BIRT 2.1.3). How can i get the other rows as well?

Patrick

Answer 1

Hi

In the RCP-Designer preview tab It only ever shows the first 500 rows. Mainly for performance I think. In Eclipse 3.5 (Ganymeade) you can go to Preferences->Report Design->Preview->Data and change the number of rows outputed there.

Or you can try launching as html or web-viewer, and that might not do the 500 row limit.

Once you run it in the correct runtime it wont limit the rows to 500.