How do I count grouped records in Base report

Mac OS X 10.6.8 and LibreOffice Base Version: I created the database in Base from scratch.
I created a report in Base with data grouped by a particular field value. So far so good.
Now I want to display a record count in the group header for each group in the report, i.e., Volunteers = 45.

I would create a view that adds to your data one column with this count for each entry, and then use it as any other field in the report.

The view (or query) code would be something like below, provided your data table is called “data” and the field your gather your group info from is called “group”:

SELECT * , (
   SELECT COUNT( * )  FROM data AS t2
   WHERE =
) AS `num`
FROM data AS t1

Other means exist to “count” the population of a group that might be more efficient, see a.o.

hope this helps.