View Full Version : Order Report on Group?


01-22-2005, 01:09 PM
I have a one-to-many set in which volunteers are connected with donations they obtain. I created a report, grouped by volunteer, with the sum of each volunteer's donations. Except I can't get the report sorted by volunteer last name.

I've designated that as the sort key for the report. What I get is record number order.

The report fields are all in the Group Header, because I could not see how to place a total() field in the detail section -- I just get every volunteer-donation record, not the total by volunteer.

Tom Cone Jr
01-22-2005, 01:23 PM
Are you grouping by last name, or using some other field or expression?

Have you set group properties to "order by group"?

-- t

BTW, I would have used the group footer for group totals, not the group header.

01-22-2005, 03:14 PM
Tom, thanks for the suggestion. I put the fields in the footer. If there's any difference, perhaps I got more even line spacing.

You hit the nail on the head: I had ordered the groups on "volunteer ID" which is assigned sequentially as new volunteers are entered. Of course, I got what I asked for! Changed that to LastName and all is well.