SAP Knowledge Base Article - Public

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

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

  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.

Date Parameter - 02.png

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