Plotting Groups as Chart Series

Question

Does anyone know how to get a group from an SQL statement into a chart series?  For example, if I have Manufacturer, Price, and Weight as 3 columns in a single table, and I want to plot Price vs. Weight for each manufacturer in a chart, how do you do that?  Assigning 'Price' to the YValueMember and 'Weight' to the XValueMember of a series plots all manufacturers together.

Answer 1

I Have done this kind of reporting using SAS as front end which connects to SQL databases.  Are you using report builder ? If not ,
I think it will be good to have a look at REPORT BUILDER , where these kind of reporting formats are available.

---

Thanks, Leks

Answer 2

Hi,

Well, I think you can try reporting service with stored procedure or SSAS as backend data source (it's just based on your own scenario.) After you query the data, you can bound it to chart control which is avaible in rreporting service.

For more information, see:

http://msdn.microsoft.com/en-us/library/ms170246(SQL.90).aspx

Thanks.

---

Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.