microsoft.public.vb.crystal - Microsoft Visual Basic
Hi - Any idea why the SQL queries that are created by the Cross Tab Query Wizard cannot be ran in VBA? It starts off with the 'TRANSFORM' statement, as opposed to the usual 'SELECT' statement IS this the reason why? Or is it because I have 'PARAMETERS' defined in the SQL statement? How would I ran a Cross Tab query in VBA? Please Advise
I have a sql table with four column named Availability, Performance, Quality and OEE. I am wanting to make a simple bar graph with each of the columns having its own bar in the graph. However this is not exactly the x and y relationship that the .net graph control is looking for since it wants to see the value and name in separate columns such as... COLUMN 1/name COLUMN 2/value Availability .5 Performance .75 Quality .88 OEE .75 Off course if I had the information in a table like above I would have no problem making the chart since the .net chart control is looking for this x and y format. However my data is in the table like so... Column 1/ Availability .5 Column 2/ Performance .75 Column 3/ Quality .88 Column 4/ OEE .75 So you see I have to figure out a way to get the chart to read my table in this format. Do you have any suggestions or examples on how to get around this. Another program is putting the data into sql this was so I cannot just change the sql table structure without totally reprogramming so I have to find away to pull the data out of the table while in this format. Your help is much appreciated.