Print Page - I have a problem in the this nested iff

Title: I have a problem in the this nested iff
Post by: katdbc on 23 Sep 2010 10:48:37 PM

i have written this access and they want to replicate it in the report studio.

IIf([MORIS_CONTRACT_MONTHLY]![CREDIT_GRADE_CD]<>"0",[MORIS_CONTRACT_MONTHLY]![CREDIT_GRADE_CD],IIf([MORIS_CONTRACT_MONTHLY]![CREDIT_TIER]="01","A",IIf([MORIS_CONTRACT_MONTHLY]![CREDIT_TIER]="02","A",IIf([MORIS_CONTRACT_MONTHLY]![CREDIT_TIER]="03","B",IIf([MORIS_CONTRACT_MONTHLY]![CREDIT_TIER]="04","B",IIf([MORIS_CONTRACT_MONTHLY]![CREDIT_TIER]="05","C",IIf([MORIS_CONTRACT_MONTHLY]![CREDIT_TIER]="06","C",IIf([MORIS_CONTRACT_MONTHLY]![CREDIT_TIER]="07","C",IIf([MORIS_CONTRACT_MONTHLY]![CREDIT_TIER]="08","D",IIf([MORIS_CONTRACT_MONTHLY]![CREDIT_TIER]="09","D",IIf([MORIS_CONTRACT_MONTHLY]![CREDIT_TIER]="10","E","")))))))))))

how do i do this in report studio.!!!!1ill be extremly gald if u guys can help!!

Title: Re: I have a problem in the this nested iff
Post by: technomorph on 24 Sep 2010 05:23:06 AM

IIF Syntax:

IIF(Exp, True, False)

Just use a Case Statement:

CASE
WHEN [CREDIT_GRADE_CD] <> '0' THEN [CREDIT_GRADE_CD]
WHEN [CREDIT_TIER]='01' THEN 'A'
...
[ ELSE <expression> ]
END

Title: Re: I have a problem in the this nested iff
Post by: katdbc on 24 Sep 2010 09:32:34 AM

Thank you.
that worked really fine!!!
i tried t o use the nested if.but looks like that doesn work!!!!!

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: katdbc on 23 Sep 2010 10:48:37 PM