Ahhhhhhhhhhhhhhh - Report Sorting

[Ice Rhino]

I have done a serach of the Forum and as yet have not found the answer to this.

I have seen talk of Sorting and Grouping in reports but it does not appear to help me.

I have a report that is based around a Horizontal Bar Graph. There are five regions from West to Albany. When the report displays them it places West at the top and Albany at the bottom.

I went into Sort & Grouping in the report design view and under the 'Field / Expression ' drop down there was no entries, so I tped in the name of the field and it makes no difference.

Please, someone tell me how to reorder my reports

Frustrated

Toni

 

[Rich]

Try sorting in the underlying query.

 

[Ice Rhino]

Yeah I did that and it is all now sorted

Many Thanks

Ice Rhino