BIRT doesn't fetch all rows

twi · 2008-06-03T02:47:23+00:00

Hi there, I've got the problem, that BIRT doesn't fetch all rows from data source. With BIRT I get 499 rows and with the same SQL direct on the database I get 845. In the settings of the data set "Fetch all rows from data source" is selected. Anyone an idea to solve this problem?

twi

Hi there,

I've got the problem, that BIRT doesn't fetch all rows from data source.
With BIRT I get 499 rows and with the same SQL direct on the database I get 845.
In the settings of the data set "Fetch all rows from data source" is selected.

Anyone an idea to solve this problem?

Find more posts tagged with

Comments

mennovh

Have you checked the "maximum number of rows to display" setting in the preferences?

Open the preferences and type data in the filter field. Then select the last option in the tree (Report Design-->Preview) and check the value.

twi

Thanks for your reply.

This was exact the setting that I needed.