Simple X Y Pushpin type chart over picture
I have the following example data stored in a table, X_Coord, Y_Coord, Type 2152,514, Damaged 1743,3480, Missing 2940, 4251, Torn 3591, 1770, Hole I know the minimum and maximum values for the X Y coordinates. There will be hundreds/thousands of points. I would like to be able to output this data visually in reporting services by plotting a point at the given x,y coordinates and have the color based upon the "Type". What would be the best way to do this? If possible, I would also like to be able to put an image behind this data because the x-y coordinates relate to a position of an actual product. This would allow users to run a report and visually see where problems are occurring on the specific product. Thanks for any help
October 23rd, 2010 7:07pm

Hi, We can use Scatter Chart to display these points. For example, in Reporting Services 2008, we can achieve this by the following steps: 1. Add a Chart control to the report and select the Chart Type for Simple Scatter 2. Drag and drop the X_Coord field in dataset to the category fields area of the chart. Drag and drop the Y_Coord field in dataset to the data fields area of the chart. Drag and drop the Type field in dataset to the series fields area of the chart. It is also possible to set a background image for the chart area. Please refer to the steps below: 1. In the Report Data window, click New in the menu and select Image… 2. Select an image in the Open dialog and click Open. 3. Select the Chart Area in the chart control. 4. In the Properties window, select the picture in Value property in the BackgroudImage category. For more information about Adding Images to a Report, please see: http://msdn.microsoft.com/en-us/library/ms156482(SQL.100).aspx If you have any question, please feel free to ask. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help
Free Windows Admin Tool Kit Click here and download it now
October 26th, 2010 5:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics