Skip to Content

Version Information: This sample is prepared with Crystal Reports 2008

Creating a chart in Group Footer:

This is a continuation to my previous blog on Crystal Reports Charts (http://scn.sap.com/community/crystal-reports/blog/2012/04/30/using-charts-in-crystal-reports-part-1)

I will continue with the same sample data. In the previous example I had created a single chart showing the total marks obtained by all the students. But how to create a chart showing marks obtained in different subjects by a single student?

/wp-content/uploads/2012/05/chart1_97631.jpg

As we can see, the student marks are grouped per student. So we need to create a chart per group.  The best way to do that will be to create another Group Footer section and insert a chart in this section.

 

We click on the “Insert Chart” icon.  The chart Expert opens. Here we select the vertical Bar chart.

/wp-content/uploads/2012/05/chart4_97632.jpg

In the Data tab, we select “Marks” as the value to be shown in the bar chart, for each value of “Course” taken by each student. This will mean that there will be a different bar for each subject/course taken by the student and the height of the bar will be proportional to the marks obtained by the student.

/wp-content/uploads/2012/05/chart8_97633.jpg

In the Axis tab we put the Minimum and Maximum data values as 1 and 100. Auto Range is selected by default.  It might be advisable to fix the maximum and minimum values, and the number of divisions when a number of charts will be displayed in the same report. This ensures uniform representation of data in all charts.

/wp-content/uploads/2012/05/chart9_97634.jpg

We can use the Text tab to customize the Title and axis descriptions.

/wp-content/uploads/2012/05/chart10_97635.jpg

Note: You cannot place a chart in Crystal Report Detail section. If you want a chart for each row of data, the solution would be to create a group on the primary key so that each group will contain just 1 row , then insert the chart in the group footer.

The final output looks as shown below:

/wp-content/uploads/2012/05/chart11_97636.jpg

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

    1. Debapriya Mandal Post author

      Hi Jaheer

      Drill down in graphs is very simple to implement in Xcelsius. After that you can add the Xcelsius component to Crystal.

      Hope this solves your problem.

      (0) 
      1. jaheer ussain babu shajakhan

        ok thanks…when right click on chart and choose hyper link there is one option is there enable drill down..but that is only for DHTML View ly…if u dont mind please explain me about DHTML View..

        Thanks for your kind reply,

        (0) 

Leave a Reply