Can you group on a graph using different dataSets?

Hi Experts, I have an unusual problem where I need to create a line graph comparing different dates of data. Problem is that each date is retrieved using a different dataset. The reason for this is that the "where" clause I use goes via a special odbc diver to the database. So I can only use one date retrieval per dataset.
At the moment I am using the first dataset to retrieve the first data points. I then use the second, third etc data points using the lookup feature.
This works fine for plotting each DataSet information as a line graph Horizontally E.g. The line represents 1 DataSet of information. However what I want to do is have each dataSet grouped long the X axis, so one line on the graph would represent many dataset data points.
I hope that makes sense. Firstly do you think this is possible and secondly how would I do this. Please let me know if I need to explain further.

Hi,
How you are creating the datasets? I mean isn't it possible to create a single dataset in a procedure (using union or temp tables) by querying multiple times?
In that way you will get a single output dataset that further can be represented in the graph.

You can use opendatasource/ openrowset methods of mssql also to fetch dataset using odbc drivers OPENDATASOURCE

0

bruskhickoryAuthor Commented: 2013-02-21

Great just information what I was looking for. I would have used 'union' to join different tables but I am unable to use this in the sql script do the odbc driver I am using.