Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

replied

Hi Paula,

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.

Good luck,

Brian

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question