Limited Rows in Report

[Rizwan]

In the report, is there any way to setup a limitation of rows. As known, Package allows to setup limitation of rows, but this setting is for all users.
Appreciated, Thanks..

[Bark]

Hi,

You could filter the query with a "running-count". Add a detail filter with: running-count([oneOfTheFields]) < N.

Regards,

Bark

[blom0344]

You'd better think this through for a moment. What good would it do to generate partial results? What is the reason to set this limit? This could be a major flaw leading to catastrophic decisions based on partially produced output..

[Rizwan]

The idea was to view the result with limited data, as the data could be in million, and before running the query for full data view the limited data to ensure the query is responding with correct data and formating. So decided to run the query with the limited Date Range to view the data.
Thanks to all.

[MFGF]

This facility does exist, if the modeller has defined Design Mode filters on your query subjects in the model. Select the dropdown next to the run button in Report Studio and select Run Options, then in the Data Mode dropdown, select 'Limited Data'. This will activate the Design Mode filters and hopefully limit the data in your report (assuming they are what you need).

Cheers!

MF.