COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: everlearner on 18 Jun 2012 06:10:40 AM

Title: how to display number of records and pages in output
Post by: everlearner on 18 Jun 2012 06:10:40 AM
Hi gurus,

my report has more than 5000 records and 15pages.
i want to display in the o/p like as below 4500 of 4500 records and 14 of 15pages.
where i can set this properties? any one explain me. thanks
Title: Re: how to display number of records and pages in output
Post by: hemantsoni on 18 Jun 2012 07:18:28 AM

In the page footer section select the page number and change the number style to:1 of 3.

OR
Place a text item change the source type to report expression and in report expression window drag and drop PageNumber() function.
Similarly,place PageCount() function there and Place a text 'Of' in b/w them.
Title: Re: how to display number of records and pages in output
Post by: MFGF on 18 Jun 2012 07:58:09 AM
Just be aware that this will only work in fully-rendered report outputs. If you are running a report interactively using HTML rendering, the report renders only one page at a time, and therefore will not have any vision of the pagecount etc.

Regards,

MF.
Title: Re: how to display number of records and pages in output
Post by: hemantsoni on 18 Jun 2012 08:22:58 AM

yeah..Whate evere has been stated above is absolutely correct..