In my monthly SSRS 101 class (http://sharepoint.rackspace.com/ssrs-training) one of the topics we cover is using the map in report builder to show sales concentrations in the United States. In the example we use, our final report looks similar to the image below:
In the class we use “Actions” to allow the user to click a state name in the table and navigate to a different report that shows state specific sales information. I’ve had multiple students ask if it’s possible to enable the same type of navigation within the map itself. So many people have asked actually, that I thought I’d do a quick write up on how you can implement it.
Implementing the actions within the map component is basically the same as implementing action within the Tablix. We still use the “Action” option, and choose which report we would like to link to, and then pass in the appropriate parameters. The only difference with the map is that the correct action settings are somewhat hidden and a little difficult to find if you haven’t worked with the map much. To implement this functionality in the map you’ll need to do the following:
- Open your report in Report Builder or BIDS/SSDT
- Click twice on the map object until you get the “Map Layers” window
- In the “Map Layers” window click the dropdown triangle to the right of the “creepy eye”
- From the available options select “Polygon Properties…”
- From here you can select the “Action” option and start to link your report as you normally would. In our case we’re linking to a report that is currently deployed to SharePoint and accepts parameters for the StateProvinceName, EnglishProductCategory, and EnglishProductSubCategory.
That really all there is to it. If we run the report now, we should be able to click on individual states within the map and be redirected to our “detail” report (which we would have to build separately). In the example report you saw earlier in the post, if we click on California in the map we’ll be redirected to a report that looks similar to the following:
That’s it for this post, hopefully you found it useful, and as always….happy reporting!