OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to get a total on a column in a Report

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
Billyray
OOo Enthusiast
OOo Enthusiast


Joined: 06 Mar 2007
Posts: 144
Location: Lake Erie's Shore in Ohio

PostPosted: Thu Apr 12, 2012 4:56 am    Post subject: How to get a total on a column in a Report Reply with quote

I have a report, created by the wizard in Base:

It is a detail list type of report which has Quantity and Price columns. At the end of the report I need to have Totals for those two columns: Total Quantiy and Total of Price.

I don't know too much about reports in Base. Do I use controls like in Forms?

Any help much appreciated!
_________________
Billyray
using:
Linux distro: Ubuntu 10.04 LTS, Lucid Lynx, OOo Base 3.3, connected to MySql database using Java jdbc (note: ONLY sun-java-6-1.6.0_22 jre works right), and converted from MS Access 2003.
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Fri Apr 13, 2012 8:22 am    Post subject: Reply with quote

I would suggest you download the OpenOffice Extension . . . currently named: Oracle Report Builder.

It can be downloaded from ( Get It! button ):

http://extensions.services.openoffice.org/en/project/reportdesign

Below is a link, showing an EXAMPLE database ( HSQL-WORLDAREA2.odb ) that you can download and review, with some reports with a few Report Functions . . . that performs exactly what you said you want. It can be downloaded from:

http://www.filedropper.com/hsql-worldarea2

Check out reports:
  1. WoldAreaReport - By Area
  2. WoldAreaReport - By Continent - Area
  3. WoldAreaReport - By Continent - Country Name
I hope this helps, please be sure to let me / us know. Just as an FYI, since you are using MySQL as your database engine, it makes no difference. Smile

Sliderule

Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved.
Back to top
View user's profile Send private message
cazbym
Power User
Power User


Joined: 16 Mar 2009
Posts: 63

PostPosted: Sun Apr 22, 2012 11:47 am    Post subject: Reply with quote

Hi

Link seems to take me to the wrong page. Unless a requirement is the 7 day free trial account sign up?
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Sun Apr 22, 2012 12:29 pm    Post subject: Reply with quote

Use following link, do download the SAMPLE OpenOffice Base file:

http://www.mediafire.com/?84zdq6az0qf7jd5

I do NOT know how long that file will be available for download, but, it is available 'today' Smile

Sliderule
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group