I have created a map report in SSRS 2008 R2 that uses geography data types to create a polygon map layer of adjoining areas. I want to be able to use the tooltip option to show properties from each of the individual areas of the layer, but it seems like I can only use aggregate data from all of the data in the layer and not any of the data specific to just the area in the layer I am hovering over. Is showing aggregate data the only option for a map tooltip, or is there some way to show the data from the individual areas in the map layer that I haven’t figured out yet?

You should be able to use any data fields from map itself or the dataset associated with this map layer. Try to use Expression if you can’t find the aggregation type you need from the default listYi Liao - Microsoft

I was using two different data sets. One dataset with the data and the second dataset with the geography polygons. Once I created a new dataset that had the data and the geography polygons in the results, I was able to use the tooltips to show the data for each individual geography in the layer.

Hello Yi, When I use the expression I am getting following error: Warning 1 [rsRuntimeErrorInExpression] The ToolTip expression for the map ‘Map1’ contains an error: Input string was not in a correct format. \\...\ Services\Geomapping\Geomapping\Geomapping\Final.rdl 0 0 Thanks for your help, Kosaraju.