If paramater 1 = Complete then enter parameter 2 - date range

[CrystalLion]

How do I set up parameter to do the following

If the user wants to see "Completed" WIP then ask for a date range. If the user wants to see "Incomplete" WIP, don't ask for a date range.

Any help is appreciated.
Thanks

 

[lbass]

If "WIP" is incomplete, does it mean that the date is null for those records? If so, you could use a formula like this:

(
(
{?complete} = 'No' and
(
isnull({table.date}) or
{table.date} = date(0,0,0)
)
) or
(
{?complete} = 'Yes' and
{table.date} = {?daterange}
)
)

-LB

 

[CrystalLion]

Thanks LBass. I will try it tomorrow morning when I get to work.