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.
Brian Dong replied
If your subreport does not have a field that matches the same type as the parameter field, you cannot link it.
I've gotten around this problem by creating a formula in the subreport that returns the same datatype as the parameter. In your case, just create a formula and use Today. You should be able to link on this formula now and then go into the Record Selection Formula to use the parameter how you need.