SAP Knowledge Base Article - Public

1295240 - If the calendar is disabled by replacing 'D' with 'A' in @prompt function, no data is returned in Crystal Report Designer.

Symptom

  • In dynamic prompt the calendar is disabled by replacing 'D' with 'A' in @prompt function in Universe.
  • When the date is manually added while refreshing the report no data is returned in Crystal Report Designer.

Reproducing the Issue

  1. Create a report based on Universe.
  2. Create a dynamic date prompt in Universe using @prompt.
  3. Replace 'D' with 'A' in @prompt definition to disable calender.
  4. Set the date field of the Parameter in Universe to date and in Crystal Reports alphanumeric.
  5. Run the query in Crystal Reports designer.

Crystal Reports XI Release 2.

Cause

This is a default behavior in Crystal Report Designer. An Enhancement Request has been submitted with the reference ID: ADAPT01175226.

Resolution

The Enhancement Request will be reviewed in terms of future product development when considering possible new features in next major release.

Workaround:

  1. Create a report which has a sub report within it.
  2. Modify the input date in such a way that the database is able to understand the input date.

Keywords

Calendar prompt , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Product Enhancement

Product

Crystal Reports 2008 V0