parameters: select 1 or many or return none

[Steve187]

Crystal Reports XI --- SQL 2005

I would like to prompt the user if they would like to search by 'start.date', if they choose no i don't want to return the 'start.date' on the report at all, if they choose yes I would like the report to return a start date of their choosing.

 

[lbass]

I think you could just set this up the usual way, with an established default that is outside of the available date range:

(
if {?date} <> date(9999,9,9) then
{table.date} = {?date} else
if {?date} = date(9999,9,9) then
true
)

Then for display purposes, create a formula to use instead of the date field:

if {?date} <> date(9999,9,9) then {table.date}

-LB