Converting the Report to Display Report Parts
In this section, you learn how to set hyperlinks in the report to link from general to more detailed information.
To convert the report to display report parts
- At the bottom of the window, click Main Report.
> [!NOTE]
> <P>The highest group, Group #1 Name, is displayed in two locations, at the top and at the bottom of the report.</P>
> <P>At the bottom of the report in the Group Footer #1 section, Group #1 Name is a label that is followed by a summary field for Customer.Last Year's Sales. This label is the preferred one to use as a report parts entry point.</P>
Right-click Group #1 Name that is located in the Group Footer #1 section, and then click Copy.
Right-click in an empty area of the report, point to Report, and then click Report Options.
In the Report Options dialog box, click Paste Link.
The ID for the Group 1 label "GroupNameCountry2" is pasted into the Object Name field.
The Data Context field accepts a string value that filters report data. For now, this field should remain blank.
Click OK.
Right-click Group #1 Name, which is in the Group Footer #1 section, and then click Format Object.
In the Format Editor, click the Hyperlink tab, and then select Report Part Drilldown.
In the Available Fields panel, expand Group Footer #2, double-click GroupNameRegion2, and then click OK.
You have set Group \#1 to link to Group \#2 when Group \#1 is clicked at runtime.
Right-click Group #2 Name, which is located in the Group Footer #2 section, and then click Format Object.
In the Format Editor, click the Hyperlink tab, and then select Report Part Drilldown.
In the Available Fields panel, do the following:
1. Expand Details.
2. CTRL-click CustomerName1, LastYearsSales1, and City1.
3. Click the \> symbol to move these fields into the Fields to Display panel.
4. Click OK.
You have set Group \#2 to link to detailed information about the customer, when Group \#2 is clicked at runtime.
- From the File menu, select Save All.