From 6192b00a59c9a10fe59eef50f6eb7d25fb3813a3 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Fri, 21 Jan 2022 14:54:26 -0300 Subject: Refactor and update Report design (main) Change-Id: I2e8b809ec57f97bf96aa27d26f3a597ae48e795e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128743 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/sdatabase/rep_main.xhp | 120 ++++++++++++++++++++++++++----------- 1 file changed, 84 insertions(+), 36 deletions(-) diff --git a/source/text/sdatabase/rep_main.xhp b/source/text/sdatabase/rep_main.xhp index f69c6b5898..f020f67c63 100644 --- a/source/text/sdatabase/rep_main.xhp +++ b/source/text/sdatabase/rep_main.xhp @@ -33,33 +33,33 @@

Report Builder

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. - To use the Report Builder, the Report Builder component must be installed. In addition, the Java Runtime Environment (JRE) software must be installed, and this software must be selected in %PRODUCTNAME. + To use the Report Builder, the Java Runtime Environment (JRE) software must be installed, and this software must be selected in %PRODUCTNAME.

To install the JRE software

The Report Builder requires an installed Java Runtime Environment (JRE). - Choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME - Advanced. + Choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME - Advanced. - Wait up to one minute, while %PRODUCTNAME collects information on installed Java software on your system. - If a recent JRE version is found on your system, you see an entry in the list. + Wait up to one minute, while %PRODUCTNAME collects information on installed Java software on your system. + If a recent JRE version is found on your system, you see an entry in the list. - Click the option button in front of the entry to enable this JRE version for use in %PRODUCTNAME. + Click the option button in front of the entry to enable this JRE version for use in %PRODUCTNAME. - Ensure that Use a Java runtime environment is enabled. + 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 %PRODUCTNAME and open %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME - Advanced again.

To open the Report Builder

- Open a Base file or create a new database. The database must contain at least one table with at least one data field and a primary key field. + Open a Base file or create a new database. The database must contain at least one table with at least one data field and a primary key field. - Click the Reports icon in the Base window, then choose Create Report in Design View. - The Report Builder window opens. + Click the Reports icon in the Base window, then choose Create Report in Design View. + The Report Builder window opens. The Report Builder is divided into three parts. On the top you see the menu, with the toolbars below. @@ -67,15 +67,15 @@ 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: - + Page Header - drag control fields with fixed text into the Page Header area - + Detail - drag and drop database fields into the Detail area - + Page Footer - drag control fields with fixed text into the Page Footer area @@ -86,16 +86,16 @@

To connect the report to a database table

- Move the mouse to the Properties view. You see two tab pages General and Data. + Move the mouse to the Properties view. You see two tab pages General and Data. - On the Data tab page, click Content to open the combo box. + On the Data tab page, click Content to open the combo box. - Select the table for that you want to create the report. + Select the table for that you want to create the report. - After selecting the table, press the Tab key to leave the Content box. + 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. @@ -129,12 +129,21 @@ Shrinks the selected section to remove bottom empty space. After inserting fields in the Detail view, the report is ready for execution.

To execute a report

- - - Click the Execute Report icon -Icon on the toolbar. - - + Click the Execute Report icon on the toolbar. +
+ + + + + Execute Report icon + + + + Execute Report icon + + +
+
A Writer document opens and shows the report you have created, which contains all values of the database table which you have insert. If the database contents did change, execute the report again to update the result report.automatic? message?

To edit a report

@@ -143,47 +152,86 @@ If you want to edit the Report Builder view, you can change some of its properties. Click in the Details area. Then in the Properties window, change some properties, for example the background color. After finishing, click the Execute Report icon -Icon to create a new report. + to create a new report. + If you close the Report Builder, you will be asked if the report should be saved. Click Yes, give the report a name, and click OK.report part of Base file?

Sorting the report

Without sorting or grouping, the records will be inserted into the report in the order in which they are retrieved from the database. - Open the Report Builder view and click the Sorting and Grouping icon -Icon on the toolbar. You see the Sorting and Grouping dialog. + 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 Gouping + + + + Icon Sort and Gouping + + +
+ - In the Groups box, click the field which you want as the first sort field, and set the Sorting property.what meaning has the order of fields / move up down button? + In the Groups box, click the field which you want as the first sort field, and set the Sorting property.what meaning has the order of fields / move up down button? - Execute the report. + Execute the report.

Grouping

- Open the Report Builder view and click the Sorting and Grouping icon -Icon on the toolbar. You see the Sorting and Grouping dialog. + Open the Report Builder view and click the Sorting and Grouping icon on the toolbar. You see the Sorting and Grouping dialog. - In the Groups box, open the Group Header list box and select to show a group header. + In the Groups box, open the Group Header list box and select to show a group header. - Click the Add Field icon -Icon to open the Add Field window. + Click the Add Field icon to open the Add Field window. + + + + + + Icon Add Field + + + + Icon Add Field + + +
+ + - 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. + 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. - Execute the report. The report shows the grouped records. + 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 -Icon and double-click your last saved report. A new Writer document will be created which shows the new 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. -- cgit