Adding Cross-tabs to Summarize Information

Cross-tabs are matrix or spreadsheet-like reports that display summary, numeric data. With cross-tabs, you can quickly present a summary of data based on two categories. When you create a cross-tab, you can place it in the Group Summary, Query Summary, or Report Footer section of a Tabular report, or you can create the cross-tab as a separate report.

For example, a cross-tab report can show the sales of each region over a number of quarters:

REGION

Q1 ‘96

Q2 ‘96

Q3 ‘96

Q4 ‘96

Q1 ‘97

TOTAL

EAST

$92,000

$ 90000

$ 87500

$ 76000

$ 84500

$430000

WEST

$ 80000

$ 85000

$ 87500

$ 83000

$ 89500

$ 425000

NORTH

$ 95000

$ 85000

$ 85250

$ 92000

$ 90000

$ 447250

SOUTH

$85000

$75000

$ 87750

$90000

$ 91500

$ 429250

       

Total

$352,000

$335,000

$348,000

$341,000

$355,500

$1,731,500

The following sections discuss: