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
- Create a Crystal report which uses a date range parameter.
- Keep the parameter as static and allow custom values.
- Create two formulas one for start date and another for end date as follows: -
- Place these formulas on the page header and refresh the report.
- In the Parameter window, input the desired date.
- Uncheck "include this value" for start date and end date parameters.
- Click on "Ok" to refresh the report.
- Notice the date displayed in the formula field placed in the header.
local datetimevar sdate;
Minimum({Date_range});
and
local datetimevar edate;
Maximum({Date_Range});
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