If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Unable to generate the Page number in the form of 1A,2A

Started by rajvivan, 19 Apr 2015 02:32:11 AM

Previous topic - Next topic

rajvivan

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))+')'

rajvivan

Able to generate the Page Numbering by using the Custom Number Style.
Attaching the screenshot for your reference

rajvivan


bdbits

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.