Jump to content
Sign in to follow this  
David Jondreau

Numbering in a sub-summary part in a report

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Try adding an unstored calculation field in Donations =

Donor::CompanyName

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    MartieH 
×

Important Information

By using this site, you agree to our Terms of Use.