I 've been spending almost a week trying to create a paginated report with an Hibernate data source and a data set. The main problem we have is that our tables are dammed huge and we have to report them entirely!, so we MUST implement paginated queries to avoid bringing the whole table.
I tried setting the "Max results" parameter in the Hibernate data source and the "Max number of rows to fetch from data source" on the data set, but it seems to ignore theese parameters as the query that is excuted brings the whole table.
Does anyone faced a similar problem?
My las resort is to run the HQL right from java, create that way a dataset and somewhow pass this data set to the report.
Any help will be useful
Thanks in advance
