Solved

Create an arrayList or temp db table at runtime so I can create a graph with data not related

Posted on 2013-01-29
1
822 Views
Last Modified: 2013-01-30
Hi Experts,
I have a problem were I need to create a graph from 24 fields of data which are not related in any way apart from that they come from the same table.  There does not seem to be any way I can do this. What I want to do is create a stacked bar graph in ReportBuilder3 and compare 12 items. Each item would have a value A or B.  However since the information is not related e.g. Field1.1ItemA, Field1.2ItemB, Field2.1ItemA, Field2.2ItemB, etc, ...Field12.1ItemA, Field12.2ItemB.
They have been created in one table. Normally this would be created over two tables but due to the way the sofware works this could not be done. I am accessing data via an odbc to an SQLServerdb.
My current sql query is
Select  Field1.1ItemA, Field1.2ItemB, Field2.1ItemA, Field2.2ItemB, etc, ...Field12.1ItemA, Field12.2ItemB.
From TableAlpha

How can I create some sort of relationship so that I can a graph 12 items A vs B in a stacked graph. At moment I am looking to either create an ArrayList or create a temp db at runtime and load them in.  I don't know how to do either of these. Any guidance or examples I can view to see how to do this would be very much appreciated!.
Many thanks,
B
0
Comment
Question by:bruskhickory
1 Comment
 
LVL 6

Accepted Solution

by:
liija earned 500 total points
ID: 38834039
How about this as data source query?

SELECT 'Field1' AS Description, Field1.1ItemA, Field1.2ItemB FROM TableAlpha
UNION ALL
SELECT 'Field2' AS Description, Field2.ItemA, Field2.ItemB FROM TableAlpha
UNION ALL
SELECT 'Field3' AS Description, Field3.ItemA, Field3.ItemB FROM TableAlpha
etc...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

911 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now