Selecting all records even if they are null 1

[redsand]

I am trying to use a parameter called {?ParamELO]} to select all records even if the field is null. I am not sure of the syntax to select all records("???&quot. Also can you use radio buttons or check boxes in parameters?

IIF ({?ParamELO} = "All",{QryRep.ELO} = "???",
{QryRep.ELO} = {?ParamELO})


One last item, other than using an active server page or crystal web report viewer to qualify your parameters, is there any other interface to qualify your parameters.


Any help would be greatly appreciated.

 

[dgillz]

Try this:

If {?ParamELO}="All" then true else {QryRep.ELO}={?ParamELO}


Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com