title: Using SQLGeometry to display an item location on a floor plan in SSRS
body: <p>Inventory items have a location field corresponding to a physical warehouse location i.e. item X location field states 'A01' corresponds to shelf location A01.<br>
  How can I leverage this data to display item locations on a floor plan of the warehouse?<br>
  Perhaps in the form of an SSRS report query for item X displaying the location on the floor plan?<br>
  I've searched around and seen that this <a href="http://msdn.microsoft.com/en-us/magazine/ee335706.aspx" rel="nofollow">can be done</a>:</p>
  
  <blockquote>
    <p>"To start with the simplest case, suppose you’d like a map of the
    layout of your company’s warehouse (a physical warehouse where goods
    are stored, not a data warehouse). You’d likely measure the warehouse,
    draw a floor plan, and map the placement of the goods based on their
    location in the floor plan."</p>
  </blockquote>
  
  <p>But I cannot find steps on how to achieve this. Any help in this regard appreciated.</p>
  
  <p>Currently using SQL 2008 R2</p>