6.5.2 Creating a Crosstab Using Freehand Operations
In Creating a Crosstab Using the Data Binding Wizard, you learned how to use the Data Binding Wizard to bind a Crosstab to a data source. You can also bind a Crosstab to a data source by using freehand operations.
To create a new Crosstab that displays fields from a query, data model entity, or Data Block, follow the steps below:
1. Click in the report to place the insertion point at the desired location.
2. Open the Toolbox panel. (Select 'Toolbox Pane' from the 'Window' menu.)
If you click (instead of drag) the 'Crosstab' component, this opens the Data Binding Wizard. See Creating a Crosstab Using the Data Binding Wizard for more details.
3. Drag the 'Crosstab' component onto the report. This creates a new blank Crosstab.

4. Open the Data Source panel. (Select 'Data Source Pane' from the 'Window' menu.)
5. Expand a query, data model entity, or Data Block in the Data Source panel.
You can also drag the field to the 'Column Header' region in the Binding panel.
6. To specify the Crosstab column headers, click to select a field (or Ctrl-click to select multiple fields) from the data source. Drag the field(s) into the Crosstab Header region.

You can also drag the field to the 'Row Header' region in the Binding panel.
7. To specify the Crosstab row headers, click to select a field (or Ctrl-click to select multiple fields) from the data source. Drag the field(s) into the Crosstab Detail region.

You can also drag the field to the 'Aggregate' region in the Binding panel.
8. To specify the Crosstab aggregates, click to select a field (or Ctrl-click to select multiple fields) from the data source. Drag the field(s) into the 'Aggregate' cell.

This completes the Crosstab data binding.
To change the grouping and aggregation options, see Modifying Table Grouping Properties and Modifying Summary Properties. For greater control of individual cell bindings and table layout, you can convert the Crosstab to a Formula Table. See Formula Tables for more information.
| << Walkthrough: Setting Layout for a Crosstab | © 1996-2013 InetSoft Technology Corporation (v11.5) | Crosstab Options >> |