Numbering in a sub-summary part in a report

[David Jondreau]

I'm totally blanking here. I've got a table of Donations and a table of Donors related by Donor ID. I've got a found set of Donations, sorted by alphabetically by Donor Name. I've got a sub-summary part breaking on Donor Name, listing the Donor Name and Donor City and Donor State and a summary field of Total Donations. That all works fine.

I just want to number each Donor on the sub summary section of the report, but can't figure it out.

What am I missing?

DJ

[comment]

See here.

[David Jondreau]

OK, thanks, this is close, real close, if I was sorting by the local Donor ID I'd be set.

But I'm not sorting by the Donor ID in the parent Donations table, but in the related Donors table by Company Name.

GetSummary must break on the parent table and I don't know how to get around that.

[comment]

Try adding an unstored calculation field in Donations =

Donor::CompanyName

then change your sort step and the sub-summary part to use that instead.

[David Jondreau]

Ah, right. Thanks.

That's a pretty clever technique: creating a calc field which each element of a group is a fraction of the total number in the group and then adding it all up to get 1.

Seems like there should be a simpler way, but this works great.