Database Reference
In-Depth Information
This is known as making
Product Details
a peer of
Product
. This will list the product
you selected in the row first followed by all the child members.
6.
In the work area, click
Product Details
in the rows to select it.
7.
In the
Properties
pane, double-click the
Level Indentation
property.
A dialog box is displayed.
8.
Change the
Indentation type
property to
Based on the level in the hierarchy
.
9.
Click
OK
to close the dialog box.
Since
Product
and
Product Details
are treated as separate sets, we will need to nest
Return reason
under both sets.
10.
From the
Data Items
tab of the
Insertable Object
pane, drag
Reason description
to
the right of
Product
in the rows.
This is known as nesting the
Return
description within
Product
.
11.
Drag
Reason description
to the right of
Product Details
in the rows.
The crosstab should look like Figure 2.22.
Figure 2.22
Initial crosstab design