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

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

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.

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

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