SAP Knowledge Base Article - Public

1264658 - Trying to build a charts "onchange of" to three group level

Symptom

  • Trying to build a stacked bar chart with X axis as three 3 Group.

  • Trying to build a chart with a double X axis. ie.Dates by Field for X axis and Field for Y axis.  

Reproducing the Issue

Environment:

  • Crystal Report Designer : Crystal Reports XI/XIR2/2008.
  • Operating System : Windows.
  • Database: SQL Server 2005.

Cause

  • As it is crystal report limitation that the chart has only two group level (On Change of).

for example :
Group 1 -  Issue_Code
Group_2 - Participation_Code
Group 3 - Date (Month/Year Format)

Resolution

1. Create a formula @Month to concatenate the issue code along with the date (MM/YYYY - Format):
           (

           Whilereadingrecords;
           Issue_Code & Totext(Month(Date),"##") & "/" & Totext(Year(Date),"##");

             )
    

2.In Chart Expert > On Change of > Selected  @Month as the first group and Participation_Code as the second group.

3.In the values selected Count(Tickets) as the Y axis.

Keywords

 Build stacked bar chart, X axis, three Group level , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

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