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.
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:
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.
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…