Crystal Parameters

[gard0128]

I am creating a report that will allow the user to run the report based on five different criteria using parameters. The trick is that I want all five criteria to default to "all" so that the user only needs to designate values in the field he/she wants to filter on.

Is there a way to set up the parameter so that each will default to "all"? I thought this could possibly be acheived by using a range and populating the start range box with the lowest value and populating the end range with highest value for each field.

It seems, however, that the first value I designated in my default parameter populates both start and end ranges.

Does anyone know how I can acheive this?

Thanks.

 

[MrBillSC]

Set the default value to "all" in each parameter. Then modify your select formula as follows:

(Parm1 = "all" or Parm1 = {table.field1}) and
(Parm2 = "all" or Parm2 = {table.field2}) and ...

You won't need ranges.

MrBill