Community
Showing results for 
Search instead for 
Do you mean 
Reply

Sorting Data in Group Report

New Member
Posts: 1
Country: USA

Sorting Data in Group Report

How can you sort the data in a report.  I don't want to sort by traditional fields like name and company.

 

I want to start with city, address and unit #.  The sort does not stack the unit #s in order.

 

Any suggestions?

Nickel Elite Contributor
Posts: 595
Country: USA

Re: Sorting Data in Group Report


larjo4 wrote:

 

I want to start with city, address and unit #.  The sort does not stack the unit #s in order.


Most likely the filed you are using for the unit number is a character field and if so the sort will be a character sort which is strictly from left to right rather than numeric which is by numeric magnitude. For example a character sort would look like 1, 10, 11, 12...100, 101, 102...2, 21 etc.

Roy Laudenslager
ACT! Certified Consultant
Techbenders
royel@techbenders.com