I have a report that has a group row that shows a group name and sum details in certain columns. Then a details row within the group. I show the detail rows hidden to begin with and an expansion button. That part works. I also want to be able to sort on the group's aggregate data, not detail data. So when the detail rows are hidden, someone sorts on the columns (showing sum data for that group's data) and the column values sort correctly over the entire table.
What I don't want to do is remove the detail row from the report entirely.
Thanks for any help.