Sorting and Grouping Option

[PJ]

I have a report that I am trying to sort by the following using the sorting
and Grouping option of the report:

Field Names:
1) Agency Specialist Closer
2) Lending Unit

I have a Agency Specialist Closer Header with the following fields in it:
Agency Specialist Closer

and under detail I have the following fields:
Customer Name
Loan Type

It works fine but I am trying to have customer name in alpa order with loan
type next it and if the loan type is "Assigned" have them on the buttom with
customer name in alpa order. Example:

John Doe
ABC Company - RE
Brown Company - SAG
C Company - AG
D Company - Dealer
A Company - Assigned
B Company - Assigned
T Company - Assigned
Z Company - Assigned.

How would I do this in the sorting and Grouping option? Would it be a Instr
and how??


Thanks in advance

 

[Duane Hookom]

If I understand correctly, you can create a sorting and grouping level with
an expression like:
=Abs([Loan Type]="Assigned")