SAP Knowledge Base Article - Public

1282340 - How to group data having month and year fields as string data type and filter them using date range.

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 BusinessViews Manager , How To

Product

Crystal Reports 2008 V0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2