I have a graph in which i display a count by month and in this graph i want to have the months in the order of their calendar appearance like jan comes first feb next and so on.but the SQL passthru Query returns them in random order.Is there any way to fix this.

This message has been edited. Last edited by: Kerry,

HOLD the results of the SQL Passthru query and then do your graph using the held data.

Thanks GamP for your response.I did try using this approach but it didnt work.Below is what i tried.
DEFINE FILE ca
MNT/A10 = DECODE('JAN' '01'..so on);
END

Table file CAR
sum
X1 By MNT
on HOLD AS V1
END

GRAPH FILE V1
SUM X1
BY MNT
END
-This is wat u meant has to be done ??.If not can u suggest me a working example for this problem.thanks for ur help

Either put a decode on your SQL statement to mark JAN as 01, FEB as 02 and so on or do a define field. Here's a sample.

DEFINE FILE EMPDATA
MN/M=DATECVT(HIREDATE, 'YMD', 'M');
END

GRAPH FILE EMPDATA
SUM CNT.PIN
ACROSS MN
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,1);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END
-EXIT

This question has been asked and answered many times in this Forum. Here is a link for one solution:
http://forums.informationbuild...731008331#5731008331
Try using the Search button and do a search on graph and month or date or some combination and see what you can come up with.