Parameters (Range and Decrete Values) Crystal 8.5

[kabtjb]

I have created a parameter in Crystal 8.5 that is able to run a range value or a dicrete value seperately, but I need the parameter to allow the user to have the option of running both a range value and dicrete value at the same time. When I try to run the parameter using both a range value and a dicrete value it just returns the dicrete value. Any suggestions?

 

[vidru]

What does your record selection formula look like? It should look something like:

{Table.Field} in {?Parameter}

-dave

 

[kabtjb]

Here is an example of what my record selection formula looks like:

{Table1.Field} in ["A", "B", "C"] and
{Table1.Field} in DateTime (2002, 10, 01, 00, 00, 00) to DateTime (2003, 09, 30, 23, 59, 59) and
{Table2.Filed} = {?Parameter}

 

[vidru]

Did you try changing this: {Table2.Filed} = {?Parameter}
to this: {Table2.Filed} in {?Parameter}
?

-dave

 

[kabtjb]

That was it!! Thank you so much!! The word 'in' wasn't in the drop down menu options, but when I typed it in the actual formula it worked!! Thanks again!!