Status: Solved
Priority: Medium
Security: Public
Views: 439
Last Modified: 2012-12-28

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

ZhumaG

Asked: 2012-12-27

Advertise Here

Crystal Reports

1 Solution

LVL 18

vastoCommented: 2012-12-27

Create a SQL expression:
(COALESCE((SELECT VERSIONS.VERSION FROM VERSIONS WHERE VERSIONS.DOCNUMBER=Profile.DOCNUMBER AND VERSIONS.VERSION=2), 1))

ZhumaGAuthor Commented: 2012-12-28

Thanks a lot.
And in my report parametr Language is string, but here (COALESCE((SELECT "VERSIONS"."VERSION" FROM "AKS_HSE"."DOCSADM"."VERSIONS" "VERSIONS" WHERE "VERSIONS"."DOCNUMBER"="PROFILE"."DOCNUMBER" AND "VERSIONS"."VERSION"=2), 1)) it returns int.
Can I change it to string in SQL expression?

ZhumaGAuthor Commented: 2012-12-28

OOO Thanks. Everything is ok now.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Crystal Report

Join & Write a Comment Already a member? Login.

Featured Post