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)
Is it like to Use Case Statement ??????????
Correct me......
Quote from: Divya S on 14 Dec 2011 06:33:12 AM
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.
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
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)