Databases Reference
In-Depth Information
Figure 17-26
9. Next, drag and drop the Table report item within the List item. You
want to group the yearly sales based on the states. To see a grouped
report, right-click one of the rows of the table report item and select
Insert Group. You will now see the Grouping and Sorting Properties
dialog. Select the field State_Province_Name as the expression to
Group on. Hide the table footer of the table report item by right-click-
ing and selecting Table footer which is a toggle switch. Drag and
drop the State Province Name field to the group header row (after
the table header row), first column of the table. Drag and drop the
fields Year and Total Profit to the second and third columns of the de-
tail row within the table. Notice the titles of these fields will automatic-
ally be updated with appropriate names in the header. Drag and drop
the Country as a text box on top of the table. Drag and drop Total
Profit field to the last column in the group footer row. Your layout
should now look similar to
Figure 17-27
.
Search WWH ::
Custom Search