COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: ADW on 22 Oct 2007 03:54:54 PM

Title: Concatenate PageNumber and PageCount
Post by: ADW on 22 Oct 2007 03:54:54 PM
I am trying to concatenate the report page numbers with the page count; however, I keep receiving this error "Parsing error on or around position 12 in the expression: 'PageNumber()||PageCount()'  ".  I have tried to use the CAST function with this expression and still receive errors. Can anyone provide some assistance on this issue? Can this be done?
Title: Re: Concatenate PageNumber and PageCount
Post by: COGNOiSe administrator on 22 Oct 2007 07:10:21 PM
If their only purpose is to be displayed, then just put them separately on the report.
Title: Re: Concatenate PageNumber and PageCount
Post by: ADW on 23 Oct 2007 10:14:46 AM
Humm, you'd think that would be something that everyone would want to see. Thanks!
Title: Re: Concatenate PageNumber and PageCount
Post by: COGNOiSe administrator on 23 Oct 2007 12:50:26 PM
Fair enough ... did you try number2string(PageNumber()) + number2string(PageCount()) but that might be actually a Cognos 8 report function.
Title: Re: Concatenate PageNumber and PageCount
Post by: ADW on 23 Oct 2007 04:44:22 PM
No, I didn't try that!!  :o I'm new to the application and learning all the time. I will give it a shot and see.
Title: Re: Concatenate PageNumber and PageCount
Post by: COGNOiSe administrator on 24 Oct 2007 10:52:15 AM
In Cognos 8, the function is available in the report functions tree node.