0 Replies Latest reply on Mar 15, 2010 1:08 PM by Diego Di

    Paginated Hibernate data source

    Diego Di Newbie
      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