crosstab query report sort

[Souris]

I have a report using crosstab query.
The report automatically to sort alphabetical order by default.

for some reason, I need those information order as user enetred.

Are there any way to take out the auto sort alphabetical?


Your help is great appreciated,

 

[Duane Hookom]

Do you have anything stored anywhere that identifies the sort order?
Are you actually refering to the column order or the row order?

 

[Evi]

is it the column headers or is it the Row headers which you need to sort
differently?

I'm guessing that you are talking about the column headers. You can't sort
them non-alphabetically but you can replace the column heading with eg a
SortOrder number so that the user can specify what comes first, then you
could use a text box with a Dlookup in it for creating the visible column
headers in your report. So if your column headers currently contain
SalesPerson Name, you could use SalesPersonID as your column header.
Evi

 

[Souris]

Thnaks millions,

is it the column headers or is it the Row headers which you need to sort
differently?

I'm guessing that you are talking about the column headers. You can't sort
them non-alphabetically but you can replace the column heading with eg a
SortOrder number so that the user can specify what comes first, then you
could use a text box with a Dlookup in it for creating the visible column
headers in your report. So if your column headers currently contain
SalesPerson Name, you could use SalesPersonID as your column header.
Evi