<?xml version="1.0" encoding="UTF-8"?>
<structure version="14" html-doctype="HTML4 Transitional" compatibility-view="IE9" relativeto="*SPS" encodinghtml="UTF-8" encodingrtf="ISO-8859-1" encodingpdf="UTF-8" useimportschema="1" embed-images="1" enable-authentic-scripts="1" authentic-scripts-in-debug-mode-external="0" generated-file-location="DEFAULT">
	<parameters/>
	<schemasources>
		<namespaces/>
		<schemasources>
			<dbschemasource name="DB" main="1">
				<database_connection database_kind="MS Access" import_kind="ADO" version="04.00.0000" name="altova" active="1" use_driver_for_retrieval="1">
					<properties>
						<property name="Database Kind" value="MS Access"/>
						<property name="Import Kind" value="ADO"/>
						<property name="Root Object" value="altova"/>
						<property name="Data Source" value="Import\altova.mdb"/>
						<property name="Provider" value="Microsoft.Jet.OLEDB.4.0"/>
						<property name="User ID"/>
						<property name="Password"/>
						<property name="Persist Security Info"/>
						<property name="Jet OLEDB:System Database"/>
						<property name="Jet OLEDB:Sandbox Mode"/>
						<property name="Jet OLEDB:Exclusive Async Delay"/>
						<property name="Jet OLEDB:Flush Transaction Timeout"/>
						<property name="Jet OLEDB:Implicit Commit Sync"/>
						<property name="Jet OLEDB:Lock Delay"/>
						<property name="Jet OLEDB:Lock Retry"/>
						<property name="Jet OLEDB:Max Buffer Size"/>
						<property name="Jet OLEDB:Max Locks Per File"/>
						<property name="Jet OLEDB:Page Locks to Table Lock"/>
						<property name="Jet OLEDB:Page Timeout"/>
						<property name="Jet OLEDB:Recycle Long-Valued Pages"/>
						<property name="Jet OLEDB:Shared Async Delay"/>
						<property name="Jet OLEDB:User Commit Sync"/>
						<property name="Jet OLEDB:Compact Without Replica Repair"/>
						<property name="Jet OLEDB:Create System Database"/>
						<property name="Jet OLEDB:Database Locking Mode"/>
						<property name="Jet OLEDB:Database Password"/>
						<property name="Jet OLEDB:New Database Password"/>
						<property name="Jet OLEDB:Registry Path"/>
					</properties>
					<LocalViewStorage>
						<LocalViewElement SQL="SELECT Department.Name AS DepartmentName, COUNT(*) AS CountPerDepartment
FROM Person, Department
WHERE Person.ForeignKey = Department.PrimaryKey
GROUP BY Department.Name;">
							<PathElement Name="altova" Kind="DataSource"/>
							<PathElement Name="altova" Kind="Database"/>
							<PathElement Name="PersonsByDepartment" Kind="Select Statement"/>
						</LocalViewElement>
						<LocalViewElement SQL="SELECT Title, COUNT(*) AS CountPerTitle FROM Person
GROUP BY Title">
							<PathElement Name="altova" Kind="DataSource"/>
							<PathElement Name="altova" Kind="Database"/>
							<PathElement Name="PersonsByTitle" Kind="Select Statement"/>
						</LocalViewElement>
					</LocalViewStorage>
					<LocalRelationsStorage/>
				</database_connection>
				<dbselectedtablesandviews>
					<dbobject>
						<PathElement Name="altova" Kind="DataSource"/>
						<PathElement Name="altova" Kind="Database"/>
						<PathElement Name="PersonsByDepartment" Kind="Select Statement"/>
					</dbobject>
					<dbobject>
						<PathElement Name="altova" Kind="DataSource"/>
						<PathElement Name="altova" Kind="Database"/>
						<PathElement Name="PersonsByTitle" Kind="Select Statement"/>
					</dbobject>
				</dbselectedtablesandviews>
				<FilterCollection>
					<FilterCollectionElement>
						<FilterPathPair>
							<PathInfo>
								<Path>
									<PathElement Name="altova" Kind="DataSource"/>
									<PathElement Name="altova" Kind="Database"/>
									<PathElement Name="Person" Kind="Table"/>
								</Path>
							</PathInfo>
							<Filter/>
						</FilterPathPair>
					</FilterCollectionElement>
					<FilterCollectionElement>
						<FilterPathPair>
							<PathInfo>
								<Path>
									<PathElement Name="altova" Kind="DataSource"/>
									<PathElement Name="altova" Kind="Database"/>
									<PathElement Name="PersonsByDepartment" Kind="Select Statement"/>
								</Path>
							</PathInfo>
							<Filter/>
						</FilterPathPair>
					</FilterCollectionElement>
					<FilterCollectionElement>
						<FilterPathPair>
							<PathInfo>
								<Path>
									<PathElement Name="altova" Kind="DataSource"/>
									<PathElement Name="altova" Kind="Database"/>
									<PathElement Name="PersonsByTitle" Kind="Select Statement"/>
								</Path>
							</PathInfo>
							<Filter/>
						</FilterPathPair>
					</FilterCollectionElement>
				</FilterCollection>
			</dbschemasource>
		</schemasources>
	</schemasources>
	<modules/>
	<flags>
		<scripts/>
		<globalparts/>
		<designfragments/>
		<pagelayouts/>
		<xpath-functions/>
	</flags>
	<scripts>
		<script language="javascript"/>
	</scripts>
	<script-project>
		<Project version="2" app="AuthenticView"/>
	</script-project>
	<importedxslt/>
	<globalstyles>
		<rule url="Samples.css">
			<media>
				<media value="all"/>
			</media>
		</rule>
	</globalstyles>
	<mainparts>
		<children>
			<globaltemplate subtype="main" match="/">
				<document-properties/>
				<children>
					<documentsection>
						<properties columncount="1" columngap="0.50in" headerfooterheight="fixed" pagemultiplepages="0" pagenumberingformat="1" pagenumberingstartat="auto" pagestart="next" paperheight="11in" papermarginbottom="0.79in" papermarginfooter="0.30in" papermarginheader="0.30in" papermarginleft="0.60in" papermarginright="0.60in" papermargintop="0.79in" paperwidth="8.50in"/>
					</documentsection>
					<template subtype="source" match="DB">
						<children>
							<paragraph paragraphtag="p">
								<properties class="info"/>
								<children>
									<text fixtext="This example demonstrates how to create chart reports with databases."/>
								</children>
							</paragraph>
							<paragraph paragraphtag="p">
								<properties class="explanation"/>
								<children>
									<text fixtext="Under DB Tables and Views beside selecting tables and views, you can also add your own SQL statements. In this particular example a statement &quot;SELECT Title, COUNT(*) AS CountPerTitle FROM Person GROUP BY Title&quot; has been used (and named PersonsByTitle) in order to get grouped data out of the database using the power of the underlying database, in contrary to reading all data on the client side, which is slow for big tables."/>
								</children>
							</paragraph>
							<template subtype="db" match="DB">
								<children>
									<template subtype="dbtable" match="PersonsByTitle">
										<editorproperties elementstofetch="all"/>
										<children>
											<chart>
												<styles height="362px" width="564px"/>
												<layer>
													<dataset/>
													<dataseries-xny-rows for-each="Row" x-value="@Title" auto-x-value="0">
														<col y-value="@CountPerTitle" y-name="&quot;Series 1&quot;"/>
													</dataseries-xny-rows>
													<wizard-data remove-empty-cat="1" remove-empty-ser="1">
														<wizard-data-categories/>
														<wizard-data-series/>
													</wizard-data>
													<chartsettings>
														<General SettingsVersion="2" Title="Company Employees By Occupation" ShowLegend="0" Orientation="horz"/>
														<XY>
															<XAxis ShowTicks="0"/>
															<YAxis/>
														</XY>
													</chartsettings>
													<chartsettings-xpath>
														<main-properties/>
														<color-properties/>
														<colorrange-properties/>
													</chartsettings-xpath>
												</layer>
											</chart>
										</children>
										<variables/>
									</template>
									<newline break="page"/>
									<paragraph paragraphtag="p">
										<properties class="explanation"/>
										<children>
											<text fixtext="PersonsByDepartment is also an own SELECT statement which uses join between Person and Department tables. The rest is similar to the data and chart above."/>
										</children>
									</paragraph>
									<template subtype="dbtable" match="PersonsByDepartment">
										<editorproperties elementstodisplay="5"/>
										<children>
											<chart>
												<styles height="362px" width="564px"/>
												<layer>
													<dataset/>
													<dataseries-xny-rows for-each="Row" x-value="@DepartmentName" auto-x-value="0">
														<col y-value="@CountPerDepartment" y-name="&quot;Series 1&quot;"/>
													</dataseries-xny-rows>
													<wizard-data remove-empty-cat="1" remove-empty-ser="1">
														<wizard-data-categories/>
														<wizard-data-series/>
													</wizard-data>
													<chartsettings>
														<General SettingsVersion="2" ChartKind="Pie3d" Title="Company Employees By Department" ShowLegend="0"/>
													</chartsettings>
													<chartsettings-xpath>
														<main-properties/>
														<color-properties/>
														<colorrange-properties/>
													</chartsettings-xpath>
												</layer>
											</chart>
										</children>
										<variables/>
									</template>
								</children>
								<variables/>
							</template>
						</children>
						<variables/>
					</template>
				</children>
			</globaltemplate>
		</children>
	</mainparts>
	<globalparts/>
	<designfragments/>
	<xmltables/>
	<authentic-custom-toolbar-buttons/>
</structure>
