02-28-2014 09:18 AM
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
03-03-2014 12:54 PM
You can only sort based off of one field. You cannot sort based off of Field 1 and then sort further by Field 2.
03-03-2014 01:42 PM
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.
03-10-2014 12:41 PM
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
03-10-2014 12:42 PM
03-11-2014 08:22 AM
Would you provide samples of the data in the fields in question?
03-11-2014 09:41 AM
Street name is character - ie Main St
Street no is Number - ie 1 ,21,31.....
03-11-2014 10:10 AM
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.
03-11-2014 10:52 AM
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