I want to summarize by field A but sort the sub-summary by field B when the sub-summary is by field A.
Typically I sort first by Field B and second by Field A. Data is grouped by Field A by but is sequenced by field B. This works fine on several layouts in the solution. However, on one layout the data will only group by field A if I sort by field A but that takes the report out of sequence.
I am supposed to be using the Reorder by summary field feature instead of my current method?