Thanks. I think I understood enough of your suggestion to make some progress. I am now suppressing the 7/28/2013 confirmation you see in the image, however it has ferreted out another problem. Users are able to pick a date range to get the confirmation details at a point in time. My distinctcount by sales order formula, which evaluates to 3 in the above example, needs to evaluate based on the date range. In other words, if the user was to select a date range of 07/01/2014 to 8/30/2013, then the distinctcount would need to evaluate to 2 so that it displayed the 7/28 and 8/28 confirmations (not the 9/3 one). The parameter on the report is a date range parameter. I tried this, but it still evaluates to 3:
IF ({AXTerritorySales_query.Date} >= MINIMUM({?Date Range}) AND {AXTerritorySales_query.Date} <= MAXIMUM({?Date Range})) THEN DISTINCTCOUNT({AXTerritorySales_query.Date})