Order bar chart by year 1

[gromboy]

Hi,
I'm trying to order my x axis of my bar chart by year then month.

The chart shows 12 months worth of data but it depends which months appear as to when its ran. eg could be May 07 to May 08.

I want the chart to graph left to right starting with the oldest month first eg May 07, June 07, July 07 etc to the newest.

I have a date field called "apptdate" in the database which is what I want to use.

I've managed to concatenate the year and month using totext but it doesnt order properly..
Any ideas would be greatly appreciated !
Steve

 

[lbass]

I think you are stuck with using a formula like this:

totext(year({table.date}),0,"")+"-"+totext(month({table.date},"00")

This will sort correctly, but will not give you the desired monthname display. The other option is to use specified order, but that won't work if the range can change each time the report is run.

-LB

 

[gromboy]

Thanks for your response.
I'm getting a" ) is missing error"

totext(year({PATDRUG.APPT_DATE}),0,"")+"-"+totext(month({PATDRUG.APPT_DATE},"00")

 

[lbass]

totext(year({PATDRUG.APPT_DATE}),0,"")+"-"+totext(month({PATDRUG.APPT_DATE}[red])[/red],"00")

Sorry.

-LB

 

[gromboy]

SPOT ON..
Thankyou LB
Steve