Firstly thanks for reading this post.
I am able to build a report with a graph from a query, but until now I've only made graphs with only one serie of data.
Now I have a query which is like a resume of an amount of data, which is perfect to make a graph with several series, to compare them.
I am not able to deal with matrix or bidimensional arrays (put my query into a bidimensional array) to put data into the grid of data of the graph.
Anybody know how to deal with this kind of object?
The code I need to manipulate is the next:
Code: Select all
While oResultset.next 'Esto es del libro de Mauricio
for i=0 to 0
'Redimensionamos la matriz
Redim Preserve mDirectorio( co1,Columnas)
'Guardamos los datos en el nuevo indice
mDirectorio( co1,i) = oResultset.getString(2) 'El 2 hace referencia al número de la columna que hay en la consulta
'Vamos construyendo nuestro directorio
sTmp = sTmp & mDirectorio( co1,i)
'Incrementamos nuestro contador de registros
co1 = co1 + 1
Next
Wend
Thanks in advance!