0 Replies Latest reply on Oct 25, 2014 1:02 PM by sccardais

    Last row in Sub Summary showing value it shouldn't be showing

    sccardais

      Title

      Last row in Sub Summary showing value it shouldn't be showing

      Post

      Two tables, Orgs and Support_Tix are related by ORG_ID. ORGs is an xxternal data source for Support_Tix.

      A sub summary report in Support_Tix based on Orgs contains two leading sub summaries and one trailing.

      The first sub summary sorts on the version of our product.

      The second sorts on a count of the number of Support Tickets received. This is a calc field in Orgs with a number result that counts the number of related records in Support_Tix. Count(SUPPORT_TIX::OrgID)

      When sorted, the last row of each sub summary section contains a record that is not related. e.g. There are no Support Tickets received from this ORG.

      Is this because the Report is being generated from the Support_Tix file with an external reference to ORGs? Should the report be generated from ORGs?