AnsweredAssumed Answered

Using Summary fields to count records in related tables...

Question asked by brian.curran on Jan 17, 2013
Latest reply on Mar 7, 2013 by brian.curran

Title

Using Summary fields to count records in related tables...

Post

     Hi,
     I'm having trouble getting 'Summary' fields to display correctly.

     For info', I have created a List report based on the 'Site' table and it has two Sub-Summary parts:

     ClientName
     SiteName

     In the SiteName sub-summary part I have 4 fields from 4 related tables and everything looks fine after Sorting. At the bottom of the report, I have a Trailing Grand Summary part which contains 4 summary fields for the 4 related tables. These are all set to be Counts so that they display the total number of records but they each display "0"

     Any suggestions?

     Thanks
     Brian.

Outcomes