Last row in Sub Summary showing value it shouldn't be showing
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?