Report expression

[learnflower]

Hi ,
I want to display the Line of business according to the product code in a Report Expression

Please help me on this
eg : Depending of the Policy product:
= 'MARINE' for policy product equal to MAR
= 'CORPORATE' if policy product in (GP,RP,SP,AP,YP)
= 'AVIATION' policy product in (IP,CP)

[Gyana.Sahoo]

Is it like to Use Case Statement ??????????

Correct me......

[MFGF]

Hi ,
I want to display the Line of business according to the product code in a Report Expression

Please help me on this
eg : Depending of the Policy product:
= 'MARINE' for policy product equal to MAR
= 'CORPORATE' if policy product in (GP,RP,SP,AP,YP)
= 'AVIATION' policy product in (IP,CP)

if ([policy product] = 'MAR') then ('MARINE') else
if ([policy product] in ('GP','RP','SP','AP','YP')) then ('CORPORATE') else
if ([policy product] in ('IP','CP')) then ('AVIATION') else
('OTHER')

MF.

[learnflower]

Thanks MFGF ,

But i am getting error for this if condition , the error is RSV-VAL-0002 Invalid expression and also CRX-YXX-4010 Parsing error on or around position 49 in the expression as i am taking product code from the query.

Please guide me on this

[blom0344]

Report expressions work within the local context of a report. You can reference parameter values etc, but not query items. You can use the logic provided and use it in a datacontainer.

Why are you trying to write a report expression based on fetched data anyway?  Unless you fetch just one row, you will always have a set returned (to be displayed)