It is always interesting to be able to limit the number of records that will be received and processed by the report engine.
At least at design time, if you have a huge table, you want to design your report with a small amount of rows for performances reason.

If you are using SQLServer, use the TOP option of the SELECT clause:
will return only the first 100 rows.

Select your model in the TreeView, then edit the Select Clause property and add the after the SELECT


If you are using Oracle, use the rownum restriction in your WHERE clause:
Select your model in the TreeView and add in the Restrictions box.

Edited by user Friday, February 7, 2014 7:15:42 PM(UTC)  | Reason: Not specified

How can we add server side pagination to reports?

also can you please let me know how we can limit the number of records while using SEALMASTERTABLE?
like it fires whole query -> brings result -> applies client side filters on the result.
so each time it fires the whole query on the database.
is there any alternate solution to it?

Hi Admin,

We would like to sponsor it,

can you please provide the details for it.

Note the the new 3.1 versions supports now server side pagination....