Crystal Reports - Charts


Advertisements

In this chapter, we will learn about types of charts, creating and formatting charts.

Chart Types

You can use below chart types in Crystal Reports for enterprise. To insert a chart, go to Insert → Chart → select Chart type and insert the chart in the structure or page tab.

Chart Types

Creating Charts & Chart Layout

You can insert a chart in Report footer. When you select the chart type from Insert chart option, you can move the cursor to the report footer area and click where you want to insert the chart.

When you insert a chart it gives you two options − Data and Show chart.

Create Chart

Show chart option allows you to resize the chart, move the chart in the Report footer area (as shown above).

Data tab allows you to insert the data in the chart. When you go to data tab, it asks you to add values on X, Y, Z axis.

Data Tab Chart

Right click on each axis and go to Insert Chart Category Object → you can choose Selected Elements from the dropdown list → Chart Data Object, Title, Subtitle, foot note, legend, etc.

Chart Category

Chart Data object allows you to choose the attribute name, which you want to pass in the chart data. Title, subtitle and footnote allows you to add heading or note to the chart.

Formatting Charts

When you right click on chart it gives you the following formatting options −

Format Chart − Allows you to format structure of the chart by going into advance, appearance and depth option. You can also change the type of chart from the dropdown list by clicking on the Chart option in the Format chart tab.

Format Chart

Chart Highlighting Expert allows you to highlight a specific value in the chart. You can choose different color to highlight a value inside chart.

Add Condition → Choose attribute which you want to highlight in the chart as shown in the following image.

Format Chart1

Edit Chart Type is same as format chart with all of the options being similar.

Format Chart2

Edit Chart data is used to edit the data in the chart. If you want to change the parameter values on the chart axis, you can click on edit chart data and change the values. Hide option is used to hide the chart and move is used to move the chart backward or forward.

You can add multiple charts in a single report or in one row by formatting the chart size. Example - You can add bar chart and pie chart for different values to represent. You will see Show chart and Data option for the second chart → you can add required objects and also add header and footer note to the chart as shown in the following image.

Report Footer

To see the actual report, go to Page tab.

Report
Advertisements