Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

OpenOffice 3.x Getting Started Guide
Previous Page Home Next Page

Creating a dynamic report

We will create a report with some statistics on our fuel consumption. To do this, we have to modify two queries: End-Reading and Fuel Economy. We will be adding the FuelCost field to the End-Reading query. Then we will add the FuelCost field from the End-Reading query to the Fuel Economy query.

Image:Tip.pngWhen opening a query to edit it, it might appear as below. If you move your cursor over the black line (circled in red), it becomes a double headed arrow. Drag and drop it to a lower position.
Appearance of query when opened for editing.
  1. Add the FuelCost field to the End-Reading query:
    1. In the Fuel table list, double-click to add FuelCost to the bottom table.
    2. Save and close the query.
    3. Adding an additional field to the query.
  2. Right-click the End-Reading query and select Edit from the context menu.
  3. Add the FuelCost field from the End-Reading query to the Fuel Economy query.
    1. Right-click the Fuel Economy query and select Edit from the context menu.
    2. Double-click the FuelCost field in the End-Reading query list to the table at the bottom.
  4. Add a calculation field to the right of the FuelCost field.
    1. Type the following in the Field cell:
      "End-Reading".FuelCost/("End-Reading".Odometer - Fuel.Odometer)
    2. Type the following in the Alias cell:
      cost per mile
    Image:documentation_note.pngIf you use the metric system, cost per km is the appropriate alias.
  5. Save and close the query.
  6. Open a new report.
    Right-click the Fuel Economy query and select Report Wizard.
  7. Select fields.
    Move all the fields from the Available fields to the Fields in report list. Use the >> to do so. Click Next.
  8. Label fields.
    Change FuelCost to Fuel Cost by placing a space between the words. Click Next.
  9. Group fields.
    Use > to move the Date field to the Groupings list. Click Next.
  10. Sort options: the wizard skipped this one.
  11. Choose layout.
    Accept the default. Click Next.
  12. Create the report.
    1. Change the report name to Fuel Statistics.
    2. The default setting is Dynamic report, so no change is necessary.
    3. Select Modify report layout. Click Finish.

Top of page


OpenOffice 3.x Getting Started Guide
Previous Page Home Next Page

 
 
  Published under the terms of the Creative Commons License Design by Interspire