I am trying to do something similar to this, but am sort of in an "in-between" state.
One option is to do something similar to what Dermott has stated, where I want to pick up the page numbers for the detail items.
The closest I can come to getting this functionality is via a table of contents, which displays the group name and the page number that the group starts on. The problem is I need the "table of contents" to show in a tabular form with other fields as well (for example, 3-5 fields for the group and the page number). Is there a way to do this?
Basically I want a section on the report shown only once (at the top of the report) that will show the group name and a few other fields and the page number that group starts on. Unfortunately I cannot "concatenate" the fields I want into the "group name" as I want them to show in specific fixed column widths for each field.
Then the detail would show as normal (per group) which has all the other fields.