SSRS Report Builder Part 12.4 - Drill Through Reports using Maps

By Andrew Gould

This video shows you how to create a clickable map in an SSRS report which you can use to drill through to another report showing more details. You'll learn how to find and import ESRI shapefiles and how to link your dataset data to the information contained in the map. You'll also see how to assign actions to the regions on the map and pass values to the hidden parameters of the target report when the map is clicked.

00:00 Topic List
00:37 The Example
02:07 Creating the Basic Target Report
04:05 Creating a Query Parameter
05:55 Hiding the Parameter in the Target Report
08:08 Creating the Basic Parent Report
09:42 Adding a Basic Map
11:08 Importing an ESRI Shapefile
14:15 Linking a Dataset to a Map
18:03 Setting the Map Visualisation
19:33 Bringing Back the Bing Maps Layer
20:44 Changing the Aggregate Function
21:58 Adding a Tooltip
23:48 Adding a Drill Through Action to the Map
25:36 Preventing Clicks on Invalid Countries
28:23 Saving the Map Report to the Report Server

[datagru]

Perfect, It's always great to learn from you 👍.

[AgentXXXAgent]

Good staffed material, short description for the base material. Thank you man. Is very helpful for me, then I go back to the SSRS after long time.

[houstonfirefox]

Very timely as I'm currently working on a project using simple geometry shapes stored in a table with a URL column for each. Depending on the shape clicked, jump to a URL associated with the column for that particular shape ID. Would prefer to do this with a basic map but understand Analytical may be the only way to go. New to mapping and drill-through on shapes (geometry, geography or otherwise) so this is helpful. Would be interesting to see a seating chart for a theater (geometry), click on a seat and view the details for that patron perhaps? Something to get the gears working. Very well done!

[jp_blue]

Hello, I do have a problem:
* First is when i run the report, it says : "There was an exception running the extensions specified in the config file. ---> System.Web.HttpException: Maximum request length exceeded".
Solution: Edited the web.config file increases the maxrequestlength

It now runs the report.

But another problem arises:
* In the report header, it says "The underlying connection was closed. An unexpected error occured on a send."

Any help would be appreciated