1<?xml version="1.0" encoding="UTF-8"?> 2 3 4 5<!-- 6 *********************************************************************** 7 * 8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 9 * 10 * Copyright 2000, 2010 Oracle and/or its affiliates. 11 * 12 * OpenOffice.org - a multi-platform office productivity suite 13 * 14 * This file is part of OpenOffice.org. 15 * 16 * OpenOffice.org is free software: you can redistribute it and/or modify 17 * it under the terms of the GNU Lesser General Public License version 3 18 * only, as published by the Free Software Foundation. 19 * 20 * OpenOffice.org is distributed in the hope that it will be useful, 21 * but WITHOUT ANY WARRANTY; without even the implied warranty of 22 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 23 * GNU Lesser General Public License version 3 for more details 24 * (a copy is included in the LICENSE file that accompanied this code). 25 * 26 * You should have received a copy of the GNU Lesser General Public License 27 * version 3 along with OpenOffice.org. If not, see 28 * <http://www.openoffice.org/license.html> 29 * for a copy of the LGPLv3 License. 30 * 31 ************************************************************************ 32 --> 33 34 35 <helpdocument version="1.0"> 36<meta> 37<topic id="textsharedguidedata_reportxml" indexer="include" status="PUBLISH"> 38<title id="tit" xml-lang="en-US">Using and Editing Database Reports </title> 39<filename>/text/shared/guide/data_report.xhp</filename> 40</topic> 41</meta> 42<body> 43<bookmark xml-lang="en-US" branch="index" id="bm_id3147834"><bookmark_value>database reports</bookmark_value> 44<bookmark_value>data sources;reports</bookmark_value> 45<bookmark_value>reports;opening and editing</bookmark_value> 46<bookmark_value>editing;reports</bookmark_value> 47<bookmark_value>opening;reports</bookmark_value> 48<bookmark_value>templates;database reports</bookmark_value> 49<bookmark_value>reports;templates</bookmark_value> 50</bookmark> 51<paragraph role="paragraph" id="par_id3147834" xml-lang="en-US" l10n="E" oldref="29" localize="false"/> 52<paragraph role="heading" id="hd_id3149178" xml-lang="en-US" level="1" l10n="CHG" oldref="1"><variable id="data_report"><link href="text/shared/guide/data_report.xhp" name="Create, Use, and Edit Database Reports">Using and Editing Database Reports</link> 53</variable></paragraph> 54<paragraph role="heading" id="hd_id3145609" xml-lang="en-US" level="2" l10n="CHG" oldref="13">Using a Report</paragraph> 55<paragraph role="paragraph" id="par_id3147265" xml-lang="en-US" l10n="CHG" oldref="14">%PRODUCTNAME stores the information about the created reports in the database file.</paragraph> 56<list type="ordered"> 57<listitem> 58<paragraph role="listitem" id="par_id3154758" xml-lang="en-US" l10n="CHG" oldref="15">Choose <emph>File - Open</emph> and select the database file.</paragraph> 59</listitem> 60<listitem> 61<paragraph role="listitem" id="par_id3151054" xml-lang="en-US" l10n="CHG" oldref="16">In the database file window, click the <emph>Reports</emph> icon.</paragraph> 62</listitem> 63<listitem> 64<paragraph role="listitem" id="par_id3156280" xml-lang="en-US" l10n="CHG" oldref="18">Double-click one of the report names to open the report.</paragraph> 65<paragraph role="note" id="par_idN1077D" xml-lang="en-US" l10n="CHG">These links are added automatically when you create a new report by the Report Wizard or in the Report Builder window.</paragraph> 66</listitem> 67</list> 68<paragraph role="heading" id="hd_id1695608" xml-lang="en-US" level="2" l10n="NEW">Editing a Report Created in the Report Builder Window</paragraph> 69<list type="unordered"> 70<listitem> 71<paragraph role="paragraph" id="par_id7510910" xml-lang="en-US" l10n="NEW">Right-click the name of a report in the database file window, then choose Edit.</paragraph> 72</listitem> 73</list> 74<paragraph role="paragraph" id="par_id8138065" xml-lang="en-US" l10n="NEW">The Report Builder window opens with the report's information loaded. </paragraph> 75<paragraph role="paragraph" id="par_id5086825" xml-lang="en-US" l10n="NEW">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> 76<paragraph role="paragraph" id="par_id4747154" xml-lang="en-US" l10n="NEW">Execute the report to see the resulting report document.</paragraph> 77<paragraph role="heading" id="hd_id3153104" xml-lang="en-US" level="2" l10n="CHG" oldref="19">Editing a Report Created by the Report Wizard</paragraph> 78<list type="unordered"> 79<listitem> 80<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 you use the report.</paragraph> 81</listitem> 82</list> 83<paragraph role="paragraph" id="par_id3155431" xml-lang="en-US" l10n="U" oldref="22">You can edit the page styles for the first page and the following pages of the report as well as the paragraph styles, the number formats, the printed field labels, and more.</paragraph> 84<paragraph role="warning" id="par_idN107D7" xml-lang="en-US" l10n="NEW">Unless you have a thorough understanding of the database the report accesses, do not edit the SQL statement, database name, the hidden form controls, or the related information on the report.</paragraph> 85<embed href="text/shared/00/00000004.xhp#related"/> 86<embed href="text/shared/guide/database_main.xhp#database_main"/> 87</body> 88</helpdocument> 89