title: Drill down in SSRS US Map Reports
body: <p>I have been interested in map reporting, so I wanted to create a map report with drill down functionality, so basically created two reports as follows:
  a) Main report based on SQL Server Spatial data for showing US States wide sales
  b) Drill down map report based on ESRI shapfile for showing US Counties sales for the selected state</p>
  
  <p>I downloaded the US Counties ESRI shapefile. </p>
  
  <p>Once I was done with the reports, I tested the map with drilldown functionality. I previewed the main report, hover the mouse over Texas and I don't see the counties for Texas state. I see only a map of the US with tiny dots.</p>
  
  <p>So, I am not sure what I missed. I chose County Name column from the spatial data and also the county name from the analytical dataset. Is it the ESRI shapefile? </p>
  
  <p>Please advise.</p>