« previous next »
Pages: [1]

Author Topic: Changing displaying values.  (Read 633 times)

Offline Srik

  • Senior Member
  • ****
  • Posts: 71
  • Forum Citizenship: +0/-0
Changing displaying values.
« on: 23 Aug 2006 02:19:09 pm »
Hi All,

Can any one help in  acheive below requirement.

I had a "status" filed in report which can have below states :
Passed, Rejected, EPayment, Payment, Pending, Inactive

when state is  Passed,Rejected,EPayment, Payement    Status in report should display  as "Active"

Thanks in advance.

Kanth.
Logged

Offline venu4cognos

  • Associate
  • **
  • Posts: 4
  • Forum Citizenship: +0/-0
Re: Changing displaying values.
« Reply #1 on: 27 Aug 2006 11:11:18 pm »
use decode
Logged

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Posts: 3,112
  • Forum Citizenship: +153/-3
  • Cognos Software Muppet
Re: Changing displaying values.
« Reply #2 on: 29 Aug 2006 05:23:53 am »
Create a calculated field for display, which uses either if/then/else syntax or case/when syntax.

eg if (status in ('Passed','Rejected','EPayment', 'Payement)) then ('Active') else (status)

Regards,

MF.
Logged
Meep!
Pages: [1]
« previous next »