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_reportsxhp" indexer="include" status="PUBLISH"> 38<title id="tit" xml-lang="en-US">Creating Reports </title> 39<filename>/text/shared/guide/data_reports.xhp</filename> 40</topic> 41</meta> 42<body> 43<bookmark xml-lang="en-US" branch="index" id="bm_id3729667"><bookmark_value>databases;creating reports</bookmark_value> 44<bookmark_value>reports;creating</bookmark_value> 45<bookmark_value>wizards;reports</bookmark_value> 46</bookmark> 47<paragraph role="heading" id="par_idN105A3" xml-lang="en-US" level="1" l10n="CHG"><variable id="data_reports"><link href="text/shared/guide/data_reports.xhp">Creating Reports</link> 48</variable></paragraph> 49<paragraph role="paragraph" id="par_idN105C1" xml-lang="en-US" l10n="CHG">A report is a Writer text document that can show your data in an organized order and formatting. In %PRODUCTNAME Base, you have a choice to create a report either manually using drag-and-drop in the Report Builder window, or semi-automatic by following a series of dialogs in the Report Wizard. </paragraph> 50<paragraph role="paragraph" id="par_id4094363" xml-lang="en-US" l10n="NEW">The following list gives you some information to decide which method to use for your data:</paragraph> 51<table id="tbl_id1888180"> 52<tablerow> 53<tablecell colspan="" rowspan=""> 54<paragraph role="tablehead" id="par_id8514358" xml-lang="en-US" l10n="NEW">Report Builder</paragraph> 55</tablecell> 56<tablecell colspan="" rowspan=""> 57<paragraph role="tablehead" id="par_id9764091" xml-lang="en-US" l10n="NEW">Report Wizard</paragraph> 58</tablecell> 59</tablerow> 60<tablerow> 61<tablecell colspan="" rowspan=""> 62<paragraph role="tablecontent" id="par_id1579638" xml-lang="en-US" l10n="NEW">Started by "Create Report in Design View" command.</paragraph> 63</tablecell> 64<tablecell colspan="" rowspan=""> 65<paragraph role="tablecontent" id="par_id1886959" xml-lang="en-US" l10n="NEW">Started by "Use Wizard to Create Report" command.</paragraph> 66</tablecell> 67</tablerow> 68<tablerow> 69<tablecell colspan="" rowspan=""> 70<paragraph role="tablecontent" id="par_id455030" xml-lang="en-US" l10n="NEW">Full flexibility to use report headers and footers, page headers and footers, multi-column reports.</paragraph> 71</tablecell> 72<tablecell colspan="" rowspan=""> 73<paragraph role="tablecontent" id="par_id8409985" xml-lang="en-US" l10n="NEW">Uses a Writer template to generate a report document.</paragraph> 74</tablecell> 75</tablerow> 76<tablerow> 77<tablecell colspan="" rowspan=""> 78<paragraph role="tablecontent" id="par_id5931272" xml-lang="en-US" l10n="NEW">Use drag-and-drop to position the record fields or other design elements like pictures or lines.</paragraph> 79</tablecell> 80<tablecell colspan="" rowspan=""> 81<paragraph role="tablecontent" id="par_id9869075" xml-lang="en-US" l10n="NEW">Select from several given choices to arrange the data records.</paragraph> 82</tablecell> 83</tablerow> 84<tablerow> 85<tablecell colspan="" rowspan=""> 86<paragraph role="tablecontent" id="par_id8611713" xml-lang="en-US" l10n="NEW">Generates a one-time snapshot of the data. To see an updated report, execute the same report again to create a Writer document with the updated data.</paragraph> 87</tablecell> 88<tablecell colspan="" rowspan=""> 89<paragraph role="tablecontent" id="par_id2866908" xml-lang="en-US" l10n="NEW">You can choose to generate a one-time snapshot with fixed data, or a "live" report with links to the current data at the time when you open the Base file.</paragraph> 90</tablecell> 91</tablerow> 92<tablerow> 93<tablecell colspan="" rowspan=""> 94<paragraph role="tablecontent" id="par_id4169743" xml-lang="en-US" l10n="NEW">Saves the report as a Writer text document. Stores the information how to create the report inside the Base file.</paragraph> 95</tablecell> 96<tablecell colspan="" rowspan=""> 97<paragraph role="tablecontent" id="par_id408948" xml-lang="en-US" l10n="NEW">Saves the report and the information how to create the report inside the Base file.</paragraph> 98</tablecell> 99</tablerow> 100<tablerow> 101<tablecell colspan="" rowspan=""> 102<paragraph role="tablecontent" id="par_id2891933" xml-lang="en-US" l10n="NEW">Choose Open in the context menu or double-click the report name to create a new report with the current data.</paragraph> 103</tablecell> 104<tablecell colspan="" rowspan=""> 105<paragraph role="tablecontent" id="par_id6142765" xml-lang="en-US" l10n="NEW">Choose Open in the context menu or double-click the report name to either see again the static snapshot of the data from first creation time, or to create a new report with the current data. This depends on your choice on the last page of the wizard.</paragraph> 106</tablecell> 107</tablerow> 108<tablerow> 109<tablecell colspan="" rowspan=""> 110<paragraph role="tablecontent" id="par_id1757560" xml-lang="en-US" l10n="NEW">Choose Edit in the context menu of a report name to open the Report Builder window, with the report's information loaded.</paragraph> 111</tablecell> 112<tablecell colspan="" rowspan=""> 113<paragraph role="tablecontent" id="par_id4649189" xml-lang="en-US" l10n="NEW">Choose Edit in the context menu of a report name to edit the Writer template file that was used to create the report.</paragraph> 114</tablecell> 115</tablerow> 116</table> 117<paragraph role="heading" id="hd_id8414258" xml-lang="en-US" level="2" l10n="NEW">Creating a New Report Manually In Design View</paragraph> 118<list type="ordered"> 119<listitem> 120<paragraph role="paragraph" id="par_id3119602" xml-lang="en-US" l10n="NEW">Open the database file where you want to create the new report.</paragraph> 121</listitem> 122<listitem> 123<paragraph role="paragraph" id="par_id4226508" xml-lang="en-US" l10n="NEW">In the left pane of the database window, click the <emph>Reports</emph> icon.</paragraph> 124</listitem> 125<listitem> 126<paragraph role="paragraph" id="par_id5758842" xml-lang="en-US" l10n="NEW">Click <emph>Create Report in Design View</emph>.</paragraph> 127</listitem> 128<listitem> 129<paragraph role="paragraph" id="par_id4870754" xml-lang="en-US" l10n="NEW">Follow the instructions in the <link href="text/shared/explorer/database/rep_main.xhp">Report Builder</link> guide.</paragraph> 130</listitem> 131</list> 132<paragraph role="heading" id="par_idN105C4" xml-lang="en-US" level="2" l10n="NEW">Creating a New Report With the Report Wizard</paragraph> 133<list type="ordered"> 134<listitem> 135<paragraph role="paragraph" id="par_idN105DC" xml-lang="en-US" l10n="NEW">Open the database file where you want to create the new report.</paragraph> 136</listitem> 137<listitem> 138<paragraph role="paragraph" id="par_idN105E0" xml-lang="en-US" l10n="NEW">In the left pane of the database window, click the <emph>Reports</emph> icon.</paragraph> 139</listitem> 140<listitem> 141<paragraph role="paragraph" id="par_idN105E8" xml-lang="en-US" l10n="NEW">Click <emph>Use Wizard to Create Report</emph>.</paragraph> 142</listitem> 143<listitem> 144<paragraph role="paragraph" id="par_id8032166" xml-lang="en-US" l10n="NEW">Follow the steps of the <link href="text/shared/autopi/01100000.xhp">Report Wizard</link> to create the report.</paragraph> 145</listitem> 146</list> 147<section id="relatedtopics"> 148<embed href="text/shared/guide/data_report.xhp#data_report"/> 149<embed href="text/shared/explorer/database/main.xhp#base"/> 150<embed href="text/shared/guide/database_main.xhp#database_main"/> 151</section> 152</body> 153</helpdocument> 154