How do you limit the no of records output in a report

[user-joe]

I've a sorted report where the user only wants the first 20 records output as a report, is there anyway of restricting / delimiting the number of records output, at the moment the report is to large and NOT required

Thanks

[MFGF]

Hi,

The only viable option I can think of is via filtering - manually selecting the 20 rows to be displayed.  In Report Studio you could add a running-count calculation and filter on this, but Query Studio doesn't seem to support this level of complexity in calculations.

Plan B would be to add the relevant filter into your package using Framework Manager, then simply drag it onto the report.

MF.

[user-joe]

Hi MF

That's how I got around it, ran and sorted the report and then added another filter that then only selected the 20 records required. Only trouble is we'll have to do this each time we run the report.

Thanks for your response and much appreciated

user-joe