SSRS 2008 R2: Redrawing one map based upon clicking a polygon in another
I have an SSRS 2008 R2 report which has 2 map objects; a main map, and a sub-map. (They're actually treemaps, but I believe that's unimportant.)
My objective is that when a polygon is clicked in the main map, it passes one of its properties to the sub-map, and the sub-map is updated in the context of this passed property.
Currently, I have a hidden parameter on the report. The sub-map's dataset is dependent on this parameter. So in the main map, under map polygon properties, I have the Action set to "Go to report", and it calls itself again with a property of the polygon passed to the report parameter.
I'm just wondering if there's a more elegant way to do this (perhaps custom code?), and if there's a way to avoid re-drawing the report.
I could see, perhaps, getting a larger dataset for the sub-map, applying a filter based on the passed parameter.... but is a re-submit still necessary?
One more question: is there a way to highlight the polygon (eg: a dotted border) on hover-over and/or mouse-click? I know tooltips exist, but they don't identify boundaries.
An example based upon AdventureWorks data is attached.
Thanks.
Sample-Treemap.png
My objective is that when a polygon is clicked in the main map, it passes one of its properties to the sub-map, and the sub-map is updated in the context of this passed property.
Currently, I have a hidden parameter on the report. The sub-map's dataset is dependent on this parameter. So in the main map, under map polygon properties, I have the Action set to "Go to report", and it calls itself again with a property of the polygon passed to the report parameter.
I'm just wondering if there's a more elegant way to do this (perhaps custom code?), and if there's a way to avoid re-drawing the report.
I could see, perhaps, getting a larger dataset for the sub-map, applying a filter based on the passed parameter.... but is a re-submit still necessary?
One more question: is there a way to highlight the polygon (eg: a dotted border) on hover-over and/or mouse-click? I know tooltips exist, but they don't identify boundaries.
An example based upon AdventureWorks data is attached.
Thanks.
Sample-Treemap.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER