Post reply

Create a click-through map in SSRS2012

  • August 21, 2013 at 1:45 pm

    #281378

    Apologies if I'm wrong on my terminology. I'm a beginner at SSRS pretty much.

    Using the wizard, I created a map of the USA showing counts in each state based on my dataset. That part works fine. What I'm wondering, though is if I can use the map (and the individual states in the map) to filter a second report (like a drill-through report). I can use the country map to drill down to an individual state, but what I cannot figure out how to do is to show only the selected state in the second report that's opened by the clicking on the individual state.

    Thanks!

    pieter

  • August 21, 2013 at 11:11 pm

    #1643746

    You need to add an action to the layer of the map that represents the states with the data you are showing. To do this, from the "Map Layers", right click on the polygon with the data you are showing. From the context menu that pops up, select "Polygon Properties". And from there, add an action to show the report you want to drill down to. You should be able to include the relevant parameter to that report (e.g. State).

    Attached is a really simple example showing a map that drill down on state. The data is completely arbitrary and has values for California and Texas only. The report needs a connection to any SQL Server but no tables... the data is hardcoded select statements.

  • August 22, 2013 at 12:09 am

    #1643760

    Thanks HappyCat,

    worked a charm!

    Pieter

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply