ZhumaG
asked on
Crystal Report
Good day,
Please help.
I need to change (if {?Language} = "ENG" then {VERSIONS.VERSION} = 2 else if {?Language} = "RUS" then {VERSIONS.VERSION} = 1) statment to VERSIONS.VERSION IN (COALESCE((SELECT VERSIONS.VERSION FROM VERSIONS WHERE VERSIONS.DOCNUMBER=Profile .DOCNUMBER AND VERSIONS.VERSION=2), 1)) in Crystal reports.
It means the report must show version =2 if exist and if not - version = 1.
Thanks in advance,
Gulshat
Please help.
I need to change (if {?Language} = "ENG" then {VERSIONS.VERSION} = 2 else if {?Language} = "RUS" then {VERSIONS.VERSION} = 1) statment to VERSIONS.VERSION IN (COALESCE((SELECT VERSIONS.VERSION FROM VERSIONS WHERE VERSIONS.DOCNUMBER=Profile
It means the report must show version =2 if exist and if not - version = 1.
Thanks in advance,
Gulshat
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OOO Thanks. Everything is ok now.
ASKER
And in my report parametr Language is string, but here (COALESCE((SELECT "VERSIONS"."VERSION" FROM "AKS_HSE"."DOCSADM"."VERSI
Can I change it to string in SQL expression?