Symptom
- No calendar available to enter a date in Crystal Reports.
- Date prompt displays as text in Crystal Reports.
- BEx Query date variable are converted to a string parameter in Crystal Reports.
- Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
- SAP Crystal Reports 2025
Reproducing the Issue
- In BEx Query Designer, create a BEx Query and add a date variable in the filters.
- In Crystal Reports, create a report off the BEx Query that use a date variable. ( MDX )
- When refreshing the report in Crystal Reports, it prompts for the date, but there is no calendar available to enter the date, you have to type the date manually.
Cause
- When reporting off an SAP BEx Query in Crystal Reports, for each date variable, it will create a string parameter, and since it is a string there is no calendar to enter a date when being prompted by the parameter in Crystal Reports. This is unfortunately normal behavior.
Resolution
- There is unfortunately no workaround in Crystal Reports to display a date calendar to enter a value for a date variable.
- This functionality exist in Crystal Reports 2025 when connecting via a BICS connection to SAP BW. When reporting off a BW Query that contains date variables in Crystal Reports 2025 using a BICX connection, it does displays a calendar for date variable value selection.
Keywords
CR, date , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; SAP Crystal Reports 2025