Symptom
How to group data having month and year fields as string data type and filter them using date range.
Resolution
Steps to Resolve the Issue:
1. Create a Crystal Report using Xtreme Sample Database and insert Order’s table
2. Create a formula from Field Explorer
Formula: date (tonumber({year field}), tonumber({month field}), 01)
3. Create a Static Parameter with "Date" data type. And set "Allow Range values " to true.
4. Use a record selection formula,
@formula={?Date Parameter}
5. Insert group based on this formula @formula and select "for each month" or "for each year" to get the data monthly or yearly wise.
5. Refresh the report and select the date range values.
6. Displays the report with data in date range.
Keywords
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To