For example, you may have a report that shows the total number of orders for each of your California and Oregon customers. You will often find it useful to include multiple summaries in a report. How to create a cross-tab with multiple summary fields NOTE: Rows and columns of a cross-tab can be independently formatted with background colors, shading, borders, and fonts to emphasize important data and create professional-looking reports. ġ0 Click the P RINT P REVIEW button on the standard toolbar to preview the cross-tab. For more information see Design Tab Areas,, and Area printing characteristics. For example, cross-tabs placed in the Report Header will contain data for the entire report and will print only once, at the beginning of the report, while cross-tabs placed in a Group Header will contain data for that group only, and will print every time the group changes. NOTE: Placing the cross-tab in different sections of a report produces different results. Place the cross-tab in the Report Header section of the report. The dialog box should look similar to the following:ĩ Click OK. The highlighted field is added to the Summarized Fields list box. Use this dialog box to add the rows, columns, and summary fields that will make up the cross-tab.Ĥ From the Fields list box, select the and click the S ET S UMMARIZED F IELD button. ġ Highlight the Region field of the Customer Table, and use the Select Expert to select the following records:Ģ Highlight the Region field of the Customer Table and, use the Select Expert to select the following records:ģ Click the I NSERT C ROSS-T AB button on the supplementary toolbar. Simply highlight the field you want to base your selection on and then select the desired records. The Select Expert makes it easy to specify the records you want included in a report. If you can compile a cross tab report that displays. Check it out, and then take the cross tab challenge. You can add it to your database and start cross tabbing immediately, without any further setup or changes to your SQL code.