How to make date parameter optional?

[ekta22]

Hi,

I am using Crystal XI

I have two date parameters on my report and I want to be able to make them optional. Currently, crystal forces me to enter the date.

How can I do this?

Thanks,

E

 

[Turkbear]

Hi,
You could make the parameters text instead and use a conversion formula to use them as dates (supply a default value to show the format you want and test for it in your selection formula if no dates are needed)..

Like:
If this
{?DateStringParam} = 2009,01,01

then in your selection formula you could use something like:

If {?DateStringParam} <> '1900,01,01' [COLOR=green]//your default to ignore date [/color]
then
{Table.DateField} = Date({?DateStringParam})

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

Or you could just use a date that is out of range, as in:

(
(
{?date} <> date(9999,9,9) and
{table.date} = {?date}
) or
{?date} = date(9999,9,9)
)

You would have to add prompt text directing the user that if they don't want to limit the records by date they should enter 9999-9-9.

-LB