SSRS Report Builder Part 12.4 - Drill Through Reports using Maps
By Andrew Gould
Full SSRS Report Builder Playlist • SSRS Report Builder
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
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
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more
Watch video SSRS Report Builder Part 12.4 - Drill Through Reports using Maps online without registration, duration hours minute second in high quality. This video was added by user WiseOwlTutorials 29 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,456 once and liked it 35 people.