Group whole column into one field in report

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
oahihz
Posts: 12
Joined: Thu Mar 24, 2011 9:11 am

Group whole column into one field in report

Post by oahihz »

Hi guys,

Let's say, for example, I run a fast-food chain, and I have a database on all my employees as well as the branches they work in around the country.
What I would like the report to show is the branch id and name as the title, followed by the entire list of employees there.
My table in the database consists of every employee working under the company, therefore, I had to create a query that pulls out a list of employees by their branch.

My query would have the columns:
Employee ID | First Name | Last Name | Branch ID | Branch

I used the report wizard and ended up with a list. Is there anyway I could group the columns of "Branch ID" as well as "Branch" and put it as one field in my heading, since the values of these 2 columns would be the same for every entry.

Hopefully you can understand my intentions.
OpenOffice.org 3.3
Windows XP
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Group whole column into one field in report

Post by r4zoli »

Use oracle report builder when you can use grouping, which will solve your problem.
http://extensions.services.openoffice.o ... portdesign

Unfortunatelly the extension site is down, you can not download report builder, now.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
oahihz
Posts: 12
Joined: Thu Mar 24, 2011 9:11 am

Re: Group whole column into one field in report

Post by oahihz »

Is there a way to do it without oracle report builder? I have some software security issues at my workstation.
OpenOffice.org 3.3
Windows XP
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Group whole column into one field in report

Post by r4zoli »

Use Calc, and query as data source.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Post Reply