Report Studio

You can link regions or points on a map to another report. For example, on a map of the world, you can specify that when you click on China, a map of China opens.

To Set Up a Filter in the Target Report:

1. Open the target report.
2. From the Data menu, click Filters.
3. On the Detail Filters tab, click the add button .
4. In the Available Components box, click the source or data items tab to select the data item you want to use.
   
   For example, if you want the target report to open when Canada is clicked in the source report, expand Countries and double-click Country.

In the Expression Definition box, type an operator after the data item or select an operator from the functions tab and then enter a value.

For example, if you want the report to open when a certain project name is clicked in the source report, the expression would be as follows:

[eProject].[Presentation].[Project Information].[Projects].[Project Name]='MY PROJECT NAME'

5. Save the target report.

To Set Up a Drill-Through Link in the Source Report:

1. Open the source report.
2. Select the region layer or the point layer.
3. In the Data section of the Properties pane, click Map Drills, and then click the ellipses (...).
4. In the Map Drills dialog box, click the new button.
5. In the Search String box, type the name of the feature you want to use for the drill-through link, select it from Matching Features box, then click OK.
   
   For example, if you want a report to open when you click on Canada, search on all or part of the word Canada then select Canada.
6. In the Drill Throughs dialog box, click the new button .
7. Click the ellipses (...) beside the Report box, and select the target report.
8. Click OK.
9. Run the report.

When you click the selected feature in the source report, the target report will open.

Related Topics:

• Creating a Map Report—How to create a map report.
• Defining Data Values for the Region Layer in Map Reports—How to define the data values for a map report.
• Matching Data Values to Names in Map File—How to match the data values to the names in a map file.
• Adding Titles, Subtitles, Footers, and Axis Title—How to add titles, subtitles, footers and axis titles to a map report.
• Adding Legend Titles—How to add legend titles to your map report.

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved