SELECT EXPERT FORMULA

[cguyreports]

I am using crystal 8.5 and trying to write a formula in the select expert that will use my parameter field. What I have are two choices in my parameter field and when the run the report they can select one choice from the parameter, but I need them to beable to select a choice like "All Cards" that way they won't have to select manuall all the cards.

Any help would be great. Thanks.

 

[GJParker]

This questions been asked many times before.

Check out synapsevampire's faq "Optimizing SQL Pass Through using the Record Selection Formula":
FAQ767-3825


HTH


Gary Parker
MIS Data Analyst
Manchester, England

 

[cguyreports]

Thanks, I have tried that but the problem I am experiencing is when 'ALL' is selected it is bring back everything and not the two items I have in my parameter.

 

[lbass]

Try something like:

if {?parm} = "All" then
{table.field} in ["Parmchoice1","Parmchoice2"] else
if {?parm} <> "All" then
{table.field} = {?parm}

-LB

 

[cguyreports]

Thanks, that works great!