1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2008 by Sun Microsystems, Inc.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: soffice2xmlhelp.xsl,v $
* $Revision: 1.8 $
*
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 3
* only, as published by the Free Software Foundation.
*
* OpenOffice.org 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 version 3 for more details
* (a copy is included in the LICENSE file that accompanied this code).
*
* You should have received a copy of the GNU Lesser General Public License
* version 3 along with OpenOffice.org. If not, see
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************
-->
<meta>
<topic id="textsharedexplorerdatabaserep_sortxml" indexer="include" status="PUBLISH">
<title xml-lang="en-US" id="tit">Sorting and Grouping</title>
<filename>/text/shared/explorer/database/rep_sort.xhp</filename>
</topic>
</meta>
<body>
<section id="sort">
<bookmark xml-lang="en-US" branch="hid/.uno:DbSortingAndGrouping" id="bm_id9569078" localize="false"/>
<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 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>
|
