Report Sorting on Secondary NUMBER field

[Oldlaxdude]

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

[Elise]

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

[Roy_Laudenslager]

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.

[Oldlaxdude]

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

[Oldlaxdude]

I have added sections and set the sort parameters for each section
Section 1 = Street
Section 2 = Street number

[Roy_Laudenslager]

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

[Oldlaxdude]

Street name is character - ie Main St

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

[Roy_Laudenslager]

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. 

[Oldlaxdude]

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