CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0
Figure 13-65. Employee Service Cost by branch and patient state after outside group and formatting- We are almost complete! One final requirement is to have the ability to drill
through from this report to our detailed report named
Emp_Svc_Cost_By_Patient_State_RB3_Drill that we deployed earlier. To do
this, we are going to create an action on the map. To do this, click on a State
again to bring up the Map Layers window. Click on the down arrow as you did
earlier, select Polygon Properties and then click on the Action tab. Choose the
option to Go to report and click the Browse button to choose the report to run
when clicking the map. Navigate to the Pro_SSRS folder and select the
Emp_Svc_Cost_By_Patient_State_RB3_Drill report. Click Open to return to the
Polygon Properties window. Since the drill through report requires two
parameters, we need to specify what parameters will pass through it. Click the
Add button twice and set the Name and Value pairs as shown in Figure 13-66.
Click OK to save the Polygon Properties Action settings.