SAP Knowledge Base Article - Public

1306891 - 'Include this value' option not working in Crystal Reports.

Symptom

For a Date Range Parameter, 'Include this value' option does not have any effect in Crystal Reports XI Release 2.

Environment

Crystal Reports XI Release 2.

Reproducing the Issue

  1. Create a Crystal report which uses a date range parameter.
  2. Keep the parameter as static and allow custom values.
  3. Create two formulas one for start date and another for end date as follows: -
  4. local datetimevar sdate;

    Minimum({Date_range});

    and

    local datetimevar edate;

    Maximum({Date_Range});

  5. Place these formulas on the page header and refresh the report.
  6. In the Parameter window, input the desired date.
  7. Uncheck "include this value" for start date and end date parameters.
  8. Click on "Ok" to refresh the report.
  9. Notice the date displayed in the formula field placed in the header.

Resolution

Modify the Start End and End Date formula such that if 'No Lower value' option is checked in the Start Date the report will display the Start Date blank and the End date will be displayed the once selected in the Parameter Prompt  Window.                                                                                    

Keywords

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

Product

SAP Crystal Reports XI R2