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
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
***********************************************************************
*
* 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: rep_sort.xhp,v $
* $Revision: 1.4 $
*
* 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.
*
************************************************************************
-->
<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>
</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>
|
