Herb Posted March 24, 2010 Posted March 24, 2010 I have tables named Posting and Donations. There can be any number of Donations within a Posting. Donations represent checks identified by Donor ID, Date and Check Number. Checks are assigned to a Team Member (another table.) However, Checks can be "split" meaning shared by multiple Team members. In a split, the application creates multiple Donation records (1 for each team member sharing the donation) with amounts reduced to reflect the sharing - the Donation amounts for the same check number will always total the Check Amount of check. I want to produce a report and an extract (e.g. CSV) of the checks in a Posting that ignores any splits. My question is what's the best way to accomplish this - via Db schema (how?) or via a report rollup? Thank you.
Herb Posted March 30, 2010 Author Posted March 30, 2010 I figured out how to do the roll-up on a list view. I can now produce the desired report on a Layout, and give the user the option to extract to a tab-delimited file. This has raised another roll-up question: I want to display to the user the Count of the number of lines in the roll-up. The roll-up is defined in a sub-summary Part. How can I get at such a Count? Thank you.
Recommended Posts
This topic is 5412 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now