Community
Showing results for 
Search instead for 
Do you mean 
Reply

Report Sorting on Secondary NUMBER field

Copper Contributor
Posts: 108
Country: Canada

Report Sorting on Secondary NUMBER field

Created a report to provide contact information and I need to sort by address

I created fields -STREET, STREET NO (Formatted as a number field) & ODD (Yes/No Field)

 

I can sort by Street field but cannot get sort to work for STREET NO?

 

Any Ideas' thanks

Tom David Moxam
Moderator
Posts: 719
Country: USA

Re: Report Sorting on Secondary NUMBER field

You can only sort based off of one field. You cannot sort based off of Field 1 and then sort further by Field 2. 

Elise O'Pry
Swiftpage
Visit our knowledgebase at http://kb.act.com
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Report Sorting on Secondary NUMBER field

Sorting in a report is based on the actual structure of the report. A report can have several nested sorts based on the configuration of added sections and the sorting imposed by those sections.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 108
Country: Canada

Re: Report Sorting on Secondary NUMBER field

I have 2 sections

section 1 = street

section 2 = street no

I can sort by one or the other but not both

As an interesting note I followed the example of one posting and added Street no 2 and copied info from "Street no" to it.

Sort worked initially but no longer does Smiley Sad

Tom David Moxam
Copper Contributor
Posts: 108
Country: Canada

Re: Report Sorting on Secondary NUMBER field

I have added sections and set the sort parameters for each section
Section 1 = Street
Section 2 = Street number
Tom David Moxam
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Report Sorting on Secondary NUMBER field

Would you provide samples of the data in the fields in question?

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 108
Country: Canada

Re: Report Sorting on Secondary NUMBER field

Street name is character - ie Main St

Street no is Number  -  ie 1 ,21,31.....

Tom David Moxam
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Report Sorting on Secondary NUMBER field

Without testing I suspect that the problem lies in mixing sort types, that is and alpha sort with a numeric sort. I've used many hested sorts in reports and they have always worked but they were always the same type sort. You could try creating a seperate street number field, copy your street data to that field and then change the field to alpha and see it that will work for sorting. The one caution is that the street will be an alpha sort, that is 1, 10, 11, 12, etc. 

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 108
Country: Canada

Re: Report Sorting on Secondary NUMBER field

What I have done (But don't think I shouldn't have too) is removed all sorting on report and relying on lookup

Ok for simple 2-3 step sorting

 

Thanks for help

 

Tom

Tom David Moxam