Sorting and using a group footer

[Melanie O]

I'm trying to format a report with a sort order and a group footer. Example
data:

WorkOrder GroupID
1 1
2 1
3 4
4 4
5 2
6 2

When the Sorting and Grouping box lists WorkOrder first, the report is
sorted correctly, but I can't get the GroupID footer to show a line only
after the end of each group. If the GroupID is first, the report is sorted
by GroupID (not what I want), but the GroupID footer correctly places a line
only after the end of each group. How do I get the report to sort by
WorkOrder AND get a line after only a change in group?

Thanks,
Melanie

 

[Marshall Barton]

I'm trying to format a report with a sort order and a group footer. Example
data:

WorkOrder GroupID
1 1
2 1
3 4
4 4
5 2
6 2

When the Sorting and Grouping box lists WorkOrder first, the report is
sorted correctly, but I can't get the GroupID footer to show a line only
after the end of each group. If the GroupID is first, the report is sorted
by GroupID (not what I want), but the GroupID footer correctly places a line
only after the end of each group. How do I get the report to sort by
WorkOrder AND get a line after only a change in group?

It's working the way it's supposed to. Think about it.

What would you want to happen with this data:

WorkOrder GroupID
1 1
2 4
3 2
4 4
5 1
6 2