Summarizing Distinct groupings

Getting your data onto paper - or the web - Discussing the reports features of Base

Summarizing Distinct groupings

Postby One Big Yawn » Tue Aug 07, 2012 11:26 pm

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!
LibreOffice 3.5, MySQL 5.5, Windows 7
One Big Yawn
 
Posts: 24
Joined: Sat Jul 14, 2012 6:09 am

Re: Summarizing Distinct groupings

Postby r4zoli » Sat Sep 22, 2012 1:25 pm

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.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary


Return to Reporting

Who is online

Users browsing this forum: No registered users and 3 guests