3 Replies Latest reply on Mar 7, 2013 7:42 AM by brian.curran

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

    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.