Symptom
How to display the multiple bar’s side by side with year and month.
Resolution
1. Create a sample report with Xtreme sample database.
2. Insert a Orders table and select order amount and order date database fields and place in the report.
3. Create two formulas,
"Year" à Year({Order date})
"Month" à Month({Order date})
4. Insert a Bar chart and in the Chart expert à Data tab à Onchange à Insert Year and Month formulas.
5. Refresh the report, the bar chart displays the data correctly side by side.
Note: If the data should be display as per each month as January, February up to December then make the changes in the chart expert à Onchange of Month à Select the Month field à Order à Specified Order à Select new and create in the order tab as Jan, Feb….. to Dec.
Keywords
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To