Summarizing Distinct groupings

[One Big Yawn]

I am trying to provide a summary of all the groups in a report in the report header, as this may change from report to report. In SQL, this would be something like:

Code: Select all

SELECT DISTINCT groupname FROM Report

How can I get something like this in Base?

Thank you!

[r4zoli]

In case of report builder is not possible, if your report based on tables.
The grouping created later than the report heading.

Only way if you use query as data source and group name created by SQL commands which can be used in report heading.