Using the ALL Option

[dr223]

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")

[jade1977]

Try changing it from an if else statement to a select case statement. That works great for me.