SSRS 2008 R2 I have been asked to recreate a report/program originally written in a very old version of Cognos. The report does not function at all so I am going on what people remember of how it worked and what I believe they are wanting. Basically the report is a map of our facility that shows labeled storage areas that correspond to identically named locations in a database. The database contains information of what parts and their quantity is stored at each location. By clicking on a location on the map it should bring up a list of exactly what is stored there and the quantity. Another option would be to enter a part number and have all locations that contain that part change color. A list should also display naming each location with that part and the quantity there. I have no idea of how to make this work. Any suggestions or examples would be greatly appreciated.

Are your maps shapefiles or images? If it is images, you can go along the way Rapier has suggested. If they are shapefiles, maybe it is better to follow a different approach- 1) Drill down on Storage Location map report a) For this you will need 2 reports - Map report by Storage Location - Tabular report containing list of what is stored there and how much b) For the Map Report, you can do it easily with the map wizard in SQL Server 2008 R2 SSRS. Import the shapefile and define the spatial field and the measure field. c) For the tabular report, there should be a report parameter for Storage Location. d) Now in the map report, add an action which will invoke the Tabular report and pass the storage location 2) Map report for entering part number a) Have a report parameter for part number in the map report. b) The dataset which supplies the spatial field should be filtered by this report parameter. c) Now ideally, only the storage locations filtered by the part number parameter should have color in the map, all the other storage locations would be white in color. These are the general steps which you should follow, but if you are a complete beginner in SSRS map reports, you might want to look at some of the posts below http://technet.microsoft.com/en-us/library/ee240845.aspx http://road-blogs.blogspot.com/2010/12/drill-down-in-ssrs-map-reports.html http://clinthuijbers.wordpress.com/2010/04/23/drilldown-functionality-in-maps-ssrs-2008-r2/ http://road-blogs.blogspot.com/2010/09/import-shapefiles-into-sql-server-and.html Feel free to ask more questions... :) Cheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Sound like this requires a bit of lateral thinking; my idea of fun! First, I'd create a report that lists products and quantities, with the location as a parameter and a filter. Next, I'd import the map as an image and over each storage area I'd place a text box. Each text box can be given an 'action' to link to a report and pass a set of parameters. By giving each box the action of referring to the same report, but with the approriate parameter, clicking on the area/box would bring up the list of products and quantities there. For the item list, I'd start with a new report but a similar idea. Enter the part number and the list shows the locations. The various properties of the text boxes (e.g. borders) over the map can be set by fomulas, so they can highlight the room if the quantity of the selected product is greater than zero. I just hope all your store rooms are rectangular! Ray If this post, or another, answers your question, please click the 'Mark as answer' button so others with the same problem can find the solution more easily.