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