To add a cross tab data source
- In the workspace, click to highlight the data source.
- From the property inspector, select cross_tab from the Source type property.
- Click inside the value box next to the Source Parameter property. The Datasource Properties window is displayed.
-
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:
-
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: