Now
that we have the Dataset in place, let's begin working within the Layout
tab for the new report.
35.
Click the Layout
tab.
The
blank Layout tab for the report appears.
36.
Open the Toolbox
to expose its
component selection. (If
it is not docked in the development environment, open it by simply selecting View
--> Toolbox from the main menu, as depicted
in Illustration 74.)
Illustration 74: Select
View --> Toolbox, as Required ...
37.
Click the Table
item.
38.
Click the Layout
area, at approximately the center of the canvas (the mouse pointer has become a
small table icon with a "crosshairs" symbol).
The Table
Data Region appears on the canvas, similar to that shown in Illustration
75.
Illustration 75:
Creating the Table Data Region on the Canvas
39.
From the Fields
list, drag the_date to the middle row of the leftmost column in the Table
Data Region, as depicted in Illustration 76.
Illustration 76: Inserting
a Data Field into the Table
40.
From the Fields
list, drag store_state to the middle row of the second column from the
left (dropping it to the immediate right of the cell in which we dropped the_date
in the preceding step).
41.
From the Fields
list, drag store_city to the middle row of the third column from the
left (dropping it to the immediate right of the cell in which we dropped store_state
in the preceding step).
42.
Right-click
the gray bar atop the third column.
43.
Select Insert
Column to the Right from the context menu that appears, as shown in Illustration
77.
Illustration 77: Adding
an Additional Column ...
A fourth,
empty column is added.
44.
From the Fields
list, drag store_name to the middle row of the new fourth column from
the left within the Table Data Region.
45.
Right-click
the gray bar atop the fourth column.
46.
Select Insert
Column to the Right from the context menu that appears, as before.
47.
From the Fields
list, drag brand_name to the middle row of the new fifth column from the
left within the Table Data Region.
48.
Right-click
the gray bar atop the fifth column.
49.
Select Insert
Column to the Right from the context menu that appears, once again.
50.
From the Fields
list, drag product_name to the middle row of the new sixth column from
the left within the Table Data Region.
51.
Right-click
the gray bar atop the sixth column.
52.
Select Insert
Column to the Right from the context menu that appears, as before.
53.
From the Fields
list, drag store_sales to the middle row of the new seventh column from
the left (and the rightmost column) within the Table Data Region.
Now,
let's narrow the columns to make working with them easier in the next steps.
54.
Hold down the SHIFT
key, and beginning with the gray bar atop the first column, click the bar atop
each of the seven columns in the Table Data Region to select / highlight
all seven columns.
55.
With all
columns selected, type a "1" n the very bottom box ("Width"
in the Layout section) of the Properties window, as depicted in Illustration
78.
Illustration 78: Adjusting
All Columns to 1-Inch Width ...
56.
Click just
below the Properties window, to accept the setting and compact the
columns in the Table Data Region.
The
columns of the Table Data Region are each compacted to 1-inch widths.
57.
Right-click
the gray bar (click anywhere within the table to make it reappear, if
necessary) to the left of the middle row in the Table Data Region.
58.
Select Insert
Group from the context menu that appears, as partially shown in Illustration
79.
Illustration 79: Adding
a Group to the Newly Compacted Table ...
The Grouping and Sorting Properties dialog appears, defaulted
to the General tab.
59.
Type the
following into the Name box of the dialog.
gP_ProductName
60.
Click the top
row in the Group on list, just beneath the Expression label, to
expose the selector.
61.
Using the
selector, select the following from the picklist provided to populate the top
row of the list:
=Fields!product_name.Value
The Grouping and Sorting Properties dialog - General tab, with our
input, appears as depicted in Illustration 80.
Illustration 80: The
Completed Grouping and Sorting Properties Dialog – General Tab
62.
Click OK to
accept our input and close the Grouping and Sorting Properties dialog.
The new
Group Header and Footer appear.
» 
Comment and Contribute