Print Page - Changing displaying values.

Title: Changing displaying values.
Post by: Srik on 23 Aug 2006 03: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.

Title: Re: Changing displaying values.
Post by: venu4cognos on 28 Aug 2006 12:11:18 AM

use decode

Title: Re: Changing displaying values.
Post by: MFGF on 29 Aug 2006 06: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.

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: Srik on 23 Aug 2006 03:19:09 PM