I am querying a measurements database in my web app that returns a table for a
product where column 1 is an integer ID number and the rest of the columns are
different measurements for that ID number. Note there may be several sets of
measurements per ID number. I don't know how many columns of measurements will be
returned as different products have different tests. I want to dynamically create a
reportviewer scatterplot for each measurement vs ID number. How do I do this with
VS2005 and VB? The end result I want is a page full of seperate graphs for each
measurement. I am making 2 versions of the app (for learning purposes) one web 
based and one stand alone form. Its the web one I really need as I can use a 
chart object in the form, but I guess it will be similar, i.e. created in the
VB code. I have created other controls dynamically but this one is a different
beast.
...

Basically what I want to do ... is have a panel on my web page that will be 
used to contain the reportviewer graphs (so I can turn the graph display on 
and off at user discretion). The panel starts off blank then my code will cycle 
through the headings of the table programmatically adding a new reportviewer graph 
for each column of data using say column 1 as the x data for each graph so graph 
1 = col 1 vs col 2, graph 2 = col1 vs col 3 etc.

I can deal with the looping to add the graphs but the bit I can't get my head 
around is how to programmatically specify the x and y data source and also the 
axis titles using the headings. All my graphs will be the same layout and format 
so I can use a single rdlc file for that.
...

I'm not sure a sketch will help in this case, its just a panel and I want to 
add graphs to it for each column. Don't worry about anything other than specifying 
x and y columns of a dataset (can reduce this to a datatable if its easier) 
programmatically for a reportviewer graph. Don't worry about what the graphs 
look like either they are just a simple scatterplot.

...

Mmmm... Actually looking back over all that waffle my question boils down to 
'how do I specify x and y axis datasource for a reportviewer graph programmatically 
when my datatable has more than 2 columns'and it results in a nice short 
blog post applicable to everyone programmatically scatterplotting with 
reportviewer ... its good to talk. lol.