## Chart Report Wizard

This wizard appears when you select Chart Report in the New Report dialog or New Report Set dialog and then click OK. It helps you to create a report with a chart in it, 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 report and closes this wizard.

Cancel

Does not retain changes and closes this wizard.

Help

Displays this help document.

### Data screen

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 set to create the chart. Click the Modify button to edit the dataset in the Dataset Editor if required.

### Type screen

Specifies the type of the chart. You can refer to the section Chart types supported by JReport which describes each of the chart types in detail. 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 you want to display in the chart. See the screen.

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 fields you want to display in the category/series axis of the chart.

- Sort Order
  Opens the Sort Order dialog to set sorting options of the specified field.
- Special Function
  Opens the Special Function dialog to define some special function to the field.
- Select N
  Opens the Select N dialog to specify the Select N condition in the chart.

Show Values

Lists the values you want to show in the chart.

- Moves the selected value one step up.
- Moves the selected value one step down.

### Filter screen

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

Add Condition

Adds a new condition line.

Delete

Deletes the selected condition line.

Group

Makes the selected conditions in one group. Conditions can also be added to an existing group by selecting the conditions and the group while holding the Ctrl button, and then clicking the Group button.

Ungroup

Makes the selected condition ungrouped.

Up

Moves the selected condition up to a higher level.

Down

Moves the selected condition or group down to a lower level.

Logic

Lists the logic operator.

- And
  Logic operator And which is applied to this and the next line.
- Or
  Logic operator Or which is applied to this and the next line.
- And Not
  Logic operator And Not which is applied to this and the next line.
- Or Not
  Logic operator Or Not which is applied to this and the next line.

Field

Specifies the field to be filtered.

Operator

Specifies the operator to compose the filter expression.

- =
  Equal to
- >=
  Greater than or equal to
- >
  Greater than
- <
  Less than
- <=
  Less than or equal to
- !=
  Not equal to
- [not] like
  Like string pattern matching operator is used to compare the first expression string value to the pattern string (the second expression). If you want to use wildcard character in the pattern string, only "_" and "%" are supported.
- [not] in
  Causes an enumerated list of values to appear in the WHERE clause predicate, used for evaluating for a true condition. For operator ‘in' or ‘not in', it is allowed to input multiple values in the Value input box and separate the values with comma (,).
- [not] between
  Allows the system to evaluate whether or not data values are located between a range of values indicated in the predicate. For operator ‘between' or ‘not between', there are two value input boxes for inputting the same type of values.
- is [not] null
  It is used in WHERE clause predicates to match null values occurring in a specified data field. For operator ‘is null' or ‘is not null', the value input box is hidden.

Value

Specifies the value of how to filter the field.

SQL Statement

Displays the SQL statement of the filter condition.

### Layout screen

Specifies the layout 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.

Notes:

- If values are set to be less than 0, it means the categories or series will be displayed without any offset.
- If values are set to be greater than 0 and the value of Category/Series Start Offset is greater than that of Category/Series End Offset, all of the categories or series will be displayed.

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 report.

Preview

Displays the specified style and layout effects.

Page Setup

Opens the Page Setup dialog to specify page properties.

###### Related topics:

- Creating a chart report