Crystal Reports  

Data Tab (Chart Expert)

Placement

In the Placement section, you determine where you would like your chart to be placed on the report, as well as how often the chart will appear on the report.

Place chart
Use this list to choose the report section where your chart will appear. Your chart can appear either once per report or once per group (the group section containing the summary field that the chart is based upon).
Note   Your choice of where to put the chart will affect how the data in the chart can be subdivided.
Header/Footer
Use the Header/Footer option buttons to display a chart in either the Group Header or Group Footer section of a report. If the chart appears once per report, the Header/Footer choice will place it in either the Report Header section or the Report Footer section of the report.

Layout

In the Layout section, you determine the actual layout of the chart, depending on the data you wish to chart. There are four options:

Advanced Option View

Available fields
This list displays all of the fields available for use in your chart.

Click the Add (>) button to add the selected field(s) from the Available Fields list to the On change of list. Click the Remove (<) button to remove the selected field(s) from the On change of list.

Browse
Click this button to browse the values for the field that is selected in the Available fields list.
On change of
Use the options in the "On change of" list to determined what values you want to see in your chart:
  • Choose "On change of" to see values summarized by the field you choose for the area below the list.

    For example, if you choose "Country," you'll see summarized values for each country.

  • Choose "For each record" to see values for each record in your report.
    Note   For this option, you don't choose a field for the area below the list.
  • Choose "All records" to see a summarized value that is a grand total for all the records in your report.
    Note   For this option, you don't choose a field for the area below the list.

If it's necessary to choose a field for the area below the "On change of" list, use the arrow buttons to add or remove the field(s) selected in the Available fields list.

Order
Click the Order button to change the sort order for the selected field. When you click this button, the Chart Sort Order Dialog Box appears.

This button is only active when a single field in the "On change of" list is selected.

TopN
Click the TopN button to sort the selected field by Top N, Bottom N, or Sort All. When you click this button, the Top N/Sort Group Expert appears.

This button is only active when a single field in the "On change of" list is selected.

Show Value(s)
This list displays the field chosen as a value for your graph or chart. Points will be plotted for these values on the chart whenever the condition selected in the "On Change of" list changes. For example, if you create a graph of last year's sales for all your customers, you will select the Customer Name field as the condition and the Last Year's Sales field as the value. Whenever the Customer Name changes a point will be plotted according to the value of their last year's sales.

Use the arrow buttons to add or remove the field(s) selected in the Show value(s) list. Click the double-arrow button to remove all the fields from the Show value(s) list.

Don't Summarize Values
Use the Don't summarize values check box to determine if the program should automatically summarize the values that will appear on the chart.
Note   This option is available only for formula fields.
  • If you select this check box, the program will not summarize the values.
  • If you clear this check box, the program will summarize the map values, and the Set Summary Operation button will activate. The program adds a summary field to the Map Values list.
Set Summary Operation
Use this button to set or change the summary operation for the selected field. When you click this button, the Edit Summary dialog box appears. This button is only active when you have cleared the Don't summarize values check box, and when you have selected a field in the Map Values list.

Group Option View

On change of
Select the field you want to use as a condition for plotting values in a graph or chart. Points will be plotted whenever the value in the condition field changes.
Show
Use this list to select the summary field whose values you want to display in your graph. Use the Insert Summary dialog box to create a summary field.

Cross-Tab Option View

On change of
Select the field you want to use as a condition for plotting values in a graph or chart. Points will be plotted whenever the value in the condition field changes.
Subdivided by
Use this list to choose the secondary row or column to base your chart on. Clicking this box displays a list of the row/columns fields in your report that you can choose from.
Show
Use this list to select the summary field whose values you want to display in your graph.

OLAP Option View

The OLAP layout enables you to chart on an OLAP grid.

Note   OLAP grid objects are not supported in this version of Crystal Reports. The OLAP Option View is disabled.

See Also

Selecting Top or Bottom N Groups | Chart Expert