SAP Knowledge Base Article - Public

1328753 - Multiple bars on a single chart

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

Product

Crystal Reports 2008 V0 ; SAP Crystal Reports XI R2