1825528 - No calendar available for SAP BW Query Date Variable in Crystal Reports

• 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.

• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
• SAP Crystal Reports 2025

1. In BEx Query Designer, create a BEx Query and add a date variable in the filters.
2. In Crystal Reports, create a report off the BEx Query that use a date variable. ( MDX )
3. 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.

• 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.

• 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.

CR, date , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; SAP Crystal Reports 2025