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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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