-
July 3rd, 2009, 10:43 AM
#1
Using the ALL Option
Hallo,
I have the following crystal report formulae which is not working presently. What I want to do is the user can select a system version at the drop down or select all to bring all the system versions ONLY on the list.
However, this formulae brings all the system versions in the database even those not listed in the drop list. Any help please!!!
(if {?System Version} = "ALL" then TRUE
else {DistinctGP27.CLINCOMP} = {?System Version} or
{DistinctGP27.CLINCOMP} = "In Vision" or
{DistinctGP27.CLINCOMP} = "INPS London (Vision)" or
{DistinctGP27.CLINCOMP} = "INPS Vision" or
{DistinctGP27.CLINCOMP} = "IPS" or
{DistinctGP27.CLINCOMP} = "IPS In Vision 3" or
{DistinctGP27.CLINCOMP} = "IPS Reuters Surgery Mgr" or
{DistinctGP27.CLINCOMP} = "IPS Reuters Vamp" or
{DistinctGP27.CLINCOMP} = "IPS Reuters Vision" or
{DistinctGP27.CLINCOMP} = "IPS Reuters Vision 2.1" or
{DistinctGP27.CLINCOMP} = "IPS Vision" or
{DistinctGP27.CLINCOMP} = "IPS Vision 3" or
{DistinctGP27.CLINCOMP} = "ips viso" or
{DistinctGP27.CLINCOMP} = "Vamp Vision" or
{DistinctGP27.CLINCOMP} = "Vamp Vision (INPS)" or
{DistinctGP27.CLINCOMP} = "Vamp Vision INPS" or
{DistinctGP27.CLINCOMP} = "Vision" or
{DistinctGP27.CLINCOMP} = "Vision 3" or
{DistinctGP27.CLINCOMP} = "Vision in Practice")
-
July 3rd, 2009, 11:51 PM
#2
Re: Using the ALL Option
Try changing it from an if else statement to a select case statement. That works great for me.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|