L
Lilia
Hello
How I can sort the categories of a chart?
I am using the object (OWC10.ChartSpace), and
it doesn't work the option "ORDER BY", from the QUERY
Does some property of the ChartSpace exist to manipulate the Order?
I working Year and Month concatenated in the axis (x) and my graph shows
2004-1, 2004-11, 2004-12, 2004-2, 2004-3 or 2004-Apr, 2004-Aug, 2004-Feb,
2004-Jun etc.
and I need to show me for real sort of months.
2004-Jan 2004-Feb, 2004-March, 2004-Aph etc
PLEASE, Thanks
sSQL="SELECT Producto,Año &' ' &
Choose(Mes,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dic') AS AñoMes,Precio, COUNT (*)as cuenta From MateriasPrimas" &_
" Where (" & complemento & ") " & _
" AND (Año Between " & anual1 & " and " & anual2 & ") AND (Mes Between " &
mes1 & " and " & mes2 & ")" &_
" group BY Año,Mes,Producto&'_'&Unidad&'_'&Tipo&'_'&Mercado,Precio" &_
" ORDER BY Año DESC,Mes DESC,Producto&'_'&Unidad&'_'&Tipo&'_'&Mercado
DESC,Precio DESC"
How I can sort the categories of a chart?
I am using the object (OWC10.ChartSpace), and
it doesn't work the option "ORDER BY", from the QUERY
Does some property of the ChartSpace exist to manipulate the Order?
I working Year and Month concatenated in the axis (x) and my graph shows
2004-1, 2004-11, 2004-12, 2004-2, 2004-3 or 2004-Apr, 2004-Aug, 2004-Feb,
2004-Jun etc.
and I need to show me for real sort of months.
2004-Jan 2004-Feb, 2004-March, 2004-Aph etc
PLEASE, Thanks
sSQL="SELECT Producto,Año &' ' &
Choose(Mes,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dic') AS AñoMes,Precio, COUNT (*)as cuenta From MateriasPrimas" &_
" Where (" & complemento & ") " & _
" AND (Año Between " & anual1 & " and " & anual2 & ") AND (Mes Between " &
mes1 & " and " & mes2 & ")" &_
" group BY Año,Mes,Producto&'_'&Unidad&'_'&Tipo&'_'&Mercado,Precio" &_
" ORDER BY Año DESC,Mes DESC,Producto&'_'&Unidad&'_'&Tipo&'_'&Mercado
DESC,Precio DESC"