Author Topic: Concatenate PageNumber and PageCount  (Read 899 times)

Offline ADW

  • Full Member
  • ***
  • Posts: 5
  • Forum Citizenship: +0/-0
Concatenate PageNumber and PageCount
« on: 23 Oct 2007 02:54:54 am »
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?

Offline COGNOiSe administrator

  • Administrator
  • Statesman
  • ******
  • Posts: 677
  • Forum Citizenship: +31/-8
    • BrightStar Partners, Inc
Re: Concatenate PageNumber and PageCount
« Reply #1 on: 23 Oct 2007 06:10:21 am »
If their only purpose is to be displayed, then just put them separately on the report.

Offline ADW

  • Full Member
  • ***
  • Posts: 5
  • Forum Citizenship: +0/-0
Re: Concatenate PageNumber and PageCount
« Reply #2 on: 23 Oct 2007 09:14:46 pm »
Humm, you'd think that would be something that everyone would want to see. Thanks!

Offline COGNOiSe administrator

  • Administrator
  • Statesman
  • ******
  • Posts: 677
  • Forum Citizenship: +31/-8
    • BrightStar Partners, Inc
Re: Concatenate PageNumber and PageCount
« Reply #3 on: 23 Oct 2007 11:50:26 pm »
Fair enough ... did you try number2string(PageNumber()) + number2string(PageCount()) but that might be actually a Cognos 8 report function.

Offline ADW

  • Full Member
  • ***
  • Posts: 5
  • Forum Citizenship: +0/-0
Re: Concatenate PageNumber and PageCount
« Reply #4 on: 24 Oct 2007 03:44:22 am »
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.

Offline COGNOiSe administrator

  • Administrator
  • Statesman
  • ******
  • Posts: 677
  • Forum Citizenship: +31/-8
    • BrightStar Partners, Inc
Re: Concatenate PageNumber and PageCount
« Reply #5 on: 24 Oct 2007 09:52:15 pm »
In Cognos 8, the function is available in the report functions tree node.