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

Title: How do you limit the no of records output in a report
Post by: user-joe on 05 Feb 2010 05:33:47 AM

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

Title: Re: How do you limit the no of records output in a report
Post by: MFGF on 09 Feb 2010 05:08:29 AM

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.

Title: Re: How do you limit the no of records output in a report
Post by: user-joe on 09 Feb 2010 07:46:44 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Query Studio => Topic started by: user-joe on 05 Feb 2010 05:33:47 AM