Problem with the formulae
Hallo,
I have the following crystal report formulae, which gives me a blank output results when "ALL" is selected at runtime. I want to display all the climcomps shown below if the option "ALL" is selected. Please could anyone tell me where the problem i.. Thanks
Code:
(if {?By System Version} = "ALL" then TRUE
else {DistinctGP27.CLINCOMP} = {?By System Version}) and
{DistinctGP27.CLINCOMP} ="In Vision" and
{DistinctGP27.CLINCOMP} ="INPS London (Vision)" and
{DistinctGP27.CLINCOMP} ="INPS Vision" and
{DistinctGP27.CLINCOMP} ="IPS" and
{DistinctGP27.CLINCOMP} ="IPS In Vision 3" and
{DistinctGP27.CLINCOMP} ="IPS Reuters Surgery Mgr" and
{DistinctGP27.CLINCOMP} ="IPS Reuters Vamp" and
{DistinctGP27.CLINCOMP} ="IPS Reuters Vision" and
{DistinctGP27.CLINCOMP} ="IPS Reuters Vision 2.1" and
{DistinctGP27.CLINCOMP} ="IPS Vision" and
{DistinctGP27.CLINCOMP} ="IPS Vision 3" and
{DistinctGP27.CLINCOMP} ="ips viso" and
{DistinctGP27.CLINCOMP} ="Vamp Vision" and
{DistinctGP27.CLINCOMP} ="Vamp Vision (INPS)" and
{DistinctGP27.CLINCOMP} ="Vamp Vision INPS" and
{DistinctGP27.CLINCOMP} ="Vision" and
{DistinctGP27.CLINCOMP} ="Vision 3" and
{DistinctGP27.CLINCOMP} ="Vision in Practice"
Re: Problem with the formulae
Try the next
Code:
({?By System Version} = "ALL") OR
({DistinctGP27.CLINCOMP} = {?By System Version} AND {?By System Version}<>"ALL")
Fill your parameter array with all the system versions, of course