Skip to Content
Former Member
Oct 20, 2008 at 07:24 PM

Crystal Reports Date Parameter


I have a report with multiple subreports. I need to add a parameter in the main report that links to the subreports with a date that is not dynamic. I am wanting the user to be able to enter a date in the format of MM/DD/YYYY and pull all values from the database field that are greater than or equal to the date they request.

Every time I am on the main report and try to change the link to the parameters on the subreport, it wipes out anything I enter in the "Select data in subreport based on field". If I make the assumption that it saves it correctly and I go to the subreport and use the Select Expert to try to add another criteria to limit the data displayed, the parameter is not a valid option to set the field equal to. Instead I have all of the dynamic values from the database as options. All I want is to set the values in the field greater than or equal to the parameter the user enters.

Does anyone know what I have to do to accomplish this? I'm at my wits end on this one.

Thanks in advance for your replies.