AO Simple Crosstab
Overview
Advanced Object (AO) Simple Crosstab is a simplified interface to the Crosstab tool. With AO Simple Crosstab, you choose only vertical and horizontal field names and the output file. The format of the output report is CSV. Row and column headers are sorted alphabetically.
AO Simple Crosstab configuration parameters
AO Simple Crosstab contains a single set of configuration parameters in addition to the standard execution options.
Parameter | Description |
---|---|
Column header | (Required) Field used horizontally across the top of the crosstab. |
Row header | (Required) Field used vertically on the left of the crosstab. |
Count | (Optional) Field containing already summarized counts by column/row. If not specified, a count of one is assumed for each record (for example, non-aggregated data). |
Replace zero counts with blanks | (Optional) Changes all counts with a value of "0" to a blank (null value). |
Select output file | The path and file name to which the report should be written. |
Configure AO Simple Crosstab
Select AO Simple Crosstab.
Go to the Configuration tab on the Properties pane.
Select the Column header field and Row header field.
Optionally, specify Count (a field containing summarized counts by column/row).
Optionally, select Replace zero counts with blanks to change all counts with a value of "0" to blank (null value).
Select Select output file and specify the path and file name to which the report should be written.
Optionally, go to the Execution tab, and then set Web service options.