AnsweredAssumed Answered

Report with Fields from 2 Related Tables shows incorrect Summaries

Question asked by ScottM_2 on Jun 18, 2015
Latest reply on Jun 18, 2015 by philmodjunk

Title

Report with Fields from 2 Related Tables shows incorrect Summaries

Post

I’m sure the answer to this is simple, but I can’t seem to figure it out:

I have two tables CLAIMANT and CLAIM, which are related using 2 fields, MATTER and CLAIMNUMBER.  A single claimant can only be in 1 claim, but 1 claim can have multiple claimants. 

The CLAIMANT table contains the field for FullName (which is the only field I am interested in from this table for this report)

The CLAIM table contains fields for

         
  • Claim Number (Number Field)
  •      
  • TotalNumberOfClaims (Summary Field)
  •      
  • TotalPaidOutOnClaim (Number Field)
  •      
  • TotalofTotalPaidOutOnClaim (Summary Field)
  •      
  • TotalClaimants (Number Field)
  •      
  • TotalofTotalClaimants (Summary Field)

 

If I run a report showing records from the CLAIM table (subsummary when sorted by Claim Number, Trailing Grand Summary with TotalofTotalClaimants, TotalofTotalPaidOutOnClaim, Total number of Claims), I get the correct information for all the CLAIM table fields, but it only displays 1 claimant leaving the others off the report. 

If I run a report showing records from the CLAIMANT table, I get all of the Claimants listed, but none of the Trailing Grand Summary CLAIM fields are correct.

What can I do to get the correct information from both tables in the same Report?

Outcomes