Mac OS X 10.6.8 and LibreOffice Base Version: 4.3.4.1 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 t1.group = t2.group
) AS `num`
FROM data AS t1
Other means exist to “count” the population of a group that might be more efficient, see a.o. http://stackoverflow.com/questions/1261189/mysql-count-entries-without-grouping
hope this helps.