Create Chart wizard

This wizard appears when you click Insert > Chart on the menu bar, click the Insert Chart button on the Insert toolbar, or drag Chart from the Toolbox panel into a report or library component. It helps you to create a chart in a report or library component, and consists of the following screens:

• Data Screen
• Type screen
• Display screen
• Filter screen
• Layout screen
• Style screen

Back

Goes back to the previous screen.

Next

Goes to the next screen.

Finish

Finishes creating a chart and closes this wizard.

Cancel

Does not retain changes and closes this wizard.

Help

Displays this help document.

Data screen

The Data screen differs with report type: page report or web report/library component.

Data screen for page report

Specifies the dataset that you want to use to create the chart. See the screen.

Define a dataset for the object

Specifies the dataset on which the chart will be built.

• New
  If checked, select a data source from the catalog resources to create a dataset that will be used to build the chart. When you choose to create the dataset from a query, you can click the Modify button to edit the query in the Query Editor if required.
• Existing
  If checked, select a dataset from the ones existing in the open report to create the chart. Click the Modify button to edit the dataset in the Dataset Editor if required.
• Current
  If checked, the current dataset used by the parent object will be applied to the chart.

Data screen for web report/library component

Specifies the data source that you want to use to create the chart. See the screen.

Available data resources

Lists all the business views in the current catalog. Specify the one you want to use.

Type screen

Specifies the type of the chart. You can refer to the section Chart types which describes each of the chart type in detail. All the 3-D chart types are not supported on web reports and library components. See the screen.

Single chart

Specifies to create a single chart.

• Chart Type
  Lists all the chart types that can be used to create a single chart.
• Sub Type
  Lists all the sub types of the selected chart type.
• Description
  Displays the description of the selected chart type.

Combo chart

Specifies to make more than one type use the primary or secondary axis. The types should be featured as Combination charts. Two types of data markers are used to represent different data values.

• Chart Type
  Lists all the chart types that can be added as a combo chart.
• Sub Type
  Lists all the sub types of the selected chart type.
• Description
  Displays the description of the selected chart type.

• Chart Type Groups
  Lists all the chart types that are to be used in the combo chart.
  • Primary Axis
    
    • <Add Combo Type>
      Adds a chart type to the primary axis.
  • Secondary Axis
    
    • <Add Combo Type>
      Adds a chart type to the secondary axis.
• 
  Removes a specified chart type from the Chart Type Groups box.

Display screen

Specifies the data fields that you want to display in the chart. See the screen.

Title

Specifies the title of the chart. Available to web reports and library components only.

Resources

Lists all the available data resources in the selected dataset.

Adds the selected fields to be displayed in the chart.

Removes the selected fields from the chart if they are not required.

Category/Series

Lists the field you want to display on the category/series axis of the chart. For a real time chart, if no field is specified on the category axis, Use System Refresh Time will be automatically displayed in the Category box, namely, the time at which the chart refreshes itself will be used as the category value; the series axis will be disabled.

• Special Group
  Opens the User Defined Group dialog to define how to group information.
• Special Function
  Opens the Special Function dialog to define some special function to the field.
• Order/Select N
  Opens the Category Options dialog or Series Options dialog to specify the sort order of the category or series values and define the number of the category or series values that will be displayed in the chart.

Show Values

Lists the values you want to show in the chart. For a real time chart, the values you add must be of Numeric type and cannot be summary fields.

• 
  Opens the Edit Additional Value dialog to edit an additional value. Available only when a constant value or an average value is selected in the Show Values box.
• 
  Moves the selected value one step up.
• 
  Moves the selected value one step down.
• 
  Adds a new pair of Y Axis and Radius for the bubble chart.
• 
  Removes the selected field from the bubble chart if they are not required.
• X Axis
  Lists the value you want to show on the X axis of the bubble chart.
• Y Axis
  Lists the value you want to show on the Y axis of the bubble chart.
• Radius
  Lists the value you want to show as the bubble radius.

Motion Bar for Playable Chart

Lists the field you want to use as the motion field. A motion field can only be of Integer, Date or Time data type. Available to single bar, bench and bubble charts in web reports and library components only.

• Special Function
  Opens the Special Function dialog to define some special function to the motion field. Available only when the motion field is of Date data type.

Real Time

Specifies to run the chart in real time mode, which means it will be updated automatically by using real time data after it is published to JReport Server. Available to single bar, bench, line, and area charts in web reports and library components only.

• Refresh Interval
  Specifies the interval that the chart will get data and refresh itself automatically.
• Keep Last N Records
  Specifies the number of records that will be kept for the real time data on the chart.

Filter screen

Specifies to filter the data used in the chart. See the screen.

Filter

This option is available only when creating a chart in a web report or library component. It lists all the predefined filters of the specified business view. Select one from the drop-down list to apply, or select User Defined and define a new filter according to your requirements.

For details about the other options in the screen, see Edit Filter dialog.

Layout screen

Specifies settings of some of the chart elements. See the screen.

Data

• Category Start Offset
  Specifies the start offset of category from which the chart will be displayed.
• Category End Offset
  Specifies the end offset of category to which the chart will be displayed.
• Series Start Offset
  Specifies the start offset series from which the chart will be displayed.
• Series End Offset
  Specifies the end offset of series to which the chart will be displayed.
• Reverse Category
  Specifies whether to reverse the display order of the categories.
• Reverse Series
  Specifies whether to reverse the display order of the series.
• Swap Groups
  Specifies to display values from different data fields by switching data between the category and series axes, the category and values axes.

Title

• Chart Title
  Specifies the title of the chart.
• Category(X) Axis Title
  Specifies the title of the X-axis.
• Value(Y) Axis Title
  Specifies the title of the Y-axis.
• Value(Y2) Axis Title
  Specifies the title of the Y2-axis.

Axis

• Show Category(X) Axis
  Specifies whether to show the category(X) axis in this chart.
• Show Value(Y) Axis
  Specifies whether to show the value(Y) axis in this chart.
• Show Value(Y2) Axis
  Specifies whether to show the value(Y) axis in this chart.
• Show Series(Z) Axis
  Specifies whether to show the series(Z) axis in this chart.

Wall

• Show Wall
  Specifies whether to show the wall in this chart.
• Show Floor
  Specifies whether to show the floor in this chart.

Gridlines

• Show Category(X) Axis Gridlines
  Specifies whether to show the gridlines of category(X) axis.
• Show Value(Y) Axis Gridlines
  Specifies whether to show the gridlines of value(Y) axis.
• Show Value(Y2) Axis Gridlines
  Specifies whether to show the gridlines of value(Y2) axis.
• Show Series(Z) Axis Gridlines
  Specifies whether to show the gridlines of series(Z) axis.

Legend

• Show Legend
  Specifies whether to show the legend in this chart.

Export

• Mapping Component
  This option is disabled when creating a chart. It specifies the component to which the chart will be mapped (for details, see Creating dynamic chart in Excel).

Style screen

Specifies the style of the chart. See the screen.

Style

Specifies the style of the chart.

Preview

Displays the selected style and layout effects.

Inherit Style

Specifies whether to make the chart take the style of its parent. Available only when the chart is to be inserted into a table or banded object in a page report.

Related topics:

• Inserting a chart