Solved

Crystal Report

Posted on 2012-12-27
3
411 Views
Last Modified: 2012-12-28
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
0
Comment
Question by:ZhumaG
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
vasto earned 500 total points
ID: 38726168
Create a SQL expression:
(COALESCE((SELECT VERSIONS.VERSION FROM VERSIONS WHERE VERSIONS.DOCNUMBER=Profile.DOCNUMBER AND VERSIONS.VERSION=2), 1))
0
 

Author Comment

by:ZhumaG
ID: 38726297
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?
0
 

Author Comment

by:ZhumaG
ID: 38726369
OOO Thanks. Everything is ok now.
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question