Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Solved
Crystal Report
Posted on 2012-12-27
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
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
-
2
3 Comments
Create a SQL expression:
(COALESCE((SELECT VERSIONS.VERSION FROM VERSIONS WHERE VERSIONS.DOCNUMBER=Profile
(COALESCE((SELECT VERSIONS.VERSION FROM VERSIONS WHERE VERSIONS.DOCNUMBER=Profile
Featured Post
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.
Join & Write a Comment Already a member? Login.
I hate sub reports and always consider them the last resort in any reporting solution. The negative effect on performance and maintainability is just not worth the easy ride they give the report writer. Nine times out of ten reporting requirements…
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…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment.
Powered …
Suggested Courses
Course of the Month8 days, 4 hours left to enroll
585 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.