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.
Group whole column into one field in report
Group whole column into one field in report
OpenOffice.org 3.3
Windows XP
Windows XP
Re: Group whole column into one field in report
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.
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
Hungarian forum co-admin
Re: Group whole column into one field in report
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
Windows XP
Re: Group whole column into one field in report
Use Calc, and query as data source.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin