Database Reference
In-Depth Information
The first step is to choose the object on which the subreport will be based.
4
With
Use existing Tables and Queries
selected, click
Next
.
5
In the
Tables/Queries
list, click
Query: Sales By Category
.
6
Move
CategoryID
,
ProductName
, and
ProductSales
from the
Available Fields
list
to the
Selected Fields
list, and then click
Next
.
7
With
Choose from a list
and
Show Sales By Category for each record in Sales By
Category using CategoryID
selected, click
Next
.
9
TIP
The option selected in the list box is displayed in its entirety below the list box.
8
Click
Finish
to replace the unbound subreport control with a control named
Sales by
Category subreport
.
Let's adjust the size of the subreport and delete the controls we don't need.
9
With the entire subreport control selected, open the
Property
Sheet
pane.
TROUBLESHOOTING
If the subreport control is not selected, click its top edge to
select it.
10
On the
Format
page, set the
Width
property to
6.6”
and the
Height
property to
2.0”
. Then close the
Property Sheet
pane.