Skip to main content
Skip table of contents

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

  1. Select AO Simple Crosstab.

  2. Go to the Configuration tab on the Properties pane.

  3. Select the Column header field and Row header field.

  4. Optionally, specify Count (a field containing summarized counts by column/row).

  5. Optionally, select Replace zero counts with blanks to change all counts with a value of "0" to blank (null value).

  6. Select Select output file and specify the path and file name to which the report should be written.

  7. Optionally, go to the Execution tab, and then set Web service options.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.