How to sort Records by two Fields???

[vlad2]

I have two kind of customers: 1.Busuness and 2.Personal
in the report Customer List i need to sort all customers by The LastName and BusName.In the report on 'Change Group' I selected Customer.NameLast in ascending.

BUT report dispalay buss customer name(Bob's......) and then
Personal customers, sorting in ascending order.

How i can Sort by Both names???

thanks in advance.

 

[Ngolem]

I'm not sure what you are asking for but I will try to answer it.

You can create a grouping formula to do this task.

I am going to assume that you are already grouping by customer type (ie. Business or Personal)

the grouping formula can look something like

@groupingbyname

{table.LastName} + "," + {table.firstName} ;

now just create a group selecting this formula

Hope this helps
Jim

 

[IdoMillet]

Sounds like you need to create a formula such as:

IF {Customer_Type} = "Business"
THEN {Business_Name}
ELSE {Last_Name}

Then group or sort on that formula.

Cheers,
- Ido
ixm7@psu.edu