How to Select all 1

[charltonc]

Hi

How do you configure parameters to choose to filter for specific values as well as all values?

 

[Turkbear]

Hi
Try

If {?parameter} = "" then
True 
else
{table.field} = {?parameter

Repeat as needed for each parameter...

 

[rhinok]

Turkbear, that code won't be processed on the server.

Charltonc - add an "All" value to your picklist for the parameter and make it the default (first) vavlue. Then, use the following code:

(
  If
    {?Parameter} <> "All"
  Then
    {table.fieldvalue} = {?Parameter}
  Else If
    {?Parameter} = "All"
  Then
    True
)

This code forces Crystal to pass the criteria to the server.


~Kurt

 

[Turkbear]

Hi,
Thanks, I usually use the format you posted, but, for some reason, today I seem to be reverting to the older one I used to use..( Must be having just returned from 2 weeks vacation)

 

[charltonc]

Thanks,
But what does "True" tell Crystal Report to do?

it tells CR to spit out all the values?

 

[Turkbear]

Hi, Basically yes, for the field the parameter is applied to
- all selection critera formulas are treated as Boolean logic - if the criterion is matched, a True is returned, else a False is..By explicitly coding a True, you avoid the overhead of checking the value.

 

[charltonc]

YAY question answered!

Thanks a lot!

 

[rhinok]

I get that way, too Turk;-) Welcome back and hope you had fun!


~Kurt