1. Yes and no. The report groups by SO and then by Date (I called this Version in my description to simplify things).
2. The list is not dynamic. The user picks the year and month (not an exact date or date range).
3. The formula for details suppression is as follows:
(TOTEXT({?Year}) + {?Month}) <> (TOTEXT({AXTerritorySales_query.Next Version Year}) + {AXTerritorySales_query.Next Version Month Name})
AND
(TOTEXT({?Year}) + {?Month}) <> (TOTEXT({AXTerritorySales_query.Created Date Year}) + {AXTerritorySales_query.Created Date Month Name}))
Edited by bspencer1 - 06 Jul 2015 at 7:50am