diff options
Diffstat (limited to 'source/text/shared')
| -rw-r--r-- | source/text/shared/explorer/database/rep_datetime.xhp | 48 | ||||
| -rw-r--r-- | source/text/shared/explorer/database/rep_insertfield.xhp | 91 | ||||
| -rw-r--r-- | source/text/shared/explorer/database/rep_main.xhp | 189 | ||||
| -rw-r--r-- | source/text/shared/explorer/database/rep_navigator.xhp | 75 | ||||
| -rw-r--r-- | source/text/shared/explorer/database/rep_pagenumbers.xhp | 57 | ||||
| -rw-r--r-- | source/text/shared/explorer/database/rep_prop.xhp | 86 | ||||
| -rw-r--r-- | source/text/shared/explorer/database/rep_sort.xhp | 89 | ||||
| -rw-r--r-- | source/text/shared/guide/data_report.xhp | 2 | ||||
| -rw-r--r-- | source/text/shared/guide/data_reports.xhp | 2 |
9 files changed, 2 insertions, 637 deletions
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 @@ -<?xml version="1.0" encoding="UTF-8"?> - - - -<!-- - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - --> - - - <helpdocument version="1.0"> -<meta> -<topic id="textsharedexplorerdatabaserep_datetimexml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Date and Time</title> -<filename>/text/shared/explorer/database/rep_datetime.xhp</filename> -</topic> -</meta> -<body> -<bookmark xml-lang="en-US" branch="hid/.uno:InsertDateTimeField" id="bm_id6520584" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/datetimedialog/DateTimeDialog" id="bm_id6520585" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/datetimedialog/@@nowidget@@" id="bm_id6520585" localize="false"/> -<paragraph role="heading" id="hd_id2320932" xml-lang="en-US" level="1"><variable id="rep_datetime"><link href="text/shared/explorer/database/rep_datetime.xhp">Date and Time</link> -</variable></paragraph> -<paragraph role="paragraph" id="par_id8638874" xml-lang="en-US"><ahelp hid=".">You can open the Date and Time dialog of the <link href="text/shared/explorer/database/rep_main.xhp">Report Builder</link> by choosing <item type="menuitem">Insert - Date and Time</item>.</ahelp></paragraph> -<paragraph role="tip" id="par_id6278878" xml-lang="en-US">Press <item type="keycode">Shift-F1</item> and point with the mouse at an input box to see a help text for this input box.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/datetimedialog/date" id="bm_id5607470" localize="false"/><paragraph role="paragraph" id="par_id393078" xml-lang="en-US"><ahelp hid=".">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.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/datetimedialog/datelistbox" id="bm_id5607471" localize="false"/> -<paragraph role="paragraph" id="par_id1271401" xml-lang="en-US"><ahelp hid="." visibility="hidden">Select a format to display the date.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/datetimedialog/time" id="bm_id6481215" localize="false"/><paragraph role="paragraph" id="par_id8718832" xml-lang="en-US"><ahelp hid=".">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.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/datetimedialog/timelistbox" id="bm_id6481216" localize="false"/> -<paragraph role="paragraph" id="par_id8561052" xml-lang="en-US"><ahelp hid="." visibility="hidden">Select a format to display the time.</ahelp></paragraph> -<paragraph role="paragraph" id="par_id5992919" xml-lang="en-US">Click OK to insert the field.</paragraph> -<paragraph role="paragraph" id="par_id4320810" xml-lang="en-US">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.</paragraph> -</body> -</helpdocument> 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 @@ -<?xml version="1.0" encoding="UTF-8"?> -<helpdocument version="1.0"> - <!-- - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - --> - - <meta> - <topic id="ReportInsertField" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">Insert Fields</title> - <filename>/text/shared/explorer/database/rep_insertfield.xhp</filename> - </topic> - </meta> - <body> - <section id="insertfieldstitle"> - <bookmark id="bm_id391540562942431" xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_FIELD_SEL" localize="false"/> - <bookmark xml-lang="en-US" branch="index" id="bm_id61540566967968"> - <bookmark_value>insert fields;in report design</bookmark_value> - <bookmark_value>add fields;in report design</bookmark_value> - <bookmark_value>report design;add fields to report</bookmark_value> - </bookmark> - <paragraph id="hd_id361540562942432" role="heading" level="1" xml-lang="en-US"><variable id="addfields"><link href="text/shared/explorer/database/rep_insertfield.xhp" name="Add Fields">Add fields to report</link></variable></paragraph> - <paragraph id="par_id3587145" role="paragraph" xml-lang="en-US"><ahelp hid=".">The Add Field window helps you to insert the table entries in the report.</ahelp></paragraph> - </section> - <section id="howtoget"> - <paragraph xml-lang="en-US" id="par_id4503921" role="paragraph">The Add Field window is shown automatically when you have selected a table in the Contents box and leave that box.</paragraph> - <paragraph role="paragraph" id="par_id171540674707522" xml-lang="en-US">Choose <item type="menuitem">View - Add Field</item>.</paragraph> - <table id="tab_id721540674874655"> - <tablerow> - <tablecell> - <paragraph role="paragraph" id="par_id991540674901837" xml-lang="en-US"> - <image src="media/icon-themes/cmd/lc_addfield.svg" id="img_id621540674901837" width="1.0cm" height="1.0cm"><alt xml-lang="en-US" id="alt_id491540674901837">Add field icon</alt></image> - </paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id121540674874655" role="paragraph" xml-lang="en-US" >Click the Add Field icon on the toolbar.</paragraph> - </tablecell> - </tablerow> - </table> - </section> - <list type="ordered"> - <listitem> - <paragraph role="paragraph" id="par_id141540563922693" xml-lang="en-US">Select the field in the Add Field dialog and click <emph>Insert</emph>. You can select multiple fields pressing the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key while clicking on the fields name or using the Shift key while pressing the mouse button. Click <emph>Insert</emph> in the toolbar to add the fields to the report.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id4051026" role="paragraph">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.</paragraph> - <paragraph xml-lang="en-US" id="par_id3397320" role="paragraph">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.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3059785" role="paragraph">You can also insert text that should be the same on every page of the report. Click the Label Field icon <image id="img_id5605334" src="media/icon-themes/cmd/lc_addfield.svg" width="0.566cm" height="0.566cm" localize="true"><alt xml-lang="en-US" id="alt_id5605334">Icon</alt></image>, then drag a rectangle in the Page Header or Page Footer area. Edit the Label property to show the text you want.</paragraph> - </listitem> - </list> - <paragraph role="heading" id="hd_id251540563929787" level="2" xml-lang="en-US">Sorting fields names</paragraph> - <table id="tab_id101540563992664"> - <tablerow> - <tablecell> - <paragraph role="paragraph" id="par_id651540564204840" xml-lang="en-US"> - <image src="media/icon-themes/cmd/sc_sortascending.svg" id="img_id631540564204841" width="1.0cm" height="1.0cm"><alt xml-lang="en-US" id="alt_id141540564204841">Sort Ascending icon</alt></image> - </paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id401540563992665" role="paragraph" xml-lang="en-US" >Sort names ascending.</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph role="paragraph" id="par_id811540564184191" xml-lang="en-US"> - <image src="media/icon-themes/cmd/sc_sortdescending.svg" id="img_id391540564184192" width="1.0cm" height="1.0cm"><alt xml-lang="en-US" id="alt_id571540564184192">Sort descending icon</alt></image> - </paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id401540563942665" role="paragraph" xml-lang="en-US" >Sort names descending,</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph role="paragraph" id="par_id851540564212907" xml-lang="en-US"> - <image src="media/icon-themes/cmd/lc_removefiltersort.svg" id="img_id41540564212907" width="1.0cm" height="1.0cm"><alt xml-lang="en-US" id="alt_id421540564212908">Undo sorting icon</alt></image> - </paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id401540533942665" role="paragraph" xml-lang="en-US" >Restore original sorting</paragraph> - </tablecell> - </tablerow> - </table> -</body> -</helpdocument> 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 @@ -<?xml version="1.0" encoding="UTF-8"?> -<helpdocument version="1.0"> -<!-- - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - --> - -<meta> - <topic id="textsharedexplorerdatabaserep_mainxml" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">Report Builder</title> - <filename>/text/shared/explorer/database/rep_main.xhp</filename> - </topic> -</meta> - -<body> - <bookmark xml-lang="en-US" branch="index" id="bm_id1614429"> - <bookmark_value>Report Builder</bookmark_value> - <bookmark_value>Oracle Report Builder</bookmark_value> - </bookmark> - <paragraph xml-lang="en-US" id="hd_id8773155" role="heading" level="1"><variable id="rep_main"><link href="text/shared/explorer/database/rep_main.xhp">Report Builder</link> -</variable></paragraph> - <paragraph xml-lang="en-US" id="par_id5248573" role="paragraph">The Report Builder is a tool to create your own database reports. Unlike with the <link href="text/shared/autopi/01100000.xhp">Report Wizard</link>, 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.</paragraph> - <paragraph xml-lang="en-US" id="par_id7128818" role="note">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.</paragraph> - <paragraph xml-lang="en-US" id="hd_id556047" role="heading" level="2">To install the JRE software</paragraph> - <paragraph xml-lang="en-US" id="par_id4515823" role="paragraph">The Report Builder requires an installed Java Runtime Environment (JRE).</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id4044312" role="paragraph">Choose <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME - <link href="text/shared/optionen/java.xhp">Advanced</link>.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id1369060" role="paragraph">Wait up to one minute, while %PRODUCTNAME collects information on installed Java software on your system.</paragraph> - <paragraph xml-lang="en-US" id="par_id860927" role="paragraph">If a recent JRE version is found on your system, you see an entry in the list.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id8581804" role="paragraph">Click the option button in front of the entry to enable this JRE version for use in %PRODUCTNAME.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id7730033" role="paragraph">Ensure that <emph>Use a Java runtime environment</emph> is enabled.</paragraph> - </listitem> - </list> - <paragraph xml-lang="en-US" id="par_id6317636" role="paragraph">If no JRE version is found on your system, open your web browser and download the JRE software from <link href="http://www.java.com">http://www.java.com</link>. Install the JRE software. Then restart %PRODUCTNAME and open <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME - Advanced again.</paragraph> - <paragraph xml-lang="en-US" id="hd_id9759514" role="heading" level="2">To open the Report Builder</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id9076509" role="paragraph">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.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id7050691" role="paragraph">Click the Reports icon in the Base window, then choose Create Report in Design View.</paragraph> - <paragraph xml-lang="en-US" id="par_id7118747" role="paragraph">The Report Builder window opens. </paragraph> - </listitem> - </list> - <paragraph xml-lang="en-US" id="par_id8283639" role="paragraph">The Report Builder is divided into three parts. On the top you see the menu, with the toolbars below.</paragraph> - <paragraph xml-lang="en-US" id="par_id2291024" role="paragraph">On the right you see the Properties window with the property values of the currently selected object.</paragraph> - <paragraph xml-lang="en-US" id="par_id2100589" role="paragraph">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:</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id5022125" role="paragraph"> - <emph>Page Header</emph> - drag control fields with fixed text into the Page Header area</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id6844386" role="paragraph"> - <emph>Detail</emph> - drag and drop database fields into the Detail area</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id7018646" role="paragraph"> - <emph>Page Footer</emph> - drag control fields with fixed text into the Page Footer area</paragraph> - </listitem> - </list> - <paragraph xml-lang="en-US" id="par_id5857112" role="paragraph">To insert an additional <emph>Report Header</emph> and <emph>Report Footer</emph> area choose <item type="menuitem">Edit - Insert Report Header/Footer</item>. These areas contain text that appears at the start and end of the whole report.</paragraph><comment>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.</comment><comment>column header/footer</comment> -<paragraph xml-lang="en-US" id="par_id6042664" role="paragraph">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.</paragraph> - <paragraph xml-lang="en-US" id="par_id1589098" role="paragraph">You insert database fields by drag-and-drop into the Detail area. See the section "To insert fields into the report" below.</paragraph> - <paragraph xml-lang="en-US" id="par_id1278420" role="paragraph">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.</paragraph> - <paragraph xml-lang="en-US" id="par_id7479476" role="heading" level="2">To connect the report to a database table</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id2218390" role="paragraph">Move the mouse to the Properties view. You see two tab pages General and Data.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id7771538" role="paragraph">On the Data tab page, click Content to open the combo box.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id366527" role="paragraph">Select the table for that you want to create the report.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id7996459" role="paragraph">After selecting the table, press the Tab key to leave the Content box.</paragraph> - </listitem> - </list> - <paragraph xml-lang="en-US" id="par_id2531815" role="paragraph">The <link href="text/shared/explorer/database/rep_insertfield.xhp" name="add_fields_link">Add fields to report</link> window opens automatically and shows all fields of the selected table.</paragraph> - <embed href="text/shared/explorer/database/rep_insertfield.xhp#insertfieldstitle"/> - <comment>Align at Section toolbar</comment> -<bookmark xml-lang="en-US" branch="hid/.uno:SectionAlignLeft" id="bm_id7889950" localize="false"/> -<paragraph xml-lang="en-US" id="par_id7657399" role="paragraph"><ahelp hid="." visibility="hidden">Select two or more objects and click this icon to align the objects at the left margin of the area.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/.uno:SectionAlignRight" id="bm_id3236182" localize="false"/> -<paragraph xml-lang="en-US" id="par_id8925138" role="paragraph"><ahelp hid="." visibility="hidden">Select two or more objects and click this icon to align the objects at the right margin of the area.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/.uno:SectionAlignTop" id="bm_id1251258" localize="false"/> -<paragraph xml-lang="en-US" id="par_id5461897" role="paragraph"><ahelp hid="." visibility="hidden">Select two or more objects and click this icon to align the objects at the top margin of the area.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/.uno:SectionAlignBottom" id="bm_id8111819" localize="false"/> -<paragraph xml-lang="en-US" id="par_id8919339" role="paragraph"><ahelp hid="." visibility="hidden">Select two or more objects and click this icon to align the objects at the bottom margin of the area.</ahelp></paragraph><comment>Object Resizing toolbar</comment> -<bookmark xml-lang="en-US" branch="hid/.uno:SmallestWidth" id="bm_id9116794" localize="false"/> -<paragraph xml-lang="en-US" id="par_id4634235" role="paragraph"><ahelp hid="." visibility="hidden">Select two or more objects and click this icon to resize the objects to the smallest width.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/.uno:SmallestHeight" id="bm_id4381847" localize="false"/> -<paragraph xml-lang="en-US" id="par_id1393475" role="paragraph"><ahelp hid="." visibility="hidden">Select two or more objects and click this icon to resize the objects to the smallest height.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/.uno:GreatestWidth" id="bm_id1336710" localize="false"/> -<paragraph xml-lang="en-US" id="par_id6571550" role="paragraph"><ahelp hid="." visibility="hidden">Select two or more objects and click this icon to resize the objects to the greatest width.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/.uno:GreatestHeight" id="bm_id1221655" localize="false"/> -<paragraph xml-lang="en-US" id="par_id5376140" role="paragraph"><ahelp hid="." visibility="hidden">Select two or more objects and click this icon to resize the objects to the greatest height.</ahelp></paragraph><comment>Report Controls toolbar</comment> -<bookmark xml-lang="en-US" branch="hid/.uno:HFixedLine" id="bm_id4408093" localize="false"/> -<paragraph xml-lang="en-US" id="par_id9611499" role="paragraph"><ahelp hid="." visibility="hidden">Inserts a horizontal line to the current area.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/.uno:VFixedLine" id="bm_id6949369" localize="false"/> -<paragraph xml-lang="en-US" id="par_id6765953" role="paragraph"><ahelp hid="." visibility="hidden">Inserts a vertical line to the current area.</ahelp></paragraph><comment>Shrink toolbar</comment> -<bookmark xml-lang="en-US" branch="hid/.uno:SectionShrink" id="bm_id040920092222313" localize="false"/> -<paragraph xml-lang="en-US" id="par_id0409200922242612" role="paragraph"><ahelp hid="." visibility="hidden">Shrinks the selected section to remove top and bottom empty space.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/.uno:SectionShrinkTop" id="bm_id0409200922231489" localize="false"/> -<paragraph xml-lang="en-US" id="par_id0409200922242617" role="paragraph"><ahelp hid="." visibility="hidden">Shrinks the selected section to remove top empty space.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/.uno:SectionShrinkBottom" id="bm_id040920092223576" localize="false"/> -<paragraph xml-lang="en-US" id="par_id0409200922242661" role="paragraph"><ahelp hid="." visibility="hidden">Shrinks the selected section to remove bottom empty space.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="par_id1511581" role="paragraph">After inserting fields in the Detail view, the report is ready for execution.</paragraph> - <paragraph xml-lang="en-US" id="par_id4881740" role="heading" level="2">To execute a report</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id8286385" role="paragraph">Click the Execute Report icon -<image id="img_id3380230" src="cmd/sc_executereport.png" width="0.566cm" height="0.566cm"><alt xml-lang="en-US" id="alt_id3380230">Icon</alt></image> on the toolbar.</paragraph> - </listitem> - </list> - <paragraph xml-lang="en-US" id="par_id2354197" role="paragraph">A Writer document opens and shows the report you have created, which contains all values of the database table which you have insert.</paragraph> - <paragraph xml-lang="en-US" id="par_id2485122" role="paragraph">If the database contents did change, execute the report again to update the result report.<comment>automatic? message?</comment></paragraph> - <paragraph xml-lang="en-US" id="hd_id8746910" role="heading" level="2">To edit a report</paragraph> - <paragraph xml-lang="en-US" id="par_id9636524" role="paragraph">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.</paragraph> - <paragraph xml-lang="en-US" id="par_id5941648" role="paragraph">The Writer document is opened read-only. To edit the Writer document, click <emph>Edit Document</emph> on the information bar, or choose <emph>Edit - Edit Mode</emph>.<comment>saved automatically with the Base file?</comment></paragraph> - <paragraph xml-lang="en-US" id="par_id8307138" role="paragraph">If you want to edit the Report Builder view, you can change some of its properties.</paragraph> - <paragraph xml-lang="en-US" id="par_id7138889" role="paragraph">Click in the Details area. Then in the Properties window, change some properties, for example the background color.</paragraph> - <paragraph xml-lang="en-US" id="par_id9869380" role="paragraph">After finishing, click the Execute Report icon -<image id="Graphic2" src="cmd/sc_executereport.png" width="0.566cm" height="0.566cm"><alt xml-lang="en-US" id="alt_">Icon</alt></image> to create a new report.</paragraph> - <paragraph xml-lang="en-US" id="par_id12512" role="paragraph">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.<comment>report part of Base file?</comment></paragraph> - <paragraph xml-lang="en-US" id="par_id2676168" role="heading" level="2">Sorting the report</paragraph> - <paragraph xml-lang="en-US" id="par_id2626422" role="paragraph">Without sorting or grouping, the records will be inserted into the report in the order in which they are retrieved from the database.</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id1743827" role="paragraph">Open the Report Builder view and click the Sorting and Grouping icon -<image id="img_id9557786" src="cmd/sc_dbsortingandgrouping.png" width="0.566cm" height="0.566cm"><alt xml-lang="en-US" id="alt_id9557786">Icon</alt></image> on the toolbar. You see the <link href="text/shared/explorer/database/rep_sort.xhp">Sorting and Grouping</link> dialog.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id4331797" role="paragraph">In the Groups box, click the field which you want as the first sort field, and set the Sorting property.<comment>what meaning has the order of fields / move up down button?</comment></paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id4191717" role="paragraph">Execute the report.</paragraph> - </listitem> - </list> - <paragraph xml-lang="en-US" id="par_id2318796" role="heading" level="2">Grouping</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id399182" role="paragraph">Open the Report Builder view and click the Sorting and Grouping icon -<image id="Graphic21" src="cmd/sc_dbsortingandgrouping.png" width="0.566cm" height="0.566cm"><alt xml-lang="en-US" id="alt_">Icon</alt></image> on the toolbar. You see the <link href="text/shared/explorer/database/rep_sort.xhp">Sorting and Grouping</link> dialog.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id7588732" role="paragraph">In the Groups box, open the Group Header list box and select to show a group header.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id95828" role="paragraph">Click the Add Field icon -<image id="Graphic3" src="cmd/sc_addfield.png" width="0.566cm" height="0.566cm"><alt xml-lang="en-US" id="alt_">Icon</alt></image> to open the Add Field window.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id5675527" role="paragraph">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.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3496200" role="paragraph">Execute the report. The report shows the grouped records.</paragraph> - </listitem> - </list> - <paragraph xml-lang="en-US" id="par_id7599108" role="paragraph">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.</paragraph> - <paragraph xml-lang="en-US" id="par_id888698" role="heading" level="2">Updating and printing your data</paragraph> - <paragraph xml-lang="en-US" id="par_id3394573" role="paragraph">When you insert some new data or edit data in the table, a new report will show the updated data.</paragraph> - <paragraph xml-lang="en-US" id="par_id7594225" role="paragraph">Click the Reports icon -<image id="img_id4678487" src="dbaccess/res/reports_32.png" width="0.566cm" height="0.566cm"><alt xml-lang="en-US" id="alt_id4678487">Icon</alt></image> and double-click your last saved report. A new Writer document will be created which shows the new data.</paragraph> - <paragraph xml-lang="en-US" id="par_id8147221" role="paragraph">To print a report, choose <item type="menuitem">File - Print</item> from the Writer document.</paragraph> - </body> -</helpdocument> 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 @@ -<?xml version="1.0" encoding="UTF-8"?> - - - -<!-- - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - --> - - -<helpdocument version="1.0"> -<meta> -<topic id="textsharedexplorerdatabaserep_navigatorxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Report Navigator</title> -<filename>/text/shared/explorer/database/rep_navigator.xhp</filename> -</topic> -</meta> -<body> -<bookmark xml-lang="en-US" branch="index" id="bm_id5823847"><bookmark_value>formulas in reports;editing</bookmark_value> -<bookmark_value>functions in reports;editing</bookmark_value> -</bookmark> -<bookmark xml-lang="en-US" branch="hid/.uno:ReportNavigator" id="bm_id8798791" localize="false"/><paragraph role="heading" id="hd_id1821955" xml-lang="en-US" level="1"><variable id="rep_navigator"><link href="text/shared/explorer/database/rep_navigator.xhp">Report Navigator</link> -</variable></paragraph> -<paragraph role="paragraph" id="par_id1150852" xml-lang="en-US">You can open the Report Navigator window of the <link href="text/shared/explorer/database/rep_main.xhp">Report Builder</link> by choosing <item type="menuitem">View - Report Navigator</item>.</paragraph> -<paragraph role="paragraph" id="par_id1111484" xml-lang="en-US"><ahelp hid=".">The Report Navigator reveals the structure of the report. You can use the Report Navigator to insert functions into the report.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_REPORT_NAVIGATOR_TREE" id="bm_id7007354" localize="false"/><paragraph role="paragraph" id="par_id8314157" xml-lang="en-US"><ahelp hid=".">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.</ahelp></paragraph> -<paragraph role="heading" id="hd_id2932828" xml-lang="en-US" level="2">To enter functions to the report</paragraph> -<bookmark xml-lang="en-US" branch="hid/.uno:NewFunction" id="bm_id974456" localize="false"/><paragraph role="paragraph" id="par_id5091708" xml-lang="en-US"><ahelp hid=".">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.</ahelp></paragraph> -<paragraph role="paragraph" id="par_id9449446" xml-lang="en-US">Functions can be entered using a syntax as specified by the <link href="https://en.wikipedia.org/wiki/OpenFormula" name="English Wikipedia: OpenFormula">OpenFormula</link> proposal.</paragraph> -<paragraph role="paragraph" id="par_id4095583" xml-lang="en-US">See <link href="https://wiki.documentfoundation.org/Database" name="wiki.documentfoundation.org Database">Wiki page about Base</link> for some more help regarding the functions in a report.</paragraph> -<paragraph role="heading" id="hd_id311593" xml-lang="en-US" level="3">To calculate a sum for each client<comment>copied from a mail by Ocke - did not test</comment></paragraph> -<list type="ordered"> -<listitem> -<paragraph role="paragraph" id="par_id3948789" xml-lang="en-US">Open the Report Navigator.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id5391399" xml-lang="en-US">Open the Groups entry and the group where you want to calculate the cost. </paragraph> -<paragraph role="paragraph" id="par_id6989654" xml-lang="en-US">The group has a sub entry called functions. </paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id1803643" xml-lang="en-US">Open the context menu (right click) on the functions entry, choose to create a new function, and select it. </paragraph> -<paragraph role="paragraph" id="par_id868251" xml-lang="en-US">In the property browser you see the function. </paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id6247749" xml-lang="en-US">Change the name to e.g. CostCalc and the formula to [CostCalc] + [enter your cost column name].</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id1565904" xml-lang="en-US">In the initial value enter 0.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id1569261" xml-lang="en-US">Now you can insert a text field and bind it to your [CostCalc] (appears in the data field list box).</paragraph> -</listitem> -</list> -<paragraph role="paragraph" id="par_id9256874" xml-lang="en-US">Maybe you have to set the initial value to the value of the field like [field].<comment>these 3 paras copied from another mail by Ocke in users@dba.o.o</comment></paragraph> -<paragraph role="paragraph" id="par_id4601886" xml-lang="en-US">If there are blank fields in the cost column, use the following formula to replace the blank fields' content with zero:</paragraph> -<paragraph role="code" id="par_id1754509" xml-lang="en-US">[SumCost] + IF(ISBLANK([field]);0;[field])</paragraph><comment>need some real working examples. See i81874</comment><comment>Formula</comment> -<bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_FORMULA" id="bm_id2767113" localize="false"/><paragraph role="paragraph" id="par_id8122196" xml-lang="en-US"><ahelp hid="." visibility="hidden">Enter the formula that defines the function. Use OpenFormula syntax.</ahelp></paragraph><comment>Initial value</comment> -<bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_INITIALFORMULA" id="bm_id301828" localize="false"/><paragraph role="paragraph" id="par_id9909665" xml-lang="en-US"><ahelp hid="." visibility="hidden">Enter the initial value for the evaluation of the formula. Often this is set to 0 or to 1.</ahelp></paragraph><comment>Deep traversing</comment> -<bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_DEEPTRAVERSING" id="bm_id8996246" localize="false"/><paragraph role="paragraph" id="par_id9141819" xml-lang="en-US"><ahelp hid="." visibility="hidden">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.</ahelp></paragraph><comment>Pre evaluation</comment> -<bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_PREEVALUATED" id="bm_id5729544" localize="false"/><paragraph role="paragraph" id="par_id6354869" xml-lang="en-US"><ahelp hid="." visibility="hidden">If Pre evaluation is enabled, functions are evaluated only when the report is finished.</ahelp></paragraph> -</body> -</helpdocument> 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 @@ -<?xml version="1.0" encoding="UTF-8"?> - - - -<!-- - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - --> - - - <helpdocument version="1.0"> -<meta> -<topic id="textsharedexplorerdatabaserep_pagenumbersxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Page Numbers </title> -<filename>/text/shared/explorer/database/rep_pagenumbers.xhp</filename> -</topic> -</meta> -<body> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/pagenumberdialog/PageNumberDialog" id="bm_id7565844" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/pagenumberdialog/@@nowidget@@" id="bm_id7565844" localize="false"/> -<paragraph role="heading" id="hd_id3674123" xml-lang="en-US" level="1"><variable id="rep_pagenumbers"><link href="text/shared/explorer/database/rep_pagenumbers.xhp">Page Numbers</link> -</variable></paragraph> -<paragraph role="paragraph" id="par_id3424481" xml-lang="en-US"><ahelp hid=".">You can open the Page Numbers dialog of the <link href="text/shared/explorer/database/rep_main.xhp">Report Builder</link> by choosing <item type="menuitem">Insert - Page Numbers</item>.</ahelp></paragraph> -<paragraph role="tip" id="par_id1068758" xml-lang="en-US">Press <item type="keycode">Shift-F1</item> and point with the mouse at an input box to see a help text for this input box.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/pagenumberdialog/pagen" id="bm_id7565843" localize="false"/><paragraph role="paragraph" id="par_id1559190" xml-lang="en-US"><ahelp hid="." visibility="hidden">Page N</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/pagenumberdialog/pagenofm" id="bm_id6649372" localize="false"/><paragraph role="paragraph" id="par_id9879146" xml-lang="en-US"><ahelp hid="." visibility="hidden">Page N of M</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/pagenumberdialog/toppage" id="bm_id7334208" localize="false"/><paragraph role="paragraph" id="par_id9404278" xml-lang="en-US"><ahelp hid="." visibility="hidden">Top of Page (Header)</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/pagenumberdialog/bottompage" id="bm_id8313852" localize="false"/><paragraph role="paragraph" id="par_id7626880" xml-lang="en-US"><ahelp hid="." visibility="hidden">Bottom of Page (Footer)</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/pagenumberdialog/alignment" id="bm_id8829309" localize="false"/><paragraph role="paragraph" id="par_id6124149" xml-lang="en-US"><ahelp hid="." visibility="hidden">Alignment</ahelp></paragraph> -<list type="unordered"> -<listitem> -<paragraph role="paragraph" id="par_id8257087" xml-lang="en-US">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.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3479415" xml-lang="en-US">Select to show the page numbers in the Page Header area or in the Page Footer area.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id4441663" xml-lang="en-US">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.</paragraph> -</listitem> -</list> -<paragraph role="paragraph" id="par_id3012176" xml-lang="en-US">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.</paragraph> -<paragraph role="paragraph" id="par_id8532670" xml-lang="en-US">You can click the data field and drag to another position within the same area, or edit the properties in the Properties window.</paragraph> -</body> -</helpdocument> 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 @@ -<?xml version="1.0" encoding="UTF-8"?> -<helpdocument version="1.0"> -<!-- - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . ---> - -<meta> - <topic id="textsharedexplorerdatabaserep_propxml" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">Properties </title> - <filename>/text/shared/explorer/database/rep_prop.xhp</filename> - </topic> -</meta> - -<body> - <h1 id="hd_id8836939"><variable id="rep_prop"><link href="text/shared/explorer/database/rep_prop.xhp">Properties</link></variable></h1> - <paragraph id="par_id2711264" role="paragraph">The Properties window of the <link href="text/shared/explorer/database/rep_main.xhp">Report Builder</link> always shows the properties of the currently selected object in the Report Builder view.</paragraph> - <tip id="par_id1080660">Press Shift-F1 and point with the mouse at an input box to see a help text for this input box.</tip> - <paragraph id="par_id7175817" role="paragraph">On first start of the Report Builder, the Properties window shows the <emph>Data</emph> tab page for the whole report.</paragraph> - <paragraph id="par_id9895931" role="paragraph">Select a table from the Contents list, then press Tab or click outside the input box to leave the input box.</paragraph> - <paragraph id="par_id3587145" role="paragraph"><ahelp hid=".">The <link href="text/shared/explorer/database/rep_insertfield.xhp" name="add_fields_link">Add fields to report</link> 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 <item type="menuitem">View - Add Field</item>.</ahelp></paragraph> - <paragraph id="par_id6993926" role="paragraph">The <emph>General</emph> tab page can be used to change the name of the report, and to disable the Page Header or Page Footer areas, among others.</paragraph> - <bookmark xml-lang="en-US" branch="hid/.uno:SelectReport" id="bm_id9044770" localize="false"/> - <tip id="par_id3729361"><ahelp hid=".">To display the <emph>Data</emph> or <emph>General</emph> tab page for the whole report, choose <item type="menuitem">Edit - Select All - Select Report</item>.</ahelp></tip> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_GROUPKEEPTOGETHER" id="bm_id5392315" localize="false"/> - <paragraph id="par_id1768852" role="paragraph"><ahelp hid="." visibility="hidden">Groups are kept together by page or by column (default). You must enable Keep Together also.</ahelp></paragraph><comment>Page header</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_PAGEHEADEROPTION" id="bm_id7852412" localize="false"/> - <paragraph id="par_id6304818" role="paragraph"><ahelp hid="." visibility="hidden">Specifies in which context the page header will be printed: on all pages, or not on pages with a report header or footer.</ahelp></paragraph><comment>Page footer</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_PAGEFOOTEROPTION" id="bm_id9031952" localize="false"/> - <paragraph id="par_id401623" role="paragraph"><ahelp hid="." visibility="hidden">Specifies in which context the page footer will be printed: on all pages, or not on pages with a report header or footer</ahelp></paragraph><comment>Print repeated values</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_PRINTREPEATEDVALUES" id="bm_id7956785" localize="false"/> - <paragraph id="par_id2162236" role="paragraph"><ahelp hid="." visibility="hidden">Specifies to print repeated values.</ahelp></paragraph> - <paragraph id="par_id7022003" role="paragraph">If you click the Page Header or Page Footer area without selecting any object, you see the <emph>General</emph> tab page for that area.</paragraph> - <paragraph id="par_id7004303" role="paragraph">You can edit some visual properties for the area.<comment>screen only or also in report?</comment></paragraph><comment>Background color</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_BACKCOLOR" id="bm_id9801324" localize="false"/> - <paragraph id="par_id2561723" role="paragraph"><ahelp hid="." visibility="hidden">Sets the background color for the selected object, both on screen and for printing.</ahelp></paragraph><comment>Visible</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_VISIBLE" id="bm_id7446516" localize="false"/> - <paragraph id="par_id1064485" role="paragraph"><ahelp hid="." visibility="hidden">An invisible object is not shown in the executed report. It is still visible in the Report Builder view.</ahelp></paragraph><comment>Height</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_RPT_HEIGHT" id="bm_id8859828" localize="false"/> - <paragraph id="par_id2356028" role="paragraph"><ahelp hid="." visibility="hidden">Defines the height of the selected object.</ahelp></paragraph><comment>Conditional Print Expression</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_CONDITIONALPRINTEXPRESSION" id="bm_id4359874" localize="false"/> - <paragraph id="par_id1404461" role="paragraph"><ahelp hid=".">If the Conditional Print Expression evaluates to TRUE, the selected object will be printed.</ahelp></paragraph><comment>id="par_id2386852" Conditions use the following form:</comment><comment>Background transparent</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_BACKTRANSPARENT" id="bm_id5689565" localize="false"/> - <paragraph id="par_id7404705" role="paragraph"><ahelp hid="." visibility="hidden">Specifies whether the background of the selected object is transparent or opaque.</ahelp><comment>just guessing</comment></paragraph> - <paragraph id="par_id7466963" role="paragraph">If you click the <emph>Detail</emph> area without selecting any object, you see the <emph>General</emph> tab page for that area.</paragraph> - <paragraph id="par_id3644215" role="paragraph">You can specify some properties to fine-tune the way the records are printed.</paragraph><comment>Force New Page</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_FORCENEWPAGE" id="bm_id66225" localize="false"/> - <paragraph id="par_id3148899" role="paragraph"><ahelp hid="." visibility="hidden">Force New Page specifies whether the current section and/or the next section is printed on a new page.</ahelp></paragraph><comment>New Row Or Column</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_NEWROWORCOL" id="bm_id3920102" localize="false"/> - <paragraph id="par_id6164433" role="paragraph"><ahelp hid="." visibility="hidden">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.</ahelp></paragraph><comment>Keep together</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_KEEPTOGETHER" id="bm_id8053529" localize="false"/> - <paragraph id="par_id7405011" role="paragraph"><ahelp hid="." visibility="hidden">Keep Together specifies to print the current object starting on top of a new page if it doesn't fit on the current page.</ahelp></paragraph> - <paragraph id="par_id1536606" role="paragraph">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.</paragraph> - <paragraph id="par_id9631641" role="paragraph">For a Label field, you can change the displayed text in the Label input box.</paragraph> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_PRESERVEIRI" id="bm_id7422711" localize="false"/> - <paragraph id="par_id7749565" role="paragraph"><ahelp hid=".">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.</ahelp></paragraph><comment>Position x</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_RPT_POSITIONX" id="bm_id6006958" localize="false"/> - <paragraph id="par_id4041871" role="paragraph"><ahelp hid="." visibility="hidden">Set the X Position for the selected object</ahelp><comment>x in pixel or twips? or current measurement units? from origin as on ruler? from elsewhere?</comment></paragraph><comment>Position y</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_RPT_POSITIONY" id="bm_id7606128" localize="false"/> - <paragraph id="par_id9930722" role="paragraph"><ahelp hid="." visibility="hidden">Set the Y Position for the selected object</ahelp></paragraph><comment>Width</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_RPT_WIDTH" id="bm_id5778374" localize="false"/> - <paragraph id="par_id5749687" role="paragraph"><ahelp hid="." visibility="hidden">Sets the width of the selected object.</ahelp></paragraph><comment>Font</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_RPT_FONT" id="bm_id3184301" localize="false"/> - <paragraph id="par_id79348" role="paragraph"><ahelp hid="." visibility="hidden">Select the font for the selected text object.</ahelp></paragraph><comment>Print when group change</comment> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_PRINTWHENGROUPCHANGE" id="bm_id2129276" localize="false"/> - <paragraph id="par_id2414014" role="paragraph"><ahelp hid="." visibility="hidden">Print when group change</ahelp></paragraph><comment>Vert. Alignment</comment> - <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_VERTICAL_ALIGN" id="bm_id9719229" localize="false"/> - <paragraph id="par_id7617114" role="paragraph"><ahelp hid="." visibility="hidden">Vert. Alignment</ahelp></paragraph> - <paragraph id="par_id1593676" role="paragraph">On the <emph>General</emph> tab page of a data field, you can set the Formatting properties, among others.</paragraph> - <bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_PROP_DATAFIELD" id="bm_id3860896" localize="false"/> - <paragraph id="par_id1243629" role="paragraph"><ahelp hid=".">On the Data tab page, you can change the data contents to be shown.</ahelp></paragraph> -</body> -</helpdocument> 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 @@ -<?xml version="1.0" encoding="UTF-8"?> -<helpdocument version="1.0"> - -<!-- - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - --> - - -<meta> - <topic id="textsharedexplorerdatabaserep_sortxml" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">Sorting and Grouping</title> - <filename>/text/shared/explorer/database/rep_sort.xhp</filename> - </topic> - </meta> - <body> - <section id="sort"> -<bookmark xml-lang="en-US" branch="hid/.uno:DbSortingAndGrouping" id="bm_id9569078" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/floatingsort/FloatingSort" id="bm_id9569079" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/floatingsort/@@nowidget@@" id="bm_id9569079" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3486434" role="heading" level="1"><variable id="rep_sort"><link href="text/shared/explorer/database/rep_sort.xhp">Sorting and Grouping</link> -</variable></paragraph> - <paragraph xml-lang="en-US" id="par_id3068636" role="paragraph"><ahelp hid=".">In the Sorting and Grouping dialog of <link href="text/shared/explorer/database/rep_main.xhp">Report Builder</link>, you can define the fields that should be sorted in your report, and the fields that should be kept together to form a group.</ahelp> 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.</paragraph> - </section> - <paragraph xml-lang="en-US" id="par_id876186" role="paragraph">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. </paragraph> - <paragraph xml-lang="en-US" id="par_id3939634" role="paragraph">The sorting and grouping will be applied in the order of the list from top to bottom.</paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/floatingsort/box" id="bm_id2480849" localize="false"/> -<paragraph xml-lang="en-US" id="par_id599688" role="paragraph"><ahelp hid="." visibility="hidden">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.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/REPORTDESIGN_HID_RPT_FIELDEXPRESSION" id="bm_id4181951" localize="false"/> -<paragraph xml-lang="en-US" id="par_id1371501" role="paragraph"><ahelp hid="." visibility="hidden">Click to open a list from which you can select a field.</ahelp></paragraph> -<!-- removed HID 2114727444 --> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/floatingsort/up" id="bm_id2927436" localize="false"/> -<paragraph xml-lang="en-US" id="par_id4661702" role="paragraph"><ahelp hid="." visibility="hidden">Moves the selected field up in the list.</ahelp></paragraph> -<!-- removed HID 2114727445 --> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/floatingsort/down" id="bm_id2107304" localize="false"/> -<paragraph xml-lang="en-US" id="par_id7868892" role="paragraph"><ahelp hid="." visibility="hidden">Moves the selected field down in the list.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/floatingsort/sorting" id="bm_id4071779" localize="false"/> -<paragraph xml-lang="en-US" id="par_id2188787" role="paragraph"><ahelp hid="." visibility="hidden">Select the sorting order.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/floatingsort/header" id="bm_id7844477" localize="false"/> -<paragraph xml-lang="en-US" id="par_id5833307" role="paragraph"><ahelp hid="." visibility="hidden">Select to show or hide the Group Header.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/floatingsort/footer" id="bm_id6478469" localize="false"/> -<paragraph xml-lang="en-US" id="par_id7726676" role="paragraph"><ahelp hid="." visibility="hidden">Select to show or hide the Group Footer.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/floatingsort/group" id="bm_id9038972" localize="false"/> -<paragraph xml-lang="en-US" id="par_id3729361" role="paragraph"><ahelp hid="." visibility="hidden">Select to create a new group on each changed value, or on other properties.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/floatingsort/delete" id="bm_id9038973" localize="false"/> -<paragraph xml-lang="en-US" id="par_id0409200922142041" role="paragraph"><ahelp hid="." visibility="hidden">Removes the selected field from the list.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="par_id3405560" role="paragraph">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:</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id3409527" role="paragraph">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.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id7112338" role="paragraph">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.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id2855616" role="paragraph">For fields of type AutoNumber, Currency, or Number, you specify an interval.<comment>how?</comment></paragraph> - </listitem> - </list> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/floatingsort/interval" id="bm_id7985168" localize="false"/> -<paragraph xml-lang="en-US" id="par_id7700430" role="paragraph"><ahelp hid="." visibility="hidden">Enter the group interval value that records are grouped by.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/modules/dbreport/ui/floatingsort/keep" id="bm_id9573961" localize="false"/> -<paragraph xml-lang="en-US" id="par_id1180455" role="paragraph"><ahelp hid="." visibility="hidden">Select the level of detail by which a group is kept together on the same page.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="par_id2091433" role="paragraph">When you specify to keep together some records on the same page, you have three choices:</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id5092318" role="paragraph">No - page boundaries are not taken into account.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id9312417" role="paragraph">Whole Group - prints the group header, detail section, and group footer on the same page.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id9089022" role="paragraph">With First Detail - prints the group header on a page only if the first detail record also can be printed on the same page.</paragraph> - </listitem> - </list> - </body> -</helpdocument> 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 @@ </listitem> </list> <paragraph role="paragraph" id="par_id8138065" xml-lang="en-US">The Report Builder window opens with the report's information loaded. </paragraph> -<paragraph role="paragraph" id="par_id5086825" xml-lang="en-US">Use the toolbars and menu commands and drag-and-drop to edit the report as stated in the <link href="text/shared/explorer/database/rep_main.xhp">Report Builder</link> guide.</paragraph> +<paragraph role="paragraph" id="par_id5086825" xml-lang="en-US">Use the toolbars and menu commands and drag-and-drop to edit the report as stated in the <link href="text/sdatabase/rep_main.xhp">Report Builder</link> guide.</paragraph> <paragraph role="paragraph" id="par_id4747154" xml-lang="en-US">Execute the report to see the resulting report document.</paragraph> <paragraph role="heading" id="hd_id3153104" xml-lang="en-US" level="2">Editing a Report Created by the Report Wizard</paragraph> <list type="unordered"> 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 @@ <paragraph role="paragraph" id="par_id5758842" xml-lang="en-US">Click <emph>Create Report in Design View</emph>.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id4870754" xml-lang="en-US">Follow the instructions in the <link href="text/shared/explorer/database/rep_main.xhp">Report Builder</link> guide.</paragraph> +<paragraph role="paragraph" id="par_id4870754" xml-lang="en-US">Follow the instructions in the <link href="text/sdatabase/rep_main.xhp">Report Builder</link> guide.</paragraph> </listitem> </list> <paragraph role="heading" id="par_idN105C4" xml-lang="en-US" level="2">Creating a New Report With the Report Wizard</paragraph> |