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:

Code:

select top 100 from aTable

will return only the first 100 rows.

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

Code:

TOP 100

after the SELECT

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

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?

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.