-
August 21st, 2009, 06:03 AM
#1
Formulae problem
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
(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"
-
August 21st, 2009, 03:02 PM
#2
Re: Formulae problem
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
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
|