> Hello I was wondering if anyone had any good ideas on selecting
> records for crystal reports using the record selector and multiple
> optional and required parameter fields. It seems as if there must be
> an easy way to do this. My attempts at using isnull()do not seem to
> work very well or easily for that matter when I have multiple
> parameters that are optional. Any help with this would really be
> appreciated.

> Thanks,

> Jared Pamperin

> Hi Jared,
>     I have used selection statements like this:
> If not isnull(parameter1) then field1 = parameter1 else true AND
> If not isnull(parameter2) then field2 = parameter2 else true AND...

> This will use the selection criterion if it exists, otherwise it will not
> use that particular field if it is null.

> Bob Holmes

> > Hello I was wondering if anyone had any good ideas on selecting
> > records for crystal reports using the record selector and multiple
> > optional and required parameter fields. It seems as if there must be
> > an easy way to do this. My attempts at using isnull()do not seem to
> > work very well or easily for that matter when I have multiple
> > parameters that are optional. Any help with this would really be
> > appreciated.

> > Thanks,

> > Jared Pamperin