COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: kapil on 21 Oct 2005 07:15:03 AM

Title: [Solved] Setting page number
Post by: kapil on 21 Oct 2005 07:15:03 AM
i have set PageNumber() function for displaying page no.
but when i go to last page directly it shows '?' mark

how to avoid that?
Title: Re: setting page number
Post by: sir_jeroen on 21 Oct 2005 07:37:59 AM
It's only shown when you scroll down page by page or if you run the report and save it...
Title: Re: setting page number
Post by: BIsrik on 21 Oct 2005 07:40:44 AM
supported document for that...

Srik
Title: Re: setting page number
Post by: otsizh on 21 Oct 2005 08:14:39 AM
BIsrik,
Could you please tell me where I can get more documents about different problems in ReportNet?

thanks
Title: Re: setting page number
Post by: sir_jeroen on 21 Oct 2005 11:41:50 AM
Just goto Cognos support and search the knowledge base...

Btw:
BISrik be carefull with sharing access-restricted data. Next time copy & paste the url to this document.
Title: Re: [Solved] Setting page number
Post by: otsizh on 21 Oct 2005 01:22:55 PM
ReportNet Addict,

Thanks for all your help, and HAPPY BIRTHDAY (tomorrow)!!!
Title: Re: [Solved] Setting page number
Post by: wink on 21 Oct 2005 01:26:34 PM
Hi,

The '?' is shown simply because ReportNet doesn't know how pages there are..... as the report viewer cursors the database instead of doing a complete retrieval....

Think if it this way: if you press the end link in the report viewer the request to the database is more or less: give me the last 100 rows of the resultset.... Report Viewer doesn't know the grand total of resultrows and will therefore show the '?' sign. When using PDF the complete result set is retrieved and therefor all pagenumber are shown. In report Viewer when clicking 'next page' constantly till you reach the end you will see the correct pagenumber as well.....

Regards, vincent