Joined: 13 Dec 2011
Location: United States
Online Status: Offline
Posts: 2
Topic: How to sort on a non group field Posted: 06 Jan 2012 at 7:26am
Hi,
I am trying to sort on a field, Store number which is a Group footer. There are 2 groups in this report, Customer then Material but they are not displayed in the report. I need to sort on Store number.
There is just
Page Header - Different headings
Page Footer - Display/calculations - I am using store number here.
Report Footer - Totals.
Sort Expert, sorts first on the groups and ignores on the Store number(numeric).
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 06 Jan 2012 at 1:41pm
Groups always supersede other sorting.
You can do top n group sorting if you all of the rows in the group have the same store or if you want to use the max or min within that group.
You can also possibly do a group 1 as your store number and hide that.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
