I have spent 40-60 hours trying to figure out why my reports don't group. They used to, but not anymore--I don't know why not.
I have a database for a healthcare org. that has 5 locations/sites. Each site has patients. I want a report that has a section for each site, that lists the patients. The user selects the Start Date and End Date, then clicks a Preview button on the main screen.
-It launches the report
-It restricts it to between the Start and End Dates
-But only the first site is showing up on the report.
(Also, within each section it shows how many visits per client, then in the section footer it sum's each 'column'. That part works fine, it sums them ok.)