Walkthrough: Creating a Crosstab using Data Binding Wizard
Walkthrough
In this example, you will create a Crosstab with 'Company' and 'Product' as headers, and 'Quantity' as the aggregated measure.

1. Click the 'New' button in the Style Studio toolbar. This opens the 'New Asset' dialog box.
2. In the left panel, select 'Report'. In the right 'Types' panel, select 'Blank Tabular Report', and click 'OK'. This creates a new blank report.

3. Click the 'Crosstab' button in the Toolbox panel. This opens the 'Data Binding' dialog box for the crosstab
4. Under the Data tab of the 'Data Binding' dialog box, expand the 'Orders' node, and select the 'Order Model' data model.
5. Click the Columns tab. Drag the following columns from the 'Available Columns' panel to the right panel:
'Customer.Company'
'Product.Total'
'Product.Name'
6. Click the Crosstab tab.

You can add multiple columns as column headers, row headers, or summary fields by selecting the filed name and clicking the appropriate 'Add' button (or by dragging the field to the desired region). The 'Percentage' option allows a column to be calculated as a percentage of some other row.
7. Drag 'Product.Name' from the 'Available Column' panel into the 'Column Header' panel.
8. Drag 'Customer.Company' from the 'Available Column' panel into the 'Row Header' pane.
9. Drag 'Product.Total' from the 'Available Column' panel into the 'Summary' panel.
10. Click on 'Product.Total' in the 'Summary' panel, and choose the following options:
a. Select 'Sum' as the aggregation method in the menu.
b. In the 'Percentage' menu, select 'GrandTotal'. This displays the 'Sum(Total)' measure as a percentage of the Grand Total.

11. (Optional) Set any desired options for the Crosstab under the Options tab in the 'Data Binding' dialog box. See Crosstab Options for more details.
| << 6.5.1 Creating a Crosstab Using the Data Binding Wizard | © 1996-2013 InetSoft Technology Corporation (v11.5) | Walkthrough: Setting Layout for a Crosstab >> |