The next step is to define the objects in the report that
will appear as links to the user in a web page. You start at the highest level
of summation and define the lower level of details. For this report we'll
start at the Country level. From within a country you can drill to a State or
Province. From within a State or Province you can drill into a City. From
within a city you can drill into the details records that make up the total.
1.
The first step is to define the starting point. Right click on the
Group #1 Name field in the GroupFooterSection1 section. Click Copy from the
pop-up menu.
2.
Right click any free space on the report and select ReportàReport Options… from the pop-up menu.
3.
The Report Options dialog should appear. Click the Paste Link button in
the Initial Report Part Settings section.
4.
The Object Name tells the viewer which object to display. For this
report we want to show the name and the total for that group so append ;SumofTotalDue1
to the Object name. The Object Name should now be GroupNameName2;SumofTotalDue1.
5.
Click the OK button.
6.
Now that the initial view is setup you need to define what the drill
down path is when the user clicks on the total that is displayed in the
report. Right click on the summation field that is in GroupFooterSection1.
Select Format Object from the pop-up menu.
7.
Click the Hyperlink tab. Select the Report Part Drill Down option.
8.
Expand the plus sign next to GroupFooter2 and move GroupNameName4 to the
Fields to Display list by clicking the > button. Now move the
SumOfTotalDue2 to the Fields to Display.
9.
Click the OK button. When the user clicks on the field they will drill
into the total field for that country.
10. Right
click on the summation field in GroupFooter#2. Select FormatObject from the
pop-up menu. Click on the Hyperlink tab and select Report Part Drilldown.
11. Expand
GroupFooter#3 and move the GroupNameCity2 and SumofTotalDue3 to the Fields to
Display list. Click the OK button.
12. Right
click on the summation field in GroupFooter#3. Select FormatObject from the
pop-up menu. Click on the Hyperlink tab and select Report Part Drilldown.
13. Expand
the Details and move Name1, Name2, City1, and TotalDue1 to the Fields to
Display list. Click the OK button.
That's all you need to do in the report. Now you need to
create the web page that will display the parts.