COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: rajvivan on 19 Apr 2015 02:32:11 AM

Title: Unable to generate the Page number in the form of 1A,2A
Post by: rajvivan on 19 Apr 2015 02:32:11 AM
Dear Readers,
Could anyone please correct my understanding as I am unable to generate the Page number in the form of 1A,2A.
Even  I followed the exact process.The output is appearing in the Form of 1 ,2 ,3 etc (page Number).But When I Selected the Format
1 of 3, I am able to see the result in correct format.
Please advise me.
Attaching the screenshot for your reference

Note: I am able to generate the  Page number in the form of 1A,2A  by using the Custom Number Style but not able to achieve by suing the PRESET PAGE NUMBERING TECHNIQUE or LAYOUT CALCULATION

The code which i used for Layout calculation ,it is not giving any error but not showing the desired result also.

if (HorizontalPageCount ()=1)
then
(number2string (PageNumber ()))
else
(number2string(PageNumber ()))
+'('+ (mapNumberToLetter ('A',HorizontalPageNumber ()-1))+')'
Title: Re: Unable to generate the Page number in the form of 1A,2A
Post by: rajvivan on 19 Apr 2015 02:46:28 AM
Able to generate the Page Numbering by using the Custom Number Style.
Attaching the screenshot for your reference
Title: Re: Unable to generate the Page number in the form of 1A,2A
Post by: rajvivan on 21 Apr 2015 02:49:06 PM
any help would be greatly appreciated?
Title: Re: Unable to generate the Page number in the form of 1A,2A
Post by: bdbits on 22 Apr 2015 09:10:18 AM
If you did not know it already, Cognos will not show you the page numbers in the browser in HTML view because it fetches one page at a time. To see page numbers, you can view the report in PDF.

That said, what is not working for you?

I assume you have a page overflowing horizontally to the next page, so you want to see 1-A, 1-B, 2-A, 2-B, etc. The built-in page number styles work fine for that, I just threw together a quick demo using all columns from the Product table from the Cognos samples and it worked fine with a built-in style "1-A". I've attached the report spec.