Operation Manual

Cross-Tab Objects
Cross-Tab example
17
334 Crystal Reports User’s Guide
Report of order data—grouped by region and product
This report is the logical next step. If the By Region report contains multiple
products in each region group, and the By Product report contains multiple
regions in each product group, then it seems to make sense to combine the
two. Doing that, you group first by Region and then by Product.
But the data is all spread out and remains difficult to analyze. This information
is useful, and with a little work you can use a report like this to get the
comparison information you need. However, a Cross-Tab offers a better
solution.
Order data in a Cross-Tab object
With Cross-Tabs, all the information you need is provided in a compact
format. The report shows the products sold in each region and what the unit
sales were. It is easy to see, for example, that Guardian XL U” Locks are not
popular at all in BC but they are the biggest seller in Florida, or that Alabama
is being outsold by California in every lock category.
Each group contains orders for one product for one region.