diff options
| author | Kurt Zenker <kz@openoffice.org> | 2009-09-11 17:55:45 +0000 |
|---|---|---|
| committer | Kurt Zenker <kz@openoffice.org> | 2009-09-11 17:55:45 +0000 |
| commit | f8050a8d1ab674e1089d28ff5a6378126b68db2d (patch) | |
| tree | 05c0c21634a060aaa2f9e3d216298c9b99636271 /helpcontent2/source/text/shared/explorer/database | |
| parent | 21c07ae6febccb6fab0d58c7d5bbf9628a06f4db (diff) | |
CWS-TOOLING: integrate CWS hcshared23
2009-09-09 15:34:15 +0200 ufi r275999 : again
2009-09-08 16:41:34 +0200 ufi r275941 : vor bauen
2009-09-08 16:35:18 +0200 ufi r275940 : vor bauen
2009-09-07 11:12:35 +0200 ufi r275878 : test
Diffstat (limited to 'helpcontent2/source/text/shared/explorer/database')
4 files changed, 358 insertions, 329 deletions
diff --git a/helpcontent2/source/text/shared/explorer/database/dabaadvpropdat.xhp b/helpcontent2/source/text/shared/explorer/database/dabaadvpropdat.xhp index 54d89b3bd9..2350ad4e7b 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabaadvpropdat.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabaadvpropdat.xhp @@ -10,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: dabaadvpropdat.xhp,v $ - * $Revision: 1.10.4.1 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -35,61 +35,64 @@ <meta> -<topic id="textsharedexplorerdatabasedabaadvpropdatxml" indexer="include"> -<title id="tit" xml-lang="en-US">Special Settings</title> -<filename>/text/shared/explorer/database/dabaadvpropdat.xhp</filename> -</topic> -</meta> -<body> -<section id="data"> -<paragraph role="heading" id="par_idN10556" xml-lang="en-US" level="1" l10n="CHG"><link href="text/shared/explorer/database/dabaadvpropdat.xhp">Special Settings</link></paragraph> -<paragraph role="paragraph" id="par_idN10566" xml-lang="en-US" l10n="NEW">Specifies the way you can work with data in a database.</paragraph> -</section> -<section id="howtoget"> -<paragraph role="paragraph" id="par_id7679372" xml-lang="en-US" l10n="NEW">In a database window, choose <emph>Edit - Database - Advanced Settings</emph> -</paragraph> -</section> -<paragraph role="paragraph" id="par_id4572283" xml-lang="en-US" l10n="NEW">The availability of the following controls depends on the type of database:</paragraph> -<paragraph role="heading" id="par_idN10590" xml-lang="en-US" level="2" l10n="NEW">Use SQL92 naming constraints<comment>UFI: found this for dBase and for text file folder</comment></paragraph> -<paragraph role="paragraph" id="par_idN10594" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Only allows characters that conform to the SQL92 naming convention in a name in a data source. All other characters are rejected. Each name must begin with a lowercase letter, an uppercase letter, or an underscore ( _ ). The remaining characters can be ASCII letters, numbers, and underscores.</ahelp></paragraph> + <topic id="textsharedexplorerdatabasedabaadvpropdatxml" indexer="include"> + <title xml-lang="en-US" id="tit">Special Settings</title> + <filename>/text/shared/explorer/database/dabaadvpropdat.xhp</filename> + </topic> + </meta> + <body> + <section id="data"> + <paragraph xml-lang="en-US" id="par_idN10556" role="heading" level="1" l10n="CHG"><link href="text/shared/explorer/database/dabaadvpropdat.xhp">Special Settings</link></paragraph> + <paragraph xml-lang="en-US" id="par_idN10566" role="paragraph" l10n="NEW">Specifies the way you can work with data in a database.</paragraph> + </section> + <section id="howtoget"> + <paragraph xml-lang="en-US" id="par_id7679372" role="paragraph" l10n="NEW">In a database window, choose <emph>Edit - Database - Advanced Settings</emph> + </paragraph> + </section> + <paragraph xml-lang="en-US" id="par_id4572283" role="paragraph" l10n="NEW">The availability of the following controls depends on the type of database:</paragraph> + <paragraph xml-lang="en-US" id="par_idN10590" role="heading" level="2" l10n="NEW">Use SQL92 naming constraints<comment>UFI: found this for dBase and for text file folder</comment></paragraph> + <paragraph xml-lang="en-US" id="par_idN10594" role="paragraph" l10n="NEW"><ahelp hid=".">Only allows characters that conform to the SQL92 naming convention in a name in a data source. All other characters are rejected. Each name must begin with a lowercase letter, an uppercase letter, or an underscore ( _ ). The remaining characters can be ASCII letters, numbers, and underscores.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DSADMIN_DOSLINEENDS" id="bm_id6617328" localize="false"/> -<paragraph role="heading" id="hd_id3534958" xml-lang="en-US" level="2" l10n="NEW">End text lines with CR + LF<comment>UFI: found for dBase and text file folder</comment></paragraph> -<paragraph role="paragraph" id="par_id6151921" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select to use the CR + LF code pair to end every text line (preferred for DOS and Windows operating systems).</ahelp></paragraph> +<paragraph xml-lang="en-US" id="hd_id3534958" role="heading" level="2" l10n="NEW">End text lines with CR + LF<comment>UFI: found for dBase and text file folder</comment></paragraph> + <paragraph xml-lang="en-US" id="par_id6151921" role="paragraph" l10n="NEW"><ahelp hid=".">Select to use the CR + LF code pair to end every text line (preferred for DOS and Windows operating systems).</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DSADMIN_APPENDTABLEALIAS" id="bm_id9050569" localize="false"/> -<paragraph role="heading" id="par_idN1059E" xml-lang="en-US" level="2" l10n="NEW">Append the table alias name in SELECT statements</paragraph> -<paragraph role="paragraph" id="par_idN105A2" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Appends the alias to the table name in SELECT statements.</ahelp></paragraph> +<paragraph xml-lang="en-US" id="par_idN1059E" role="heading" level="2" l10n="NEW">Append the table alias name in SELECT statements</paragraph> + <paragraph xml-lang="en-US" id="par_idN105A2" role="paragraph" l10n="NEW"><ahelp hid=".">Appends the alias to the table name in SELECT statements.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DSADMIN_ENABLEOUTERJOIN" id="bm_id7278664" localize="false"/> -<paragraph role="heading" id="par_idN105A5" xml-lang="en-US" level="2" l10n="NEW">Use Outer Join syntax '{OJ }'</paragraph> -<paragraph role="paragraph" id="par_idN105A9" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Use escape sequences for outer joins. The syntax for this escape sequence is {oj outer-join}</ahelp><comment>copied from shared\explorer\database\02010100.xhp</comment></paragraph> -<paragraph role="paragraph" id="par_idN105BE" xml-lang="en-US" l10n="NEW">Example:</paragraph> -<paragraph role="example" id="par_idN105C1" xml-lang="en-US" l10n="NEW">select Article.* from {oj item LEFT OUTER JOIN orders ON item.no=orders.ANR}</paragraph> +<paragraph xml-lang="en-US" id="par_idN105A5" role="heading" level="2" l10n="NEW">Use Outer Join syntax '{OJ }'</paragraph> + <paragraph xml-lang="en-US" id="par_idN105A9" role="paragraph" l10n="NEW"><ahelp hid=".">Use escape sequences for outer joins. The syntax for this escape sequence is {oj outer-join}</ahelp><comment>copied from shared\explorer\database\02010100.xhp</comment></paragraph> + <paragraph xml-lang="en-US" id="par_idN105BE" role="paragraph" l10n="NEW">Example:</paragraph> + <paragraph xml-lang="en-US" id="par_idN105C1" role="example" l10n="NEW">select Article.* from {oj item LEFT OUTER JOIN orders ON item.no=orders.ANR}</paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DSADMIN_IGNOREDRIVER_PRIV" id="bm_id3826715" localize="false"/> -<paragraph role="heading" id="par_idN105C4" xml-lang="en-US" level="2" l10n="NEW">Ignore the privileges from the database driver</paragraph> -<paragraph role="paragraph" id="par_idN105C8" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Ignores access privileges that are provided by the database driver.</ahelp></paragraph> +<paragraph xml-lang="en-US" id="par_idN105C4" role="heading" level="2" l10n="NEW">Ignore the privileges from the database driver</paragraph> + <paragraph xml-lang="en-US" id="par_idN105C8" role="paragraph" l10n="NEW"><ahelp hid=".">Ignores access privileges that are provided by the database driver.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DSADMIN_PARAMETERNAMESUBST" id="bm_id8939786" localize="false"/> -<paragraph role="heading" id="par_idN105CB" xml-lang="en-US" level="2" l10n="NEW">Replace named parameters with ?</paragraph> -<paragraph role="paragraph" id="par_idN105CF" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Replaces named parameters in a data source with a question mark (?).</ahelp></paragraph> +<paragraph xml-lang="en-US" id="par_idN105CB" role="heading" level="2" l10n="NEW">Replace named parameters with ?</paragraph> + <paragraph xml-lang="en-US" id="par_idN105CF" role="paragraph" l10n="NEW"><ahelp hid=".">Replaces named parameters in a data source with a question mark (?).</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DSADMIN_SUPPRESS_VERSIONCL" id="bm_id6642353" localize="false"/> -<paragraph role="heading" id="par_idN105D2" xml-lang="en-US" level="2" l10n="NEW">Display version columns (when available)</paragraph> -<paragraph role="paragraph" id="par_idN105D6" xml-lang="en-US" l10n="NEW">Some databases assign version numbers to fields to track changes to records. The version number of a field is incremented by one each time the contents of the field are changed. <ahelp hid="HID_DSADMIN_SUPPRESS_VERSIONCL">Displays the internal version number of the record in the database table.</ahelp><comment>copied from shared\explorer\database\11090000.xhp</comment></paragraph> +<paragraph xml-lang="en-US" id="par_idN105D2" role="heading" level="2" l10n="NEW">Display version columns (when available)</paragraph> + <paragraph xml-lang="en-US" id="par_idN105D6" role="paragraph" l10n="NEW">Some databases assign version numbers to fields to track changes to records. The version number of a field is incremented by one each time the contents of the field are changed. <ahelp hid="HID_DSADMIN_SUPPRESS_VERSIONCL">Displays the internal version number of the record in the database table.</ahelp><comment>copied from shared\explorer\database\11090000.xhp</comment></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DSADMIN_CATALOG" id="bm_id2444532" localize="false"/> -<paragraph role="heading" id="par_idN105FA" xml-lang="en-US" level="2" l10n="NEW">Use the catalog name in SELECT statements</paragraph> -<paragraph role="paragraph" id="par_idN105FE" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Uses the current data source of the catalog. This option is useful when the ODBC data source is a database server. Do not select this option if the ODBC data source is a dBASE driver.</ahelp><comment>copie from shared\explorer\database\11020000.xhp</comment></paragraph> +<paragraph xml-lang="en-US" id="par_idN105FA" role="heading" level="2" l10n="NEW">Use the catalog name in SELECT statements</paragraph> + <paragraph xml-lang="en-US" id="par_idN105FE" role="paragraph" l10n="NEW"><ahelp hid=".">Uses the current data source of the catalog. This option is useful when the ODBC data source is a database server. Do not select this option if the ODBC data source is a dBASE driver.</ahelp><comment>copie from shared\explorer\database\11020000.xhp</comment></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DSADMIN_SCHEMA" id="bm_id7354655" localize="false"/> -<paragraph role="heading" id="par_idN10613" xml-lang="en-US" level="2" l10n="NEW">Use the schema name in SELECT statements</paragraph> -<paragraph role="paragraph" id="par_idN10617" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Allows you to use the schema name in SELECT statements.</ahelp><comment>UFI: ???</comment></paragraph> +<paragraph xml-lang="en-US" id="par_idN10613" role="heading" level="2" l10n="NEW">Use the schema name in SELECT statements</paragraph> + <paragraph xml-lang="en-US" id="par_idN10617" role="paragraph" l10n="NEW"><ahelp hid=".">Allows you to use the schema name in SELECT statements.</ahelp><comment>UFI: ???</comment></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DSADMIN_IGNOREINDEXAPPENDIX" id="bm_id321665" localize="false"/> -<paragraph role="heading" id="par_idN1061A" xml-lang="en-US" level="2" l10n="NEW">Create index with ASC or DESC statement</paragraph> -<paragraph role="paragraph" id="par_idN1061E" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Creates an index with ASC or DESC statements.</ahelp><comment>UFI: ???</comment></paragraph> +<paragraph xml-lang="en-US" id="par_idN1061A" role="heading" level="2" l10n="NEW">Create index with ASC or DESC statement</paragraph> + <paragraph xml-lang="en-US" id="par_idN1061E" role="paragraph" l10n="NEW"><ahelp hid=".">Creates an index with ASC or DESC statements.</ahelp><comment>UFI: ???</comment></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DSADMIN_BOOLEANCOMPARISON" id="bm_id5289773" localize="false"/> -<paragraph role="heading" id="par_idN10621" xml-lang="en-US" level="2" l10n="NEW">Comparison of Boolean values</paragraph> -<paragraph role="paragraph" id="par_idN10625" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select the type of Boolean comparison that you want to use.</ahelp><comment>UFI: ???</comment></paragraph> +<paragraph xml-lang="en-US" id="par_idN10621" role="heading" level="2" l10n="NEW">Comparison of Boolean values</paragraph> + <paragraph xml-lang="en-US" id="par_idN10625" role="paragraph" l10n="NEW"><ahelp hid=".">Select the type of Boolean comparison that you want to use.</ahelp><comment>UFI: ???</comment></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DSADMIN_CHECK_REQUIRED_FIELDS" id="bm_id4741355" localize="false"/> -<paragraph role="heading" id="hd_id1101718" xml-lang="en-US" level="2" l10n="NEW">Form data input checks for required fields<comment>i82291</comment></paragraph> -<paragraph role="paragraph" id="par_id3783989" xml-lang="en-US" l10n="NEW"><ahelp hid=".">When you enter a new record or update an existing record in a form, and you leave a field empty which is bound to a database column which requires input, then you will see a message complaining about the empty field.</ahelp></paragraph> -<paragraph role="paragraph" id="par_id6684163" xml-lang="en-US" l10n="NEW">If this control box is not enabled, then the forms in the current database will not be checked for required fields.</paragraph> -<paragraph role="paragraph" id="par_id3837397" xml-lang="en-US" l10n="NEW">The control box is available for all data source types which support write access to their data. The control box does not exist for spreadsheets, text, csv, and the various read-only address books.</paragraph> -<paragraph role="heading" id="hd_id0909200811170166" xml-lang="en-US" level="2" l10n="NEW">Ignore currency field information</paragraph> -<paragraph role="paragraph" id="par_id0909200811170221" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Only for Oracle JDBC connections. When enabled it specifies that no column is treated as a currency field. The field type returned from the database driver is discarded.</ahelp></paragraph> -</body> -</helpdocument> +<paragraph xml-lang="en-US" id="hd_id1101718" role="heading" level="2" l10n="NEW">Form data input checks for required fields<comment>i82291</comment></paragraph> + <paragraph xml-lang="en-US" id="par_id3783989" role="paragraph" l10n="NEW"><ahelp hid=".">When you enter a new record or update an existing record in a form, and you leave a field empty which is bound to a database column which requires input, then you will see a message complaining about the empty field.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="par_id6684163" role="paragraph" l10n="NEW">If this control box is not enabled, then the forms in the current database will not be checked for required fields.</paragraph> + <paragraph xml-lang="en-US" id="par_id3837397" role="paragraph" l10n="NEW">The control box is available for all data source types which support write access to their data. The control box does not exist for spreadsheets, text, csv, and the various read-only address books.</paragraph> + <paragraph xml-lang="en-US" id="hd_id0909200811170166" role="heading" level="2" l10n="NEW">Ignore currency field information</paragraph> + <paragraph xml-lang="en-US" id="par_id0909200811170221" role="paragraph" l10n="NEW"><ahelp hid=".">Only for Oracle JDBC connections. When enabled it specifies that no column is treated as a currency field. The field type returned from the database driver is discarded.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/39067" id="bm_id4841355" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id040920092139524" role="heading" level="2" l10n="NEW">Use ODBC conformant date/time literals</paragraph> + <paragraph xml-lang="en-US" id="par_id040920092139526" role="paragraph" l10n="NEW"><ahelp hid=".">Check to use ODBC conformant date/time literals.</ahelp></paragraph> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/shared/explorer/database/dabadoc.xhp b/helpcontent2/source/text/shared/explorer/database/dabadoc.xhp index dc2e256c0b..4b8457afd1 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabadoc.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabadoc.xhp @@ -1,7 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - -<!--*********************************************************************** +<helpdocument version="1.0"> + +<!-- +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -9,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: dabadoc.xhp,v $ - * $Revision: 1.7 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -29,26 +30,23 @@ * <http://www.openoffice.org/license.html> * for a copy of the LGPLv3 License. * - ************************************************************************--> + ************************************************************************ + --> + -<helpdocument version="1.0"> <meta> -<topic id="textsharedexplorerdatabasedabadocxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Database File</title> -<filename>/text/shared/explorer/database/dabadoc.xhp</filename> -</topic> -<history> -<created date="2004-07-28T12:47:12">UFI: the main database document window</created> -<lastedited date="2004-09-22T11:43:42">YJ: checked</lastedited> -</history> -</meta> -<body> -<section id="dabadoc"> -<paragraph role="heading" id="par_idN10544" xml-lang="en-US" level="1" l10n="NEW"><link href="text/shared/explorer/database/dabadoc.xhp">Database File</link></paragraph> -<paragraph role="paragraph" id="par_idN10554" xml-lang="en-US" l10n="NEW"><ahelp hid=".">The database file window organizes the tables, views, queries, links, and reports of a database in %PRODUCTNAME.</ahelp></paragraph> -</section> -<section id="relatedtopics"> -<paragraph role="paragraph" id="par_idN105B7" xml-lang="en-US" l10n="NEW"><link href="text/shared/explorer/database/main.xhp">Working with databases in %PRODUCTNAME</link></paragraph> -</section> -</body> -</helpdocument> + <topic id="textsharedexplorerdatabasedabadocxml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Database File</title> + <filename>/text/shared/explorer/database/dabadoc.xhp</filename> + </topic> + </meta> + <body> + <section id="dabadoc"> + <paragraph xml-lang="en-US" id="par_idN10544" role="heading" level="1" l10n="NEW"><link href="text/shared/explorer/database/dabadoc.xhp">Database File</link></paragraph> + <paragraph xml-lang="en-US" id="par_idN10554" role="paragraph" l10n="NEW"><ahelp hid=".">The database file window organizes the tables, views, queries, and reports of a database in %PRODUCTNAME.</ahelp></paragraph> + </section> + <section id="relatedtopics"> + <paragraph xml-lang="en-US" id="par_idN105B7" role="paragraph" l10n="NEW"><link href="text/shared/explorer/database/main.xhp">Working with databases in %PRODUCTNAME</link></paragraph> + </section> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/shared/explorer/database/rep_main.xhp b/helpcontent2/source/text/shared/explorer/database/rep_main.xhp index ee3e9162f4..e98a063af7 100644 --- a/helpcontent2/source/text/shared/explorer/database/rep_main.xhp +++ b/helpcontent2/source/text/shared/explorer/database/rep_main.xhp @@ -1,9 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -11,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: rep_main.xhp,v $ - * $Revision: 1.7 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -33,206 +32,222 @@ * ************************************************************************ --> - - - <helpdocument version="1.0"> + + <meta> -<topic id="textsharedexplorerdatabaserep_mainxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Report Builder</title> -<filename>/text/shared/explorer/database/rep_main.xhp</filename> -</topic> -</meta> -<body> + <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> -<paragraph role="heading" id="hd_id8773155" xml-lang="en-US" level="1" l10n="NEW"><variable id="rep_main"><link href="text/shared/explorer/database/rep_main.xhp">Report Builder</link> +<paragraph xml-lang="en-US" id="hd_id8773155" role="heading" level="1" l10n="NEW"><variable id="rep_main"><link href="text/shared/explorer/database/rep_main.xhp">Report Builder</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id5248573" xml-lang="en-US" l10n="NEW">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 role="note" id="par_id7128818" xml-lang="en-US" l10n="NEW">To use the Report Builder, the Report Builder extension must be installed. In addition, the Java Runtime Environment (JRE) software must be installed, and this software must be selected in %PRODUCTNAME.</paragraph> -<paragraph role="heading" id="hd_id3753776" xml-lang="en-US" level="2" l10n="NEW">To Install the Report Builder Extension</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="paragraph" id="par_id5284279" xml-lang="en-US" l10n="NEW">Choose Tools - Extension Manager to open the <link href="text/shared/01/packagemanager.xhp">Extension Manager</link>.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id4494766" xml-lang="en-US" l10n="NEW">Click the link "Get more extensions here". This opens your web browser at the address <link href="http://extensions.services.openoffice.org">http://extensions.services.openoffice.org</link> and shows a list of available extensions.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id7858516" xml-lang="en-US" l10n="NEW">Find the Sun Report Builder extension. Click at the icon or the "click here" text link. This opens the download page for the extension.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id973540" xml-lang="en-US" l10n="NEW">Click the "Get it!" icon. The file "sun-report-builder.oxt" will be downloaded to your computer.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id4680928" xml-lang="en-US" l10n="NEW">Switch back from your web browser to the %PRODUCTNAME window. The Extension Manager should still be visible.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id9014252" xml-lang="en-US" l10n="NEW">In the Extension Manager, click Add to open the Add extensions dialog.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id6011841" xml-lang="en-US" l10n="NEW">Select the "sun-report-builder.oxt" file that you downloaded. Click Open.</paragraph> -<paragraph role="paragraph" id="par_id2591326" xml-lang="en-US" l10n="NEW">This starts the installation of the Sun Report Builder extension.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id6201666" xml-lang="en-US" l10n="NEW">Read the license. If you accept the license, click Accept to continue the installation.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id208136" xml-lang="en-US" l10n="NEW">Click Close to close the Extension Manager.</paragraph> -</listitem> -</list> -<paragraph role="heading" id="hd_id556047" xml-lang="en-US" level="3" l10n="NEW">To install the JRE software</paragraph> -<paragraph role="paragraph" id="par_id4515823" xml-lang="en-US" l10n="NEW">The Report Builder requires an installed Java Runtime Environment (JRE).</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="paragraph" id="par_id4044312" xml-lang="en-US" l10n="NEW">Choose Tools - Options - %PRODUCTNAME - <link href="text/shared/optionen/java.xhp">Java</link>.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id1369060" xml-lang="en-US" l10n="NEW">Wait up to one minute, while %PRODUCTNAME collects information on installed Java software on your system.</paragraph> -<paragraph role="paragraph" id="par_id860927" xml-lang="en-US" l10n="NEW">If a recent JRE version is found on your system, you see an entry in the list.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id8581804" xml-lang="en-US" l10n="NEW">Click the option button in front of the entry to enable this JRE version for use in %PRODUCTNAME.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id7730033" xml-lang="en-US" l10n="NEW">Ensure that <emph>Use a Java runtime environment</emph> is enabled.</paragraph> -</listitem> -</list> -<paragraph role="paragraph" id="par_id6317636" xml-lang="en-US" l10n="NEW">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 Tools - Options - %PRODUCTNAME - Java again.</paragraph> -<paragraph role="heading" id="hd_id9759514" xml-lang="en-US" level="2" l10n="NEW">To open the Report Builder</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="paragraph" id="par_id9076509" xml-lang="en-US" l10n="NEW">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 role="paragraph" id="par_id7050691" xml-lang="en-US" l10n="NEW">Click the Reports icon in the Base window, then choose Create Report in Design View.</paragraph> -<paragraph role="paragraph" id="par_id7118747" xml-lang="en-US" l10n="NEW">The Report Builder window opens. </paragraph> -</listitem> -</list> -<paragraph role="paragraph" id="par_id8283639" xml-lang="en-US" l10n="NEW">The Report Builder is divided into three parts. On the top you see the menu, with the toolbars below.</paragraph> -<paragraph role="paragraph" id="par_id2291024" xml-lang="en-US" l10n="NEW">On the right you see the Properties window with the property values of the currently selected object.</paragraph> -<paragraph role="paragraph" id="par_id2100589" xml-lang="en-US" l10n="NEW">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="unordered"> -<listitem> -<paragraph role="paragraph" id="par_id5022125" xml-lang="en-US" l10n="NEW"> -<emph>Page Header</emph> - drag control fields with fixed text into the Page Header area</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id6844386" xml-lang="en-US" l10n="NEW"> -<emph>Detail</emph> - drag and drop database fields into the Detail area</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id7018646" xml-lang="en-US" l10n="NEW"> -<emph>Page Footer</emph> - drag control fields with fixed text into the Page Footer area</paragraph> -</listitem> -</list> -<paragraph role="paragraph" id="par_id5857112" xml-lang="en-US" l10n="NEW">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" l10n="NEW"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 role="paragraph" id="par_id6042664" xml-lang="en-US" l10n="NEW">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 role="paragraph" id="par_id1589098" xml-lang="en-US" l10n="NEW">You insert database fields by drag-and-drop into the Detail area. See the section "To insert fields into the report" below.</paragraph> -<paragraph role="paragraph" id="par_id1278420" xml-lang="en-US" l10n="NEW">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 role="heading" id="par_id7479476" xml-lang="en-US" level="2" l10n="NEW">To connect the report to a database table</paragraph> -<paragraph role="paragraph" id="par_id3099154" xml-lang="en-US" l10n="NEW">First you must connect the report to a database table.</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="paragraph" id="par_id2218390" xml-lang="en-US" l10n="NEW">Move the mouse to the Properties view. You see two tab pages General and Data.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id7771538" xml-lang="en-US" l10n="NEW">On the Data tab page, click Content to open the combo box.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id366527" xml-lang="en-US" l10n="NEW">Select the table for that you want to create the report.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id7996459" xml-lang="en-US" l10n="NEW">After selecting the table, press the <item type="keycode">Tab</item> key to leave the Content box.</paragraph> -</listitem> -</list> -<paragraph role="paragraph" id="par_id2531815" xml-lang="en-US" l10n="NEW">The Add Field window opens automatically and shows all fields of the selected table.</paragraph> -<paragraph role="heading" id="par_id5927304" xml-lang="en-US" level="2" l10n="NEW">To insert fields into the report</paragraph> -<paragraph role="paragraph" id="par_id4503921" xml-lang="en-US" l10n="NEW">The Add Field window helps you to insert the table entries in the report. Click the Add Field icon in the toolbar to open the Add Field window.</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="paragraph" id="par_id4051026" xml-lang="en-US" l10n="NEW">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 role="paragraph" id="par_id3397320" xml-lang="en-US" l10n="NEW">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 role="paragraph" id="par_id3059785" xml-lang="en-US" l10n="NEW">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="res/commandimagelist/sc_label.png" width="0.0902inch" height="0.0902inch" localize="true"><alt id="alt_id5605334" xml-lang="en-US">label field icon</alt> + <paragraph xml-lang="en-US" id="par_id5248573" role="paragraph" l10n="NEW">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" l10n="NEW">To use the Report Builder, the Report Builder extension 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_id3753776" role="heading" level="2" l10n="NEW">To Install the Report Builder Extension</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id5284279" role="paragraph" l10n="NEW">Choose Tools - Extension Manager to open the <link href="text/shared/01/packagemanager.xhp">Extension Manager</link>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id4494766" role="paragraph" l10n="NEW">Click the link "Get more extensions here". This opens your web browser at the address <link href="http://extensions.services.openoffice.org">http://extensions.services.openoffice.org</link> and shows a list of available extensions.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id7858516" role="paragraph" l10n="NEW">Find the Sun Report Builder extension. Click at the icon or the "click here" text link. This opens the download page for the extension.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id973540" role="paragraph" l10n="NEW">Click the "Get it!" icon. The file "sun-report-builder.oxt" will be downloaded to your computer.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id4680928" role="paragraph" l10n="NEW">Switch back from your web browser to the %PRODUCTNAME window. The Extension Manager should still be visible.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id9014252" role="paragraph" l10n="NEW">In the Extension Manager, click Add to open the Add extensions dialog.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id6011841" role="paragraph" l10n="NEW">Select the "sun-report-builder.oxt" file that you downloaded. Click Open.</paragraph> + <paragraph xml-lang="en-US" id="par_id2591326" role="paragraph" l10n="NEW">This starts the installation of the Sun Report Builder extension.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id6201666" role="paragraph" l10n="NEW">Read the license. If you accept the license, click Accept to continue the installation.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id208136" role="paragraph" l10n="NEW">Click Close to close the Extension Manager.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="hd_id556047" role="heading" level="2" l10n="NEW">To install the JRE software</paragraph> + <paragraph xml-lang="en-US" id="par_id4515823" role="paragraph" l10n="NEW">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" l10n="NEW">Choose Tools - Options - %PRODUCTNAME - <link href="text/shared/optionen/java.xhp">Java</link>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id1369060" role="paragraph" l10n="NEW">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" l10n="NEW">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" l10n="NEW">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" l10n="NEW">Ensure that <emph>Use a Java runtime environment</emph> is enabled.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_id6317636" role="paragraph" l10n="NEW">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 Tools - Options - %PRODUCTNAME - Java again.</paragraph> + <paragraph xml-lang="en-US" id="hd_id9759514" role="heading" level="2" l10n="NEW">To open the Report Builder</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id9076509" role="paragraph" l10n="NEW">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" l10n="NEW">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" l10n="NEW">The Report Builder window opens. </paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_id8283639" role="paragraph" l10n="NEW">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" l10n="NEW">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" l10n="NEW">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" l10n="NEW"> + <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" l10n="NEW"> + <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" l10n="NEW"> + <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" l10n="NEW">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" l10n="NEW"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" l10n="NEW">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" l10n="NEW">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" l10n="NEW">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" l10n="NEW">To connect the report to a database table</paragraph> + <paragraph xml-lang="en-US" id="par_id3099154" role="paragraph" l10n="NEW">First you must connect the report to a database table.</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id2218390" role="paragraph" l10n="NEW">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" l10n="NEW">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" l10n="NEW">Select the table for that you want to create the report.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id7996459" role="paragraph" l10n="NEW">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" l10n="NEW">The Add Field window opens automatically and shows all fields of the selected table.</paragraph> + <paragraph xml-lang="en-US" id="par_id5927304" role="heading" level="2" l10n="NEW">To insert fields into the report</paragraph> + <paragraph xml-lang="en-US" id="par_id4503921" role="paragraph" l10n="NEW">The Add Field window helps you to insert the table entries in the report. Click the Add Field icon in the toolbar to open the Add Field window.</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id4051026" role="paragraph" l10n="NEW">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" l10n="NEW">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" l10n="NEW">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="res/commandimagelist/sc_label.png" 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><comment>Align at Section toolbar</comment> -<bookmark xml-lang="en-US" branch="hid/.uno:SectionAlignLeft" id="bm_id7889950" localize="false"/><paragraph role="paragraph" id="par_id7657399" xml-lang="en-US" l10n="NEW"><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 role="paragraph" id="par_id8925138" xml-lang="en-US" l10n="NEW"><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 role="paragraph" id="par_id5461897" xml-lang="en-US" l10n="NEW"><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 role="paragraph" id="par_id8919339" xml-lang="en-US" l10n="NEW"><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 role="paragraph" id="par_id4634235" xml-lang="en-US" l10n="NEW"><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 role="paragraph" id="par_id1393475" xml-lang="en-US" l10n="NEW"><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 role="paragraph" id="par_id6571550" xml-lang="en-US" l10n="NEW"><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 role="paragraph" id="par_id5376140" xml-lang="en-US" l10n="NEW"><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 role="paragraph" id="par_id9611499" xml-lang="en-US" l10n="NEW"><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 role="paragraph" id="par_id6765953" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Inserts a vertical line to the current area.</ahelp></paragraph> -<paragraph role="paragraph" id="par_id1511581" xml-lang="en-US" l10n="NEW">After inserting fields in the Detail view, the report is ready for execution.</paragraph> -<paragraph role="heading" id="par_id4881740" xml-lang="en-US" level="2" l10n="NEW">To execute a report</paragraph> -<list type="unordered"> -<listitem> -<paragraph role="paragraph" id="par_id8286385" xml-lang="en-US" l10n="NEW">Click the Execute Report icon -<image id="img_id3380230" src="res/commandimagelist/sc_executereport.png" width="0.1665inch" height="0.1665inch"><alt id="alt_id3380230" xml-lang="en-US">execute report icon</alt> + </listitem> + </list><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW"><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" l10n="NEW">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" l10n="NEW">To execute a report</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id8286385" role="paragraph" l10n="NEW">Click the Execute Report icon +<image id="img_id3380230" src="res/commandimagelist/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 role="paragraph" id="par_id2354197" xml-lang="en-US" l10n="NEW">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 role="paragraph" id="par_id2485122" xml-lang="en-US" l10n="NEW">If the database contents did change, execute the report again to update the result report.<comment>automatic? message?</comment></paragraph> -<paragraph role="heading" id="hd_id8746910" xml-lang="en-US" level="2" l10n="NEW">To edit a report</paragraph> -<paragraph role="paragraph" id="par_id9636524" xml-lang="en-US" l10n="NEW">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 role="paragraph" id="par_id5941648" xml-lang="en-US" l10n="NEW">The Writer document is opened read-only. To edit the Writer document, click Edit File -<image id="img_id8237556" src="res/commandimagelist/sc_editdoc.png" width="0.222inch" height="0.222inch"><alt id="alt_id8237556" xml-lang="en-US">edit file icon</alt> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_id2354197" role="paragraph" l10n="NEW">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" l10n="NEW">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" l10n="NEW">To edit a report</paragraph> + <paragraph xml-lang="en-US" id="par_id9636524" role="paragraph" l10n="NEW">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" l10n="NEW">The Writer document is opened read-only. To edit the Writer document, click Edit File +<image id="img_id8237556" src="res/commandimagelist/sc_editdoc.png" width="0.566cm" height="0.566cm"><alt xml-lang="en-US" id="alt_id8237556">Icon</alt> </image> on the Standard toolbar.<comment>saved automatically with the Base file?</comment></paragraph> -<paragraph role="paragraph" id="par_id8307138" xml-lang="en-US" l10n="CHG">If you want to edit the Report Builder view, you can change some of its properties.</paragraph> -<paragraph role="paragraph" id="par_id7138889" xml-lang="en-US" l10n="NEW">Click in the Details area. Then in the Properties window, change some properties, for example the background color.</paragraph> -<paragraph role="paragraph" id="par_id9869380" xml-lang="en-US" l10n="NEW">After finishing, click the Execute Report icon -<image id="Graphic2" src="res/commandimagelist/sc_executereport.png" width="0.1665inch" height="0.1665inch"><alt id="alt_" xml-lang="en-US">execute report icon</alt> + <paragraph xml-lang="en-US" id="par_id8307138" role="paragraph" l10n="CHG">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" l10n="NEW">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" l10n="NEW">After finishing, click the Execute Report icon +<image id="Graphic2" src="res/commandimagelist/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 role="paragraph" id="par_id12512" xml-lang="en-US" l10n="NEW">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 role="heading" id="par_id2676168" xml-lang="en-US" level="2" l10n="NEW">Sorting the report</paragraph> -<paragraph role="paragraph" id="par_id2626422" xml-lang="en-US" l10n="NEW">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 role="paragraph" id="par_id1743827" xml-lang="en-US" l10n="NEW">Open the Report Builder view and click the Sorting and Grouping icon -<image id="img_id9557786" src="res/commandimagelist/sc_dbsortingandgrouping.png" width="0.1665inch" height="0.1665inch"><alt id="alt_id9557786" xml-lang="en-US">sorting and grouping icon</alt> + <paragraph xml-lang="en-US" id="par_id12512" role="paragraph" l10n="NEW">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" l10n="NEW">Sorting the report</paragraph> + <paragraph xml-lang="en-US" id="par_id2626422" role="paragraph" l10n="NEW">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" l10n="NEW">Open the Report Builder view and click the Sorting and Grouping icon +<image id="img_id9557786" src="res/commandimagelist/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 role="paragraph" id="par_id4331797" xml-lang="en-US" l10n="NEW">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 role="paragraph" id="par_id4191717" xml-lang="en-US" l10n="NEW">Execute the report.</paragraph> -</listitem> -</list> -<paragraph role="heading" id="par_id2318796" xml-lang="en-US" level="2" l10n="NEW">Grouping</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="paragraph" id="par_id399182" xml-lang="en-US" l10n="NEW">Open the Report Builder view and click the Sorting and Grouping icon -<image id="Graphic21" src="res/commandimagelist/sc_dbsortingandgrouping.png" width="0.1665inch" height="0.1665inch"><alt id="alt_" xml-lang="en-US">sorting and grouping icon</alt> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id4331797" role="paragraph" l10n="NEW">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" l10n="NEW">Execute the report.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_id2318796" role="heading" level="2" l10n="NEW">Grouping</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id399182" role="paragraph" l10n="NEW">Open the Report Builder view and click the Sorting and Grouping icon +<image id="Graphic21" src="res/commandimagelist/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 role="paragraph" id="par_id7588732" xml-lang="en-US" l10n="NEW">In the Groups box, open the Group Header list box and select to show a group header.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id95828" xml-lang="en-US" l10n="NEW">Click the Add Field icon -<image id="Graphic3" src="res/commandimagelist/sc_addfield.png" width="0.2201inch" height="0.2201inch"><alt id="alt_" xml-lang="en-US">add field icon</alt> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id7588732" role="paragraph" l10n="NEW">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" l10n="NEW">Click the Add Field icon +<image id="Graphic3" src="res/commandimagelist/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 role="paragraph" id="par_id5675527" xml-lang="en-US" l10n="NEW">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 role="paragraph" id="par_id3496200" xml-lang="en-US" l10n="NEW">Execute the report. The report shows the grouped records.</paragraph> -</listitem> -</list> -<paragraph role="paragraph" id="par_id7599108" xml-lang="en-US" l10n="NEW">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 role="heading" id="par_id888698" xml-lang="en-US" level="2" l10n="NEW">Updating and printing your data</paragraph> -<paragraph role="paragraph" id="par_id3394573" xml-lang="en-US" l10n="NEW">When you insert some new data or edit data in the table, a new report will show the updated data.</paragraph> -<paragraph role="paragraph" id="par_id7594225" xml-lang="en-US" l10n="NEW">Click the Reports icon -<image id="img_id4678487" src="dbaccess/res/reports_32.png" width="0.222inch" height="0.222inch"><alt id="alt_id4678487" xml-lang="en-US">reports icon</alt> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id5675527" role="paragraph" l10n="NEW">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" l10n="NEW">Execute the report. The report shows the grouped records.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_id7599108" role="paragraph" l10n="NEW">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" l10n="NEW">Updating and printing your data</paragraph> + <paragraph xml-lang="en-US" id="par_id3394573" role="paragraph" l10n="NEW">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" l10n="NEW">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 role="paragraph" id="par_id8147221" xml-lang="en-US" l10n="NEW">To print a report, choose <item type="menuitem">File - Print</item> from the Writer document.</paragraph> -</body> -</helpdocument> + <paragraph xml-lang="en-US" id="par_id8147221" role="paragraph" l10n="NEW">To print a report, choose <item type="menuitem">File - Print</item> from the Writer document.</paragraph> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/shared/explorer/database/rep_sort.xhp b/helpcontent2/source/text/shared/explorer/database/rep_sort.xhp index 39edac3b06..8dde7a43e9 100644 --- a/helpcontent2/source/text/shared/explorer/database/rep_sort.xhp +++ b/helpcontent2/source/text/shared/explorer/database/rep_sort.xhp @@ -1,9 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -11,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: rep_sort.xhp,v $ - * $Revision: 1.5 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -33,56 +32,70 @@ * ************************************************************************ --> - - - <helpdocument version="1.0"> + + <meta> -<topic id="textsharedexplorerdatabaserep_sortxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">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"/><paragraph role="heading" id="hd_id3486434" xml-lang="en-US" level="1" l10n="NEW"><variable id="rep_sort"><link href="text/shared/explorer/database/rep_sort.xhp">Sorting and Grouping</link> + <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"/> +<paragraph xml-lang="en-US" id="hd_id3486434" role="heading" level="1" l10n="NEW"><variable id="rep_sort"><link href="text/shared/explorer/database/rep_sort.xhp">Sorting and Grouping</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3068636" xml-lang="en-US" l10n="NEW"><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 role="paragraph" id="par_id876186" xml-lang="en-US" l10n="NEW">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 role="paragraph" id="par_id3939634" xml-lang="en-US" l10n="NEW">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/64463" id="bm_id2480849" localize="false"/><paragraph role="paragraph" id="par_id599688" xml-lang="en-US" l10n="NEW"><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/64461" id="bm_id4181951" localize="false"/><paragraph role="paragraph" id="par_id1371501" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Click to open a list from which you can select a field.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/2114727444" id="bm_id2927335" localize="false"/><paragraph role="paragraph" id="par_id4661702" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Moves the selected field up in the list.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/2114727445" id="bm_id2107303" localize="false"/><paragraph role="paragraph" id="par_id7868892" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Moves the selected field down in the list.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/2114719249" id="bm_id4071779" localize="false"/><paragraph role="paragraph" id="par_id2188787" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Select the sorting order.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/2114719234" id="bm_id7844477" localize="false"/><paragraph role="paragraph" id="par_id5833307" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Select to show or hide the Group Header.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/2114719236" id="bm_id6478469" localize="false"/><paragraph role="paragraph" id="par_id7726676" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Select to show or hide the Group Footer.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/2114719238" id="bm_id9038972" localize="false"/><paragraph role="paragraph" id="par_id3729361" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Select to create a new group on each changed value, or on other properties.</ahelp></paragraph> -<paragraph role="paragraph" id="par_id3405560" xml-lang="en-US" l10n="NEW">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="unordered"> -<listitem> -<paragraph role="paragraph" id="par_id3409527" xml-lang="en-US" l10n="NEW">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 role="paragraph" id="par_id7112338" xml-lang="en-US" l10n="NEW">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 role="paragraph" id="par_id2855616" xml-lang="en-US" l10n="NEW">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/2114721800" id="bm_id7985168" localize="false"/><paragraph role="paragraph" id="par_id7700430" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter the group interval value that records are grouped by.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/21147219242" id="bm_id9573961" localize="false"/><paragraph role="paragraph" id="par_id1180455" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Select the level of detail by which a group is kept together on the same page.</ahelp></paragraph> -<paragraph role="paragraph" id="par_id2091433" xml-lang="en-US" l10n="NEW">When you specify to keep together some records on the same page, you have three choices:</paragraph> -<list type="unordered"> -<listitem> -<paragraph role="paragraph" id="par_id5092318" xml-lang="en-US" l10n="NEW">No - page boundaries are not taken into account.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id9312417" xml-lang="en-US" l10n="NEW">Whole Group - prints the group header, detail section, and group footer on the same page.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id9089022" xml-lang="en-US" l10n="NEW">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> + <paragraph xml-lang="en-US" id="par_id3068636" role="paragraph" l10n="NEW"><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" l10n="NEW">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" l10n="NEW">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/64463" id="bm_id2480849" localize="false"/> +<paragraph xml-lang="en-US" id="par_id599688" role="paragraph" l10n="NEW"><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/64461" id="bm_id4181951" localize="false"/> +<paragraph xml-lang="en-US" id="par_id1371501" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Click to open a list from which you can select a field.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/2114727444" id="bm_id2927335" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/HID_RPT_GROUPSORT_MOVE_UP" id="bm_id2927436" localize="false"/> +<paragraph xml-lang="en-US" id="par_id4661702" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Moves the selected field up in the list.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/2114727445" id="bm_id2107303" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/HID_RPT_GROUPSORT_MOVE_DOWN" id="bm_id2107304" localize="false"/> +<paragraph xml-lang="en-US" id="par_id7868892" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Moves the selected field down in the list.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/2114719249" id="bm_id4071779" localize="false"/> +<paragraph xml-lang="en-US" id="par_id2188787" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Select the sorting order.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/2114719234" id="bm_id7844477" localize="false"/> +<paragraph xml-lang="en-US" id="par_id5833307" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Select to show or hide the Group Header.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/2114719236" id="bm_id6478469" localize="false"/> +<paragraph xml-lang="en-US" id="par_id7726676" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Select to show or hide the Group Footer.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/2114719238" id="bm_id9038972" localize="false"/> +<paragraph xml-lang="en-US" id="par_id3729361" role="paragraph" l10n="NEW"><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/HID_RPT_GROUPSORT_DELETE" id="bm_id9038973" localize="false"/> +<paragraph xml-lang="en-US" id="par_id0409200922142041" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Removes the selected field from the list.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="par_id3405560" role="paragraph" l10n="NEW">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" l10n="NEW">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" l10n="NEW">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" l10n="NEW">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/2114721800" id="bm_id7985168" localize="false"/> +<paragraph xml-lang="en-US" id="par_id7700430" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Enter the group interval value that records are grouped by.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/reportdesign:ListBox:RID_GROUPS_SORTING:LST_KEEPTOGETHERLST" id="bm_id9573961" localize="false"/> +<paragraph xml-lang="en-US" id="par_id1180455" role="paragraph" l10n="NEW"><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" l10n="NEW">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" l10n="NEW">No - page boundaries are not taken into account.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id9312417" role="paragraph" l10n="NEW">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" l10n="NEW">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>
\ No newline at end of file |