<?xml version="1.0" encoding="UTF-8"?>
<structure version="16" html-doctype="HTML4 Transitional" compatibility-view="IE9" relativeto="*SPS" encodinghtml="UTF-8" encodingrtf="ISO-8859-1" encodingpdf="UTF-8" useimportschema="1" embed-images="1" pastemode="xml" enable-authentic-scripts="1" authentic-scripts-in-debug-mode-external="0" generated-file-location="DEFAULT">
	<parameters/>
	<schemasources>
		<namespaces/>
		<schemasources>
			<xsdschemasource name="XML" main="1" schemafile="Persons.xsd" workingxmlfile="Persons.xml"/>
		</schemasources>
	</schemasources>
	<modules/>
	<flags>
		<scripts/>
		<mainparts/>
		<globalparts/>
		<designfragments/>
		<pagelayouts/>
		<xpath-functions/>
	</flags>
	<scripts>
		<script language="javascript"/>
	</scripts>
	<script-project>
		<Project version="2" app="AuthenticView"/>
	</script-project>
	<importedxslt/>
	<globalstyles/>
	<mainparts>
		<children>
			<globaltemplate subtype="main" match="/">
				<document-properties/>
				<children>
					<documentsection>
						<properties columncount="1" columngap="48px" headerfooterheight="variable" pagemultiplepages="0" pagenumberingformat="1" pagenumberingstartat="auto" pagestart="next" paperheight="11.69in" papermarginbottom="0.79in" papermarginfooter="0.0in" papermarginheader="0.0in" papermarginleft="0.6in" papermarginright="0.6in" papermargintop="0.79in" paperwidth="8.27in"/>
						<watermark>
							<image transparency="50" fill-page="1" center-if-not-fill="1"/>
							<text transparency="50"/>
						</watermark>
					</documentsection>
					<template subtype="source" match="XML">
						<children>
							<newline/>
							<paragraph>
								<styles color="#003d80" font-family="Arial" font-size="16pt" font-weight="bold" padding-bottom="0.25em" padding-top="0.25em"/>
								<children>
									<text fixtext="Grouping 1: By Department and Grade"/>
								</children>
							</paragraph>
							<paragraph>
								<styles font-style="italic" margin-top="0.4em"/>
								<children>
									<text fixtext="In Grouping 1, employees are grouped first by department, and then by grade. Both sets of groups (departments and grades) are sorted alphabetically in ascending order. Within a grade, employees are sorted alphabetically, in ascending order, on their last names. "/>
								</children>
							</paragraph>
							<paragraph>
								<styles font-style="italic" margin-top="0.5em"/>
								<children>
									<text fixtext="To group on departments, on the Person element, a Group-By grouping is created with a grouping-key that is the &apos;department&apos; attribute. This group is created as a table so that each group (department) is in a separate table. On the group that is created in this way (the current-group), another group is created, this time with a grouping-key that is the &apos;grade&apos; attribute. This sub-group (that is, each grade within a department) is color-coded and sorted on the &apos;last&apos; attribute so that within each grade, employees are listed in alphabetically ascending order."/>
								</children>
							</paragraph>
							<newline/>
							<paragraph>
								<styles font-family="Arial" font-size="11pt"/>
								<children>
									<template subtype="element" match="employees">
										<children>
											<template subtype="element" groupingtype="group-by" groupingmatch="@department" match="person">
												<sort>
													<key match="current-grouping-key()"/>
												</sort>
												<children>
													<paragraph>
														<styles color="#003d80" font-size="12pt" font-weight="bold" margin-bottom="0.25em" margin-top="1.5em"/>
														<children>
															<autocalc xpath="current-grouping-key()"/>
														</children>
													</paragraph>
													<tgrid>
														<properties cellpadding="5" cellspacing="0" width="300"/>
														<styles border-collapse="collapse"/>
														<children>
															<tgridbody-cols>
																<children>
																	<tgridcol>
																		<properties width="20%"/>
																	</tgridcol>
																	<tgridcol>
																		<properties width="80%"/>
																	</tgridcol>
																</children>
															</tgridbody-cols>
															<tgridheader-rows>
																<children>
																	<tgridrow>
																		<properties bgcolor="#969696"/>
																		<children>
																			<tgridcell>
																				<properties align="center"/>
																				<styles border="solid black 1px"/>
																				<children>
																					<text fixtext="Grade"/>
																				</children>
																			</tgridcell>
																			<tgridcell>
																				<styles border="solid black 1px"/>
																				<children>
																					<text fixtext="Name"/>
																				</children>
																			</tgridcell>
																		</children>
																	</tgridrow>
																</children>
															</tgridheader-rows>
															<tgridbody-rows>
																<children>
																	<template subtype="userdefined" groupingtype="group-by" groupingmatch="@grade" match="current-group()">
																		<sort>
																			<key match="current-grouping-key()"/>
																		</sort>
																		<children>
																			<template subtype="userdefined" match="current-group()">
																				<sort>
																					<key match="@last"/>
																				</sort>
																				<children>
																					<tgridrow>
																						<properties _xbgcolor="if (./@grade=&apos;A&apos;) then &apos;#ffcc77&apos; else 
if (./@grade=&apos;B&apos;) then &apos;#66ff66&apos; else 
if (./@grade=&apos;C&apos;) then &apos;#ff6666&apos; else &apos;#a0c0ff&apos;"/>
																						<children>
																							<tgridcell>
																								<properties align="center"/>
																								<styles border="solid black 1px"/>
																								<children>
																									<template subtype="attribute" match="grade">
																										<children>
																											<content subtype="regular">
																												<format basic-type="xsd" datatype="string"/>
																											</content>
																										</children>
																										<variables/>
																									</template>
																								</children>
																							</tgridcell>
																							<tgridcell>
																								<styles border="solid black 1px"/>
																								<children>
																									<template subtype="attribute" match="first">
																										<children>
																											<content subtype="regular">
																												<format basic-type="xsd" datatype="string"/>
																											</content>
																										</children>
																										<variables/>
																									</template>
																									<text fixtext=" "/>
																									<template subtype="attribute" match="last">
																										<children>
																											<content subtype="regular">
																												<format basic-type="xsd" datatype="string"/>
																											</content>
																										</children>
																										<variables/>
																									</template>
																									<newline/>
																								</children>
																							</tgridcell>
																						</children>
																					</tgridrow>
																				</children>
																				<variables/>
																			</template>
																		</children>
																		<variables/>
																	</template>
																</children>
															</tgridbody-rows>
														</children>
													</tgrid>
												</children>
												<variables/>
											</template>
										</children>
										<variables/>
									</template>
								</children>
							</paragraph>
							<newline/>
						</children>
						<variables/>
					</template>
					<newline/>
					<line>
						<properties color="#003d80" size="2"/>
					</line>
					<newline/>
					<newline/>
					<template subtype="source" match="XML">
						<children>
							<paragraph>
								<styles color="#003d80" font-family="Arial" font-size="16pt" font-weight="bold" padding-bottom="0.25em" padding-top="0.25em"/>
								<children>
									<text fixtext="Grouping 2: By Grade and Department"/>
								</children>
							</paragraph>
							<paragraph>
								<styles font-style="italic" margin-top="0.4em"/>
								<children>
									<text fixtext="In Grouping 2, employees are grouped first by grade, and then by department. Both sets of groups (grade and department) are sorted alphabetically in ascending order. Within a department, employees are sorted alphabetically, in ascending order, on their last names. "/>
								</children>
							</paragraph>
							<newline/>
							<paragraph>
								<children>
									<template subtype="element" match="employees">
										<children>
											<template subtype="element" groupingtype="group-by" groupingmatch="@grade" match="person">
												<sort>
													<key match="current-grouping-key()"/>
												</sort>
												<children>
													<paragraph>
														<styles color="#003d80" font-family="Arial" font-size="12pt" font-weight="bold" margin-bottom="0.25em" margin-top="1em"/>
														<children>
															<text fixtext="Grade "/>
															<autocalc xpath="current-grouping-key()"/>
														</children>
													</paragraph>
													<tgrid>
														<properties border="1" cellpadding="5" cellspacing="0" width="300"/>
														<children>
															<tgridbody-cols>
																<children>
																	<tgridcol>
																		<properties width="40%"/>
																	</tgridcol>
																	<tgridcol>
																		<properties width="60%"/>
																	</tgridcol>
																</children>
															</tgridbody-cols>
															<tgridheader-rows>
																<children>
																	<tgridrow>
																		<children>
																			<tgridcell>
																				<children>
																					<text fixtext="Name"/>
																				</children>
																			</tgridcell>
																			<tgridcell>
																				<children>
																					<text fixtext="Department"/>
																				</children>
																			</tgridcell>
																		</children>
																	</tgridrow>
																</children>
															</tgridheader-rows>
															<tgridbody-rows>
																<children>
																	<template subtype="userdefined" groupingtype="group-by" groupingmatch="@department" match="current-group()">
																		<sort>
																			<key match="current-grouping-key()"/>
																		</sort>
																		<children>
																			<template subtype="userdefined" match="current-group()">
																				<sort>
																					<key match="@last"/>
																				</sort>
																				<children>
																					<tgridrow>
																						<children>
																							<tgridcell>
																								<children>
																									<template subtype="attribute" match="first">
																										<children>
																											<content subtype="regular">
																												<format basic-type="xsd" datatype="string"/>
																											</content>
																										</children>
																										<variables/>
																									</template>
																									<text fixtext=" "/>
																									<template subtype="attribute" match="last">
																										<children>
																											<content subtype="regular">
																												<format basic-type="xsd" datatype="string"/>
																											</content>
																										</children>
																										<variables/>
																									</template>
																								</children>
																							</tgridcell>
																							<tgridcell>
																								<children>
																									<template subtype="attribute" match="department">
																										<children>
																											<content subtype="regular">
																												<format basic-type="xsd" datatype="string"/>
																											</content>
																										</children>
																										<variables/>
																									</template>
																								</children>
																							</tgridcell>
																						</children>
																					</tgridrow>
																				</children>
																				<variables/>
																			</template>
																		</children>
																		<variables/>
																	</template>
																</children>
															</tgridbody-rows>
														</children>
													</tgrid>
												</children>
												<variables/>
											</template>
										</children>
										<variables/>
									</template>
								</children>
							</paragraph>
						</children>
						<variables/>
					</template>
					<newline/>
					<line>
						<properties color="#003d80" size="2"/>
					</line>
					<newline/>
				</children>
			</globaltemplate>
		</children>
	</mainparts>
	<globalparts/>
	<designfragments/>
	<xmltables/>
	<authentic-custom-toolbar-buttons/>
</structure>
