I have a report that is grouped by Job Number.
The report only display header type of data for each Job Number so I don't need to do any sorting of records within the group since there is only header type data.
What I need to do is have the overall report sort by a field within this header data that happens to be a Date field. This Date field is displayed in the group footer.
Is this possible? When I go into Sort Expert, it has my Job Number grouping as the primary sort and will not let me put this Date field above it to be the primary sort??