I have a problem in the this nested iff

[katdbc]

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!!

[technomorph]

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

[katdbc]

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