Adding a Crosstab Report

From the Report Writer screen, select the report group (query or view group) for which to add the new crosstab report by clicking on the name of the view group in the Report Groups List.

Tip: If desired, click the Directory button after clicking on a report group to view a list of the files from which fields can be included on a report in the particular report group.

Click the New Record button located at the top of the screen to create a new report in the selected report group.
Complete the report settings for the new report, being sure to select Crosstab as the Report Type.

Steps to Complete Report Settings

Define the categories/screens for the new report.

Steps to Define Categories/Screens

The Edit Report screen will appear for the report, showing the Page Header, Detail, and Page Footer sections.
At the Edit Report screen, enter the information to be printed in the Page Header section, or suppress the Page Header section so that it does not print, if desired. Insert special fields, database fields, labels, lines, shapes, or images into the Page Header section, as desired, and then resize, format, move, and align the items (objects) as needed.

Note: When creating a new report, the system automatically includes six standard header fields in the Page Header section, but the fields can be changed or deleted, if desired. The six standard header fields include the system field from the database for the organization name and the special fields of Report Name, Page Number, Print Date, Sub Heading, and User ID.

Tip: If the standard header fields are not centered within the Page Header section, click the Adjust Header Fields button to align the standard header fields correctly within the Page Header section. If the Page Header section is not needed, suppress the section so that it does not print by first clicking the title bar for the section and then selecting False in the Visible field under the Behavior section in the Properties List.

Steps to Insert a Special Field

Steps to Insert a Database Field or Formula

Steps to Insert a Label

Steps to Insert a Line

Steps to Insert a Shape

Steps to Insert an Image

Steps to Resize Objects

Steps to Format Objects

Steps to Move Objects

Steps to Align Objects

In the Detail section, specify the database fields to print in the columns, rows, and as the detail information, by completing the following:

Click on the field (not the label) for Column in the Detail section; then in the Properties List (located in the lower right corner of the screen), click in the Data Field field under the Data section and click the down-arrow button to select the field to print as the columns.
Click on the field (not the label) for Row in the Detail section; then click in the Data Field field under the Data section in the Properties List and click the down-arrow button to select the field to print as the rows.
Click on the field (not the label) for Detail in the Detail section; then click in the Data Field field under the Data section in the Properties List and click the down-arrow button to select the field to print as the detail information (or values for the cells (the columns/rows)).

Note: The field selected for Detail (to print as the detail information on the report) must be a numeric field.

Enter the information to be printed in the Page Footer section, or suppress the Page Footer section so that it does not print, if desired. Insert database fields, formulas, labels, lines, shapes, images, subreports, or barcodes into the Page Footer section, as desired, and then resize, format, move, and align the items (objects) as needed.

Note: Initially, the height for the Page Footer section will be set to zero (0), and the section will need to be resized prior to inserting any objects into the section.

Tip: If the Page Footer section is not needed, leave the height set to zero (0) if there are no objects in the section, or else suppress the section so that it does not print by first clicking the title bar for the section and then selecting False in the Visible field under the Behavior section in the Properties List.

To have a grand total print for each column, add the Report Footer section to the crosstab report. To add the Report Footer, select the Insert menu and then Report Header/Footer. The Report Header and Report Footer sections will be included on the report. The Report Footer section cannot be edited when working with a crosstab report, and nothing further has to be done to include the grand totals, as it will automatically include the grand total for each column when the crosstab report is printed.

Tip: If the Report Header section is not needed, suppress the section so that it does not print by first clicking the title bar for the section and then selecting False in the Visible field under the Behavior section in the Properties List.

Note: A total for each row will automatically print on the crosstab report (does not require any additional steps to be completed in order to have the row totals print on the crosstab report).

If desired, add groups to the crosstab report, and then enter the information to be printed in the Group Header and Group Footer sections. Insert database fields, formulas, labels, lines, shapes, images, subreports, or barcodes into the Group Header and Group Footer sections, as desired, and then resize, format, move, and align the items (objects) as needed. Also, utilize the Properties List (located in the lower right corner of the screen) to change the defined properties for the Group Header and Group Footer sections, if desired.

Tip: If the Group Header or Group Footer section is not needed, suppress the section so that it does not print by first clicking the title bar for the desired section and then selecting False in the Visible field under the Behavior section in the Properties List.

Note: A subtotal for each group will automatically print on the crosstab report in the Group Footer section (does not require any additional steps to be completed in order to have the group subtotals print on the crosstab report).