Solved

Can you group on a graph using different dataSets?

Posted on 2013-02-06
3
400 Views
Last Modified: 2013-02-21
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.
0
Comment
Question by:bruskhickory
3 Comments
 
LVL 9

Expert Comment

by:rajeevnandanmishra
ID: 38863440
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
 
LVL 18

Accepted Solution

by:
vasto earned 500 total points
ID: 38864790
If you already have the data retrieved the easiest way to process it will be to merge the tables. (I guess you have the same structure). Check DataTable.Merge Method:
http://msdn.microsoft.com/en-us/library/wkk7s5zk.aspx
0
 

Author Closing Comment

by:bruskhickory
ID: 38916384
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.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only seeā€¦
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question