03-27-2011 01:03 PM
Sage ACT! Premium 2011 Version 126.96.36.199, Hot Fix 2
Field: Arb_name, 35 characters
Report: Edit > Define Section> one and only section based on Arb_name, Sort: Ascending
Report result: no sort order
Experimenting, I added a new field
Field: ArbSortName, 35 characters
Values: Assigned values with Edit > Copy Field from Arb_name to ArbSortName
Report: Edit > Define Section> one and only section based on ArbSortName, Sort: Ascending
Report result: ascending sort
I have found two fields that behave this way. There are another ten used in reports that sort as expected.
03-28-2011 08:42 AM
A sort imposed by a section won't work when the field specified for the sort comes from a different database table than the table being sorted. My reaction to your description is that in can't happen but I would need to have both the report and the database to troubleshoot what might be happening.