From 4eecbf9045ed866b0d716a45046f89b472dd3835 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Fri, 21 Jan 2022 13:45:51 -0300 Subject: Refactor database Help files Change-Id: I8f8c96bf9cc9c401c38e3cc92f4c3b274b3f15e8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128740 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- .../text/shared/explorer/database/rep_datetime.xhp | 48 ------ .../shared/explorer/database/rep_insertfield.xhp | 91 ---------- source/text/shared/explorer/database/rep_main.xhp | 189 --------------------- .../shared/explorer/database/rep_navigator.xhp | 75 -------- .../shared/explorer/database/rep_pagenumbers.xhp | 57 ------- source/text/shared/explorer/database/rep_prop.xhp | 86 ---------- source/text/shared/explorer/database/rep_sort.xhp | 89 ---------- source/text/shared/guide/data_report.xhp | 2 +- source/text/shared/guide/data_reports.xhp | 2 +- 9 files changed, 2 insertions(+), 637 deletions(-) delete mode 100644 source/text/shared/explorer/database/rep_datetime.xhp delete mode 100644 source/text/shared/explorer/database/rep_insertfield.xhp delete mode 100644 source/text/shared/explorer/database/rep_main.xhp delete mode 100644 source/text/shared/explorer/database/rep_navigator.xhp delete mode 100644 source/text/shared/explorer/database/rep_pagenumbers.xhp delete mode 100644 source/text/shared/explorer/database/rep_prop.xhp delete mode 100644 source/text/shared/explorer/database/rep_sort.xhp (limited to 'source/text/shared') diff --git a/source/text/shared/explorer/database/rep_datetime.xhp b/source/text/shared/explorer/database/rep_datetime.xhp deleted file mode 100644 index d45f7fe46d..0000000000 --- a/source/text/shared/explorer/database/rep_datetime.xhp +++ /dev/null @@ -1,48 +0,0 @@ - - - - - - - - - - -Date and Time -/text/shared/explorer/database/rep_datetime.xhp - - - - - - -Date and Time - -You can open the Date and Time dialog of the Report Builder by choosing Insert - Date and Time. -Press Shift-F1 and point with the mouse at an input box to see a help text for this input box. -Enable Include Date to insert a date field into the active area of the report. The date field displays the current date when the report is executed. - -Select a format to display the date. -Enable Include Time to insert a time field into the active area of the report. The time field displays the current time when the report is executed. - -Select a format to display the time. -Click OK to insert the field. -You can click the date or time field and drag to another position within the same area, or edit the properties in the Properties window. - - diff --git a/source/text/shared/explorer/database/rep_insertfield.xhp b/source/text/shared/explorer/database/rep_insertfield.xhp deleted file mode 100644 index 6080bfd83a..0000000000 --- a/source/text/shared/explorer/database/rep_insertfield.xhp +++ /dev/null @@ -1,91 +0,0 @@ - - - - - - - Insert Fields - /text/shared/explorer/database/rep_insertfield.xhp - - - -

- - - insert fields;in report design - add fields;in report design - report design;add fields to report - - Add fields to report - The Add Field window helps you to insert the table entries in the report. -

- The Add Field window is shown automatically when you have selected a table in the Contents box and leave that box. - Choose View - Add Field. - - - - -

Add field icon - - - - Click the Add Field icon on the toolbar. - - -

- - - Select the field in the Add Field dialog and click Insert. You can select multiple fields pressing the CommandCtrl key while clicking on the fields name or using the Shift key while pressing the mouse button. Click Insert in the toolbar to add the fields to the report. - - - Drag and drop the field names one by one from the Add Field window into the Detail area of the report. Position the fields as you like. Use the icons in the toolbars to align the fields. - It is not possible to overlap the fields. If you drop a table field on the Detail area, then a label and a text box are inserted. - - - You can also insert text that should be the same on every page of the report. Click the Label Field icon

Icon, then drag a rectangle in the Page Header or Page Footer area. Edit the Label property to show the text you want. - - - Sorting fields names - - - - -

Sort Ascending icon - - - - Sort names ascending. - - - - - -

Sort descending icon - - - - Sort names descending, - - - - - -

Undo sorting icon - - - - Restore original sorting - - -

- - diff --git a/source/text/shared/explorer/database/rep_main.xhp b/source/text/shared/explorer/database/rep_main.xhp deleted file mode 100644 index 04362579f1..0000000000 --- a/source/text/shared/explorer/database/rep_main.xhp +++ /dev/null @@ -1,189 +0,0 @@ - - - - - - - Report Builder - /text/shared/explorer/database/rep_main.xhp - - - - - - Report Builder - Oracle Report Builder - - 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 install the JRE software - The Report Builder requires an installed Java Runtime Environment (JRE). - - - 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. - - - 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. - - - 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. - - - 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. - 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: - - - - 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 - - - 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.id="par_id2685323" If you want a multi-column report, choose Format - Page, click the Columns tab, and set the number of columns. Now you can also specify a Column Header and Column Footer in the Report Builder view.column header/footer -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 - - - 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. - - - Select the table for that you want to create the report. - - - 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. -

- Align at Section toolbar - -Select two or more objects and click this icon to align the objects at the left margin of the area. - -Select two or more objects and click this icon to align the objects at the right margin of the area. - -Select two or more objects and click this icon to align the objects at the top margin of the area. - -Select two or more objects and click this icon to align the objects at the bottom margin of the area.Object Resizing toolbar - -Select two or more objects and click this icon to resize the objects to the smallest width. - -Select two or more objects and click this icon to resize the objects to the smallest height. - -Select two or more objects and click this icon to resize the objects to the greatest width. - -Select two or more objects and click this icon to resize the objects to the greatest height.Report Controls toolbar - -Inserts a horizontal line to the current area. - -Inserts a vertical line to the current area.Shrink toolbar - -Shrinks the selected section to remove top and bottom empty space. - -Shrinks the selected section to remove top empty space. - -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. - - - 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 - First decide if you want to edit the generated report, which is a static Writer document, or if you want to edit the Report Builder view and then generate a new report based on the new design. - The Writer document is opened read-only. To edit the Writer document, click Edit Document on the information bar, or choose Edit - Edit Mode.saved automatically with the Base file? - 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. - 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. - - - 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. - - - Grouping - - - Open the Report Builder view and click the Sorting and Grouping icon -

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. - - - Click the Add Field icon -

Icon to open the Add Field window. - - - 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. - - - 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. - To print a report, choose File - Print from the Writer document. - - diff --git a/source/text/shared/explorer/database/rep_navigator.xhp b/source/text/shared/explorer/database/rep_navigator.xhp deleted file mode 100644 index 4a17ed8b8f..0000000000 --- a/source/text/shared/explorer/database/rep_navigator.xhp +++ /dev/null @@ -1,75 +0,0 @@ - - - - - - - - - - -Report Navigator -/text/shared/explorer/database/rep_navigator.xhp - - - -formulas in reports;editing -functions in reports;editing - -Report Navigator - -You can open the Report Navigator window of the Report Builder by choosing View - Report Navigator. -The Report Navigator reveals the structure of the report. You can use the Report Navigator to insert functions into the report. -Click an entry in the Report Navigator. The corresponding object or area is selected in the Report Builder view. Right-click an entry to open the context menu. -To enter functions to the report -In the context menu of the Report Navigator, you see the same commands as in the Report Builder view, plus additional commands to create new functions or to delete them. -Functions can be entered using a syntax as specified by the OpenFormula proposal. -See Wiki page about Base for some more help regarding the functions in a report. -To calculate a sum for each clientcopied from a mail by Ocke - did not test - - -Open the Report Navigator. - - -Open the Groups entry and the group where you want to calculate the cost. -The group has a sub entry called functions. - - -Open the context menu (right click) on the functions entry, choose to create a new function, and select it. -In the property browser you see the function. - - -Change the name to e.g. CostCalc and the formula to [CostCalc] + [enter your cost column name]. - - -In the initial value enter 0. - - -Now you can insert a text field and bind it to your [CostCalc] (appears in the data field list box). - - -Maybe you have to set the initial value to the value of the field like [field].these 3 paras copied from another mail by Ocke in users@dba.o.o -If there are blank fields in the cost column, use the following formula to replace the blank fields' content with zero: -[SumCost] + IF(ISBLANK([field]);0;[field])need some real working examples. See i81874Formula -Enter the formula that defines the function. Use OpenFormula syntax.Initial value -Enter the initial value for the evaluation of the formula. Often this is set to 0 or to 1.Deep traversing -If Deep traversing is enabled, functions are evaluated considering all lower levels of hierarchy. This would be used for instance for line numbering. If Deep traversing is not enabled, only the first level of hierarchy is evaluated.Pre evaluation -If Pre evaluation is enabled, functions are evaluated only when the report is finished. - - diff --git a/source/text/shared/explorer/database/rep_pagenumbers.xhp b/source/text/shared/explorer/database/rep_pagenumbers.xhp deleted file mode 100644 index c0617b1a16..0000000000 --- a/source/text/shared/explorer/database/rep_pagenumbers.xhp +++ /dev/null @@ -1,57 +0,0 @@ - - - - - - - - - - -Page Numbers -/text/shared/explorer/database/rep_pagenumbers.xhp - - - - - -Page Numbers - -You can open the Page Numbers dialog of the Report Builder by choosing Insert - Page Numbers. -Press Shift-F1 and point with the mouse at an input box to see a help text for this input box. -Page N -Page N of M -Top of Page (Header) -Bottom of Page (Footer) -Alignment - - -Select the format for the page numbers, either "Page N" or "Page N of M", where N stands for the current page number, and M for the total number of pages in the report. - - -Select to show the page numbers in the Page Header area or in the Page Footer area. - - -Select an alignment. By default the page numbers are centered between the left and right margins. You can align the field to the left or right. You can also select Inside to print page number on odd pages on the left side and even page numbers on the right side. Select Outside for the opposite alignment. - - -When you click OK, a data field for the page numbers is inserted. If no header or footer area exist, the area will be created as needed. -You can click the data field and drag to another position within the same area, or edit the properties in the Properties window. - - diff --git a/source/text/shared/explorer/database/rep_prop.xhp b/source/text/shared/explorer/database/rep_prop.xhp deleted file mode 100644 index 4817a595bb..0000000000 --- a/source/text/shared/explorer/database/rep_prop.xhp +++ /dev/null @@ -1,86 +0,0 @@ - - - - - - - Properties - /text/shared/explorer/database/rep_prop.xhp - - - - -

Properties

- The Properties window of the Report Builder always shows the properties of the currently selected object in the Report Builder view. - Press Shift-F1 and point with the mouse at an input box to see a help text for this input box. - On first start of the Report Builder, the Properties window shows the Data tab page for the whole report. - Select a table from the Contents list, then press Tab or click outside the input box to leave the input box. - The Add fields to report window is shown automatically when you have selected a table in the Contents box and leave that box. You can also click the Add Field icon on the toolbar, or choose View - Add Field. - The General tab page can be used to change the name of the report, and to disable the Page Header or Page Footer areas, among others. - - To display the Data or General tab page for the whole report, choose Edit - Select All - Select Report. - - Groups are kept together by page or by column (default). You must enable Keep Together also.Page header - - Specifies in which context the page header will be printed: on all pages, or not on pages with a report header or footer.Page footer - - Specifies in which context the page footer will be printed: on all pages, or not on pages with a report header or footerPrint repeated values - - Specifies to print repeated values. - If you click the Page Header or Page Footer area without selecting any object, you see the General tab page for that area. - You can edit some visual properties for the area.screen only or also in report?Background color - - Sets the background color for the selected object, both on screen and for printing.Visible - - An invisible object is not shown in the executed report. It is still visible in the Report Builder view.Height - - Defines the height of the selected object.Conditional Print Expression - - If the Conditional Print Expression evaluates to TRUE, the selected object will be printed.id="par_id2386852" Conditions use the following form:Background transparent - - Specifies whether the background of the selected object is transparent or opaque.just guessing - If you click the Detail area without selecting any object, you see the General tab page for that area. - You can specify some properties to fine-tune the way the records are printed.Force New Page - - Force New Page specifies whether the current section and/or the next section is printed on a new page.New Row Or Column - - New Row Or Column specifies, for a multi-column design, whether the current section and/or the next section will be printed on a new row or column.Keep together - - Keep Together specifies to print the current object starting on top of a new page if it doesn't fit on the current page. - Insert some data fields into the Detail area, or insert other control fields into any area. When you select an inserted field, you can set the properties in the Properties window. - For a Label field, you can change the displayed text in the Label input box. - - For a picture, you can specify to either insert the picture as a link to a file or only as an embedded object in the Base file. The embedded option increases the size of the Base file, while the link option is not as portable to other computers.Position x - - Set the X Position for the selected objectx in pixel or twips? or current measurement units? from origin as on ruler? from elsewhere?Position y - - Set the Y Position for the selected objectWidth - - Sets the width of the selected object.Font - - Select the font for the selected text object.Print when group change - - Print when group changeVert. Alignment - - Vert. Alignment - On the General tab page of a data field, you can set the Formatting properties, among others. - - On the Data tab page, you can change the data contents to be shown. - - diff --git a/source/text/shared/explorer/database/rep_sort.xhp b/source/text/shared/explorer/database/rep_sort.xhp deleted file mode 100644 index 149c5ad38e..0000000000 --- a/source/text/shared/explorer/database/rep_sort.xhp +++ /dev/null @@ -1,89 +0,0 @@ - - - - - - - - - Sorting and Grouping - /text/shared/explorer/database/rep_sort.xhp - - - -

- - - -Sorting and Grouping - - In the Sorting and Grouping dialog of Report Builder, you can define the fields that should be sorted in your report, and the fields that should be kept together to form a group. If you group your report by a certain field, all records with the same value of that field will be kept together in one group. -

- The Groups box shows the fields in an order from top to bottom. You can select any field, then click the Move Up or Move Down button to move this field up or down in the list. - The sorting and grouping will be applied in the order of the list from top to bottom. - -Lists the fields that will be used for sorting or grouping. The field at the top has the highest priority, the second field has the second priority, and so on. - -Click to open a list from which you can select a field. - - -Moves the selected field up in the list. - - -Moves the selected field down in the list. - -Select the sorting order. - -Select to show or hide the Group Header. - -Select to show or hide the Group Footer. - -Select to create a new group on each changed value, or on other properties. - -Removes the selected field from the list. - By default a new group is created on every changed value of a record from the selected field. You can change this property depending on the type of field: - - - For fields of type Text, you can select Prefix Characters and enter a number n of characters in the text box below. The records which are identical in the first n characters will be grouped together. - - - For fields of type Date/Time, you can group the records by the same year, quarter, month, week, day, hour, or minute. You can additionally specify an interval for weeks and hours: 2 weeks groups data in biweekly groups, 12 hours groups data in half-day groups. - - - For fields of type AutoNumber, Currency, or Number, you specify an interval.how? - - - -Enter the group interval value that records are grouped by. - -Select the level of detail by which a group is kept together on the same page. - When you specify to keep together some records on the same page, you have three choices: - - - No - page boundaries are not taken into account. - - - Whole Group - prints the group header, detail section, and group footer on the same page. - - - With First Detail - prints the group header on a page only if the first detail record also can be printed on the same page. - - - - diff --git a/source/text/shared/guide/data_report.xhp b/source/text/shared/guide/data_report.xhp index 9c214e430f..91389473c0 100644 --- a/source/text/shared/guide/data_report.xhp +++ b/source/text/shared/guide/data_report.xhp @@ -61,7 +61,7 @@ The Report Builder window opens with the report's information loaded. -Use the toolbars and menu commands and drag-and-drop to edit the report as stated in the Report Builder guide. +Use the toolbars and menu commands and drag-and-drop to edit the report as stated in the Report Builder guide. Execute the report to see the resulting report document. Editing a Report Created by the Report Wizard diff --git a/source/text/shared/guide/data_reports.xhp b/source/text/shared/guide/data_reports.xhp index 992c6725b6..92dd0b9ce7 100644 --- a/source/text/shared/guide/data_reports.xhp +++ b/source/text/shared/guide/data_reports.xhp @@ -115,7 +115,7 @@ Click Create Report in Design View. -Follow the instructions in the Report Builder guide. +Follow the instructions in the Report Builder guide. Creating a New Report With the Report Wizard -- cgit