How to get a total on a column in a Report

[Billyray]

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.

[Sliderule]

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.

Sliderule

Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved.

[cazbym]

Hi

Link seems to take me to the wrong page. Unless a requirement is the 7 day free trial account sign up?

[Sliderule]

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'

Sliderule