Crystal Reports Date Prompt

[Former Member]

I have 2 Prompts in my report. One is the ID and other one is the Date. When the User enters ID all the records should get displayed in the report. In this situation the Date Parameter should be blank. If the user enters ID and DATE then the records with that ID and Date should get displayed in the report. The problem is I am not able to leave the DATE parameter blank. Is there a way to leave the DATE parameter Blank.

[Former Member · Accepted solution]

Technically... No. there is no way to leave the date parameter blank.

You can, however, work around it by following these steps...

#1) Create a new parameter Called UseDate

#2) Set it up to be a simple "Yes"/"No" type parameter.

#3) Move it above the Date Parameter in the parameter list (so that the user will select it before getting to the date prompt).

#4) In the Select Expert, rework your selection formula to look something like this...

IF {?UseDate} = "No" THEN 1=1 ELSE {TableName.DateField} = {?DateParameter}

Basically your using the {?UseDate} parameter to determine weather or not CR will use the date parameter in the record selection.

HTH,

Jason