AnsweredAssumed Answered

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

Question asked by sccardais on Oct 25, 2014

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? 

 

Outcomes