How do I custom sort records in a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been using the following in my query for the report but when the
report displays the data, it's not sorted. How do I custom sort records in a
report?

Expr1: Switch([Month Quoted]="January",1,[Month Quoted]="February",2,[Month
Quoted]="March",3,[Month Quoted]="April",4,[Month Quoted]="May",5,[Month
Quoted]="June",6,[Month Quoted]="July",7,[Month Quoted]="August",8,[Month
Quoted]="September",9,[Month Quoted]="October",10,[Month
Quoted]="November",11,[Month Quoted]="December",12)

Thank you,
 
Reports don't respect the order in the underlying query. You need to use the
Sorting and Grouping dialog in the report designer.
 
Reports don't respect the order in the underlying query. You need to use the
Sorting and Grouping dialog in the report designer.
Click to expand...

In your report set Expr1 as the first item in sorting and grouping and make it
ascending.

Chuck
--
 
Back
Top