Community
Showing results for 
Search instead for 
Do you mean 
Reply

What makes a field not sort in a report?

New Member
Posts: 1
Country: USA

What makes a field not sort in a report?

Sage ACT! Premium 2011 Version 13.1.111.0, 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.

Platinum Elite Contributor
Posts: 6,662
Country: USA

Re: What makes a field not sort in a report?

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.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129