summaryrefslogtreecommitdiff
path: root/helpcontent2/source/text/shared/guide/data_report.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'helpcontent2/source/text/shared/guide/data_report.xhp')
-rwxr-xr-xhelpcontent2/source/text/shared/guide/data_report.xhp151
1 files changed, 151 insertions, 0 deletions
diff --git a/helpcontent2/source/text/shared/guide/data_report.xhp b/helpcontent2/source/text/shared/guide/data_report.xhp
new file mode 100755
index 0000000000..9d2b0d3fbb
--- /dev/null
+++ b/helpcontent2/source/text/shared/guide/data_report.xhp
@@ -0,0 +1,151 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--***********************************************************************
+ *
+ * The Contents of this file are made available subject to the terms of
+ * either of the following licenses
+ *
+ * - GNU Lesser General Public License Version 2.1
+ * - Sun Industry Standards Source License Version 1.1
+ *
+ * Sun Microsystems Inc., October, 2000
+ *
+ * GNU Lesser General Public License Version 2.1
+ * =============================================
+ * Copyright 2000 by Sun Microsystems, Inc.
+ * 901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License version 2.1, as published by the Free Software Foundation.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ * MA 02111-1307 USA
+ *
+ *
+ * Sun Industry Standards Source License Version 1.1
+ * =================================================
+ * The contents of this file are subject to the Sun Industry Standards
+ * Source License Version 1.1 (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.openoffice.org/license.html.
+ *
+ * Software provided under this License is provided on an "AS IS" basis,
+ * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
+ * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ * See the License for the specific provisions governing your rights and
+ * obligations concerning the Software.
+ *
+ * The Initial Developer of the Original Code is: Sun Microsystems, Inc..
+ *
+ * Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ * All Rights Reserved.
+ *
+ * Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************-->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="textsharedguidedata_reportxml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Create, Use, and Edit Database Reports</title>
+<filename>/text/shared/guide/data_report.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+<lastedited date="2004-07-26T11:32:36">converted from old format - fpe</lastedited>
+</history>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3147834"><bookmark_value>database reports</bookmark_value>
+<bookmark_value>reports; creating database reports</bookmark_value>
+<bookmark_value>data sources;reports</bookmark_value>
+<bookmark_value>designing;database reports</bookmark_value>
+</bookmark>
+<paragraph role="paragraph" id="par_id3147834" xml-lang="en-US" l10n="E" oldref="29" localize="false"/>
+<paragraph role="heading" id="hd_id3149178" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="data_report"><link href="text/shared/guide/data_report.xhp" name="Create, Use, and Edit Database Reports">Create, Use, and Edit Database Reports</link>
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3145313" xml-lang="en-US" l10n="U" oldref="2">The <emph>Report Wizard</emph> guides you through all necessary steps to create reports on your database tables or queries. The <emph>Report Wizard</emph> offers a sequence of dialogs, and in accordance to your selections in those dialogs, the report is built and filled with data.</paragraph>
+<paragraph role="heading" id="hd_id3148539" xml-lang="en-US" level="2" l10n="U" oldref="3">Create a Report With the Wizard</paragraph>
+<list type="unordered">
+<listitem>
+<paragraph role="listitem" id="par_id3166410" xml-lang="en-US" l10n="U" oldref="4">Call the Report Wizard with the menu <emph>File - Wizard - Report</emph>.</paragraph>
+</listitem>
+</list>
+<paragraph role="paragraph" id="par_id3158430" xml-lang="en-US" l10n="U" oldref="5">These are the main steps performed by the <link href="text/shared/autopi/01100000.xhp" name="Report AutoPilot">Report Wizard</link>:</paragraph>
+<list type="ordered">
+<listitem>
+<paragraph role="listitem" id="par_id3149514" xml-lang="en-US" l10n="U" oldref="6">Select the database and the table or query</paragraph>
+</listitem>
+<listitem>
+<paragraph role="listitem" id="par_id3154142" xml-lang="en-US" l10n="U" oldref="7">Edit the names that are printed for the database fields, if required</paragraph>
+</listitem>
+<listitem>
+<paragraph role="listitem" id="par_id3150276" xml-lang="en-US" l10n="U" oldref="8">Choose how to group and sort the database fields</paragraph>
+</listitem>
+<listitem>
+<paragraph role="listitem" id="par_id3155388" xml-lang="en-US" l10n="U" oldref="9">Choose a layout from one of the supplied templates</paragraph>
+</listitem>
+<listitem>
+<paragraph role="listitem" id="par_id3149784" xml-lang="en-US" l10n="U" oldref="10">The report will be created either as a template or as a static report:</paragraph>
+<paragraph role="listitem" id="par_id3153087" xml-lang="en-US" l10n="U" oldref="11">A report template can be re-used any time with the then current data.</paragraph>
+<paragraph role="listitem" id="par_id3144510" xml-lang="en-US" l10n="U" oldref="12">A static report is a snapshot of the data at the time of creation of the report.</paragraph>
+</listitem>
+</list>
+<paragraph role="heading" id="hd_id3145609" xml-lang="en-US" level="2" l10n="U" oldref="13">Use a Report</paragraph>
+<paragraph role="paragraph" id="par_id3147265" xml-lang="en-US" l10n="U" oldref="14">The report templates can be opened any time from the database explorer:</paragraph>
+<list type="ordered">
+<listitem>
+<paragraph role="listitem" id="par_id3154758" xml-lang="en-US" l10n="U" oldref="15">Press F4 to open the <link href="text/shared/guide/database_main.xhp" name="data source view">data source view</link>.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="listitem" id="par_id3151054" xml-lang="en-US" l10n="U" oldref="16">In the data source explorer, click the "+" icon left of a database name to display the database components.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="listitem" id="par_id3153381" xml-lang="en-US" l10n="U" oldref="17">Click the "+" icon left of the <emph>Links</emph> entry to display the links.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="listitem" id="par_id3156280" xml-lang="en-US" l10n="U" oldref="18">Double-click one of the report links to open the report as a new $[officename] Writer document. These links have been added to the <emph>Links</emph> entry automatically by the Report Wizard.</paragraph>
+</listitem>
+</list>
+<paragraph role="heading" id="hd_id3153104" xml-lang="en-US" level="2" l10n="U" oldref="19">Edit a Report</paragraph>
+<list type="unordered">
+<listitem>
+<paragraph role="listitem" id="par_id3125863" xml-lang="en-US" l10n="U" oldref="20">On the <link href="text/shared/autopi/01100500.xhp" name="last dialog page of the Report AutoPilot">last dialog page of the Report Wizard</link>, you can choose to edit the report template before first use.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="listitem" id="par_id3150868" xml-lang="en-US" l10n="U" oldref="21">Later on, you can edit any report template from its context menu under the <emph>Link</emph> entry in the <link href="text/shared/guide/database_main.xhp" name="data source view">data source view</link>.</paragraph>
+</listitem>
+</list>
+<paragraph role="paragraph" id="par_id3155431" xml-lang="en-US" l10n="U" oldref="22">Feel free to edit the page styles for the first page and the following pages, the paragraph styles, the number formats, the printed field labels, and more. However, you should not edit the report's SQL statement, database name, the hidden form controls, and related information, unless you have a thorough understanding of the database technology in use.</paragraph>
+<paragraph role="heading" id="hd_id3147288" xml-lang="en-US" level="3" l10n="U" oldref="23">To edit the column width for a column in the report:</paragraph>
+<list type="ordered">
+<listitem>
+<paragraph role="listitem" id="par_id3154985" xml-lang="en-US" l10n="U" oldref="24">Open the report template in edit mode (see the previous section about how to edit a report template).</paragraph>
+</listitem>
+<listitem>
+<paragraph role="listitem" id="par_id3147213" xml-lang="en-US" l10n="U" oldref="25">Click into the main table area, where the data fields' contents will be filled in later.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="listitem" id="par_id3154918" xml-lang="en-US" l10n="U" oldref="26">Open the context menu and choose the <emph>Table</emph> command.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="listitem" id="par_id3155366" xml-lang="en-US" l10n="U" oldref="27">In the next dialog, select the <emph>Columns</emph> tab page and edit the column width. Close the dialog with <emph>OK</emph>.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="listitem" id="par_id3159154" xml-lang="en-US" l10n="U" oldref="28">Save the template by clicking the <emph>Save Document</emph> icon.</paragraph>
+</listitem>
+</list>
+<embed href="text/shared/00/00000004.xhp#related"/>
+<embed href="text/shared/guide/database_main.xhp#database_main"/>
+</body>
+</helpdocument>