How to write a case statement in crystal

building reports crystal reports
1

Hi,

Can anybody help me how to write a select case statement for the following formula in crystal xir2

If isnull{TB.put_date} =false then {TB.put_date}

Else if (@futureSector)=”AA” or {@futureSector}=”BB” or {TB.security_type}=”ASR” THEN ({TB.next_call_date} else

If isnull({TB.eff_mat_date})=true or @callcheck=”CALL” or @fururesector=”CARE” then {TB.final_mat_date} else
{TB.eff_mat_date}

Thanks,
ram

ram2244 (BOB member since 2008-09-22)

2

A Select/ Case statement is use when referencing one field. In your formula, you check more than one field. If you don’t like the If-Then-Else statement, try using IIF() or Switch().

Example of Case logic:

Select {table.field}
Case “A”:
“Show this”
Case “B”:
“Show that”
Default:
“Show nothing”
;

JBray :us: (BOB member since 2008-07-15)

3

Thank u so much
if u have sample code that would help me a lot

ram2244 (BOB member since 2008-09-22)