Page 1 of 1

Summarizing Distinct groupings

PostPosted: Tue Aug 07, 2012 11:26 pm
by 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   Expand viewCollapse view
SELECT DISTINCT groupname FROM Report


How can I get something like this in Base?

Thank you!

Re: Summarizing Distinct groupings

PostPosted: Sat Sep 22, 2012 1:25 pm
by 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.