To add a cross tab data source

  1. In the workspace, click to highlight the data source.
  2. From the property inspector, select cross_tab from the Source type property.
  3. Click inside the value box next to the Source Parameter property. The Datasource Properties window is displayed.
  4. Complete the parameters:
    Base Data SQL
    Specify the SQL query that returns the data to be summarized
    Row Headings
    Specify a list of rows to use as the grouping of data (format is comma separated list).
    Column Heading
    Specify the column to use as the heading.
    Column Head SQL
    Specify the SQL query that returns a set of possible column headings.
    Operation
    Specify the operation (for example, SUM, AVG, MAX, MIN).
    Operation Argument
    Specify the column to use as the argument in operation.
    Add Else Case
    Specify Y to include data not belonging to column headings listed. This data is grouped together and is available in the Datafield drop-down property as _ELSE_CASE_. For example, you can add a label in the report detail section (to show the else case data) and set its Datafield property to _ELSE_CASE_.
    Add Row Summary
    Specify Y to include row summary column.

    For example, the following window displays parameters for the cross tab source type:



  5. Click OK.
    The main Form Builder screen is displayed.

The following form corresponds to the completed parameter example above:



Below is the resulting report of the above form and cross tab example: