I have a table with many fields. The most important of which is a SortOrder field which simply contains a number so that reports are sorted accordingly.
I also have another description field. In a report, I'd like to use the description as a sub summary to group together like records, BUT it should never override the sort order field. I'm not sure how to do this so that my sort order is always preserved? Thanks for your help!
Here's what I'd like my report to look like:
(Note how a category repeats rather than mess up my sort order)