Txosten-eraikitzailea

The Report Builder is a tool to create your own database reports. Unlike with the Report Wizard, using the Report Builder you can take control to design the report the way you want. The generated report is a Writer document that you can edit, too.

note

Txosten-eraikitzailea erabiltzeko, Java Runtime Environment (JRE) softwarea instalatuta eduki behar da eta LibreOfficen hautatuta egon behar du.


JRE softwarea instalatzeko

Txosten-eraikitzailea erabiltzeko Java Runtime Environment (JRE) instalatuta eduki behar da.

  1. Aukeratu - LibreOffice - Aurreratua.

  2. Itxaron minutu bat LibreOffice aplikazioak zure sisteman instalatuta dagoen Java softwareari buruzko informazioa biltzen duen bitartean.

    If a recent JRE version is found on your system, you see an entry in the list.

  3. Click the option button in front of the entry to enable this JRE version for use in LibreOffice.

  4. Ensure that Use a Java runtime environment is enabled.

If no JRE version is found on your system, open your web browser and download the JRE software from http://www.java.com. Install the JRE software. Then restart LibreOffice and open - LibreOffice - Advanced again.

To open the Report Builder

  1. Ireki Base fitxategi bat edo sortu datu-base berria. Datu-baseak gutxienez taula bat eduki behar du, gutxienez datu-eremu batekin eta gako nagusia duen eremu batekin.

  2. Click the Reports icon in the Base window, then choose Create Report in Design View.

    Txosten-eraikitzailearen leihoa irekitzen da.

Txosten-eraikitzailea hiru zatitan banatuta dago. Goian menua dauka eta azpian tresna-barrak.

On the right you see the Properties window with the property values of the currently selected object.

The left part of the Report Builder window shows the Report Builder view. The Report Builder view is initially divided into three sections, from top to bottom:

  1. Page Header - drag control fields with fixed text into the Page Header area

  2. Detail - drag and drop database fields into the Detail area

  3. Page Footer - drag control fields with fixed text into the Page Footer area

To insert an additional Report Header and Report Footer area choose Edit - Insert Report Header/Footer. These areas contain text that appears at the start and end of the whole report.

Click the "-" icon in front of an area name to collapse that area to one line in the Report Builder view. The "-" icon changes to a "+" icon, and you can click this to expand the area again.

You insert database fields by drag-and-drop into the Detail area. See the section "To insert fields into the report" below.

In addition, you can click the Label Field or Text Box icon in the toolbar, then drag a rectangle in the Page Header or Page Footer area, to define a text that is the same on all pages. You enter the text in the Label box of the corresponding Properties window. You can also add graphics by using the Graphics icon.

To connect the report to a database table

  1. Move the mouse to the Properties view. You see two tab pages General and Data.

  2. On the Data tab page, click Content to open the combo box.

  3. Select the table for that you want to create the report.

  4. After selecting the table, press the Tab key to leave the Content box.

The Add fields to report window opens automatically and shows all fields of the selected table.

Add fields to report

The Add Field window helps you to insert the table entries in the report.

After inserting fields in the Detail view, the report is ready for execution.

To execute a report

Click the Execute Report icon on the toolbar.

Execute Report icon

'Exekutatu txostena' ikonoa

Writer dokumentu bat irekiko da sortu berri den dokumentua erakusteko. Datu-basetik txertatu den taularen balio guztiak izango ditu.

Datu-basearen edukiak aldatu badira, exekutatu txostena berriro emaitza eguneratzeko.

Txosten bat editatzeko

Hasteko, erabaki sortutako txostena (Writer dokumentu bat dena) editatu nahi duzun ala txosten-eraikitzailearen ikuspegia editatu eta diseinu berritik abiatuta txosten berria sortu nahi duzun.

The Writer document is opened read-only. To edit the Writer document, click Edit Document on the information bar, or choose Edit - Edit Mode.

Txosten-eraikitzailearen ikuspegia editatu nahi baduzu, bere propietateetako batzuk aldatu ditzakezu.

Click in the Details area. Then in the Properties window, change some properties, for example the background color.

Amaitu ondoren, egin klik 'Exekutatu txostena' ikonoan txosten berria sortzeko.

Execute Report icon

'Exekutatu txostena' ikonoa

Txosten-eraikitzailea ixten denean, txostena gordeko den ala ez galdetuko da. Egin klik 'Bai' aukeran, eman izen bat txostenari eta sakatu 'Ados'.

Txostena ordenatzea

Without sorting or grouping, the records will be inserted into the report in the order in which they are retrieved from the database.

  1. Open the Report Builder view and click the Sorting and Grouping icon on the toolbar. You see the Sorting and Grouping dialog.

Icon Sort and Grouping

Icon Sort and Grouping

  1. In the Groups box, click the field which you want as the first sort field, and set the Sorting property.

  2. Execute the report.

Grouping

  1. Open the Report Builder view and click the Sorting and Grouping icon on the toolbar. You see the Sorting and Grouping dialog.

  2. In the Groups box, open the Group Header list box and select to show a group header.

  3. Click the Add Field icon to open the Add Field window.

Icon Add Field

Icon Add Field

  1. Drag-and-drop the field entry that you want to group into the group header section. Then drag-and-drop the remaining fields into the Detail section.

  2. Execute the report. The report shows the grouped records.

If you like to sort and group, open the Report Builder view, then open the Sorting and Grouping dialog. Select to show a Group Header for the fields that you want to group, and select to hide the Group Header for the fields that you want to be sorted. Close the Sorting and Grouping window and execute the report.

Updating and printing your data

When you insert some new data or edit data in the table, a new report will show the updated data.

Click the Reports icon and double-click your last saved report. A new Writer document will be created which shows the new data.

Icon Reports

Icon Reports

To print a report, choose File - Print from the Writer document.