<?xml version="1.0"?>
<Reports>
  <FormatVersion>1.0 1.0.0.0</FormatVersion>
  <Report ref="1">
    <Name>Cross-tab Reports</Name>
    <DataSourceName>Main</DataSourceName>
    <Layout>
      <Width>9385</Width>
      <Orientation>Portrait</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
      <Bold>false</Bold>
      <Italic>false</Italic>
      <Underline>false</Underline>
      <Strikethrough>false</Strikethrough>
    </Font>
    <DataSources>
      <DataSource>
        <Name>Main</Name>
        <DataProvider>OLEDB</DataProvider>
        <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|C1NWind.mdb;Persist Security Info=False</ConnectionString>
        <RecordSource>SELECT Orders.ShipCountry, Categories.CategoryName, Year([OrderDate]) AS OrderYear, Sum([Order Details].[UnitPrice]*[Order Details].[Quantity]-[Discount]) AS SaleAmount, DatePart("q",[OrderDate]) AS OrderQtr
FROM Categories INNER JOIN (Products INNER JOIN (Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID) ON Categories.CategoryID = Products.CategoryID
GROUP BY Orders.ShipCountry, Categories.CategoryName, Year([OrderDate]), DatePart("q",[OrderDate])
ORDER BY Orders.ShipCountry, Categories.CategoryName, Year([OrderDate]);
</RecordSource>
      </DataSource>
    </DataSources>
    <Groups>
      <Group>
        <Name>ShipCountry</Name>
        <GroupBy>ShipCountry</GroupBy>
        <Sort>Ascending</Sort>
        <KeepTogether>KeepFirstDetail</KeepTogether>
        <OutlineLabel>
          <Expression>ShipCountry</Expression>
        </OutlineLabel>
      </Group>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>Ascending</Sort>
        <KeepTogether>KeepFirstDetail</KeepTogether>
      </Group>
      <Group>
        <Name>OrderYear</Name>
        <GroupBy>OrderYear</GroupBy>
        <Sort>Descending</Sort>
        <KeepTogether>KeepFirstDetail</KeepTogether>
        <OutlineLabel>
          <Expression>OrderYear</Expression>
        </OutlineLabel>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Background type="Solid">
          <Color>FFDCDCDC</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>255</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>5055</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>Footer</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>PageHeader</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>555</Height>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
      </Section>
      <Section>
        <Name>ShipCountry Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>990</Height>
          </SubSection>
        </SubSections>
        <Type>GroupHeader1</Type>
        <Repeat>true</Repeat>
      </Section>
      <Section>
        <Name>ShipCountry Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>435</Height>
          </SubSection>
        </SubSections>
        <Type>GroupFooter1</Type>
        <OnPrint>fContinued.Visible = false</OnPrint>
      </Section>
      <Section>
        <Name>CategoryName Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>GroupHeader2</Type>
        <Visible>false</Visible>
        <Repeat>true</Repeat>
      </Section>
      <Section>
        <Name>CategoryName Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>GroupFooter2</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>GroupHeader2</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>255</Height>
          </SubSection>
        </SubSections>
        <Type>GroupHeader3</Type>
        <Repeat>true</Repeat>
        <OnPrint>fContinued.Visible = true</OnPrint>
      </Section>
      <Section>
        <Name>GroupFooter2</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>GroupFooter3</Type>
        <Visible>false</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>CompanyNameLbl2</Name>
        <Section>Detail</Section>
        <Left>180</Left>
        <Top>0</Top>
        <Width>3240</Width>
        <Height>255</Height>
        <Text>CategoryName</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <HideDuplicates>true</HideDuplicates>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>OrderYearLbl2</Name>
        <Section>Detail</Section>
        <Left>3510</Left>
        <Top>0</Top>
        <Width>990</Width>
        <Height>255</Height>
        <Text>OrderYear</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>fSales2</Name>
        <Section>Detail</Section>
        <Left>4515</Left>
        <Top>0</Top>
        <Width>1350</Width>
        <Height>255</Height>
        <Text>SaleAmount</Text>
        <Calculated>true</Calculated>
        <Format>#,##0</Format>
        <Align>RightTop</Align>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>fQ11</Name>
        <Section>Detail</Section>
        <Left>6000</Left>
        <Top>0</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Text>OrderQtr</Text>
        <Calculated>true</Calculated>
        <Format>#,##0;#;#</Format>
        <Align>RightTop</Align>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Verdana</Name>
          <Size>8.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field6</Name>
        <Section>Header</Section>
        <Left>63</Left>
        <Top>32</Top>
        <Width>995</Width>
        <Height>1026</Height>
        <Picture>
          <Image> </Image>
        </Picture>
      </Field>
      <Field>
        <Name>titleLbl</Name>
        <Border>
          <Left>
            <Width>10</Width>
            <Color>FF17375E</Color>
          </Left>
          <Top>
            <Width>10</Width>
            <Color>FF17375E</Color>
          </Top>
          <Right>
            <Width>10</Width>
            <Color>FF17375E</Color>
          </Right>
          <Bottom>
            <Width>10</Width>
            <Color>FF17375E</Color>
          </Bottom>
        </Border>
        <Section>Header</Section>
        <Left>1089</Left>
        <Top>79</Top>
        <Width>5053</Width>
        <Height>600</Height>
        <Text>C1Works Enterprise</Text>
        <Align>LeftMiddle</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>24</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>titleLbl1</Name>
        <Border>
          <Left>
            <Width>10</Width>
            <Color>FF17375E</Color>
          </Left>
          <Top>
            <Width>10</Width>
            <Color>FF17375E</Color>
          </Top>
          <Right>
            <Width>10</Width>
            <Color>FF17375E</Color>
          </Right>
          <Bottom>
            <Width>10</Width>
            <Color>FF17375E</Color>
          </Bottom>
        </Border>
        <Section>Header</Section>
        <Left>1153</Left>
        <Top>410</Top>
        <Width>5053</Width>
        <Height>600</Height>
        <Text>Cross-tab Reports</Text>
        <Align>LeftMiddle</Align>
        <ForeColor>FF007D9D</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>12</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field5</Name>
        <Section>Header</Section>
        <Left>5385</Left>
        <Top>1125</Top>
        <Width>1545</Width>
        <Height>240</Height>
        <Text>Today</Text>
        <Align>RightTop</Align>
        <ForeColor>FF17375E</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft1</Name>
        <Section>Header</Section>
        <Left>7020</Left>
        <Top>1125</Top>
        <Width>2235</Width>
        <Height>225</Height>
        <Text>Now()</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <ForeColor>FF17375E</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field7</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>30</Width>
            <Color>FF17375E</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>30</Width>
            <Color>FF17375E</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>30</Width>
            <Color>FF17375E</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>30</Width>
            <Color>FF17375E</Color>
          </Bottom>
        </Border>
        <Section>Header</Section>
        <Left>60</Left>
        <Top>1470</Top>
        <Width>9270</Width>
        <Height>45</Height>
        <Shape type="LineShape" />
      </Field>
      <Field>
        <Name>Field4</Name>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>1575</Top>
        <Width>9270</Width>
        <Height>3435</Height>
        <MarginLeft>200</MarginLeft>
        <AutoHeight>GrowAndShrink</AutoHeight>
        <Text>Cross-tab reports group data in two dimensions (down and across). They are useful for summarizing large amounts of data in a format that cross-references information.

To create cross-tab reports, you will typically start with a GROUP BY query to summarize the data into rows, then use a transformation service to create the grouped columns. The transformation service can be provided by the database server itself, it can be a custom program, or you can use C1Report's built-in domain aggregates.

This report uses the latter approach. The data source has an "OrderQtr" field that contains the quarter when the orders were placed. The report's group header has expressions of the form "sum(SaleAmount, OrderQtr = 1)". These expressions add up all the sales for the corresponding quarter. The report produces the cross-tab view placing four of these expressions side-by-side.

Note that the detail section in this report is hidden. If you make it visible you will see what the underlying data looks like.</Text>
        <ForeColor>FF333333</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
          </Bottom>
        </Border>
        <Section>PageFooter</Section>
        <Left>0</Left>
        <Top>255</Top>
        <Width>9315</Width>
        <Height>0</Height>
        <Shape type="LineShape" />
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>PageFooter</Section>
        <Left>4680</Left>
        <Top>255</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>true</Calculated>
        <Align>RightTop</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl1</Name>
        <Section>GroupHeader1</Section>
        <Left>0</Left>
        <Top>270</Top>
        <Width>5940</Width>
        <Height>360</Height>
        <Text>ShipCountry</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <ForeColor>FF17375E</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>12</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>fContinued</Name>
        <Section>GroupHeader1</Section>
        <Visible>false</Visible>
        <Left>6015</Left>
        <Top>300</Top>
        <Width>2610</Width>
        <Height>345</Height>
        <Text>(continued)</Text>
        <Align>LeftTop</Align>
        <ForeColor>FF10253F</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>CompanyNameLbl1</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>GroupHeader1</Section>
        <Left>180</Left>
        <Top>720</Top>
        <Width>2460</Width>
        <Height>255</Height>
        <Text>Product Category</Text>
        <Align>LeftBottom</Align>
        <ForeColor>FF17375E</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>OrderYearLbl1</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>GroupHeader1</Section>
        <Left>3420</Left>
        <Top>720</Top>
        <Width>1080</Width>
        <Height>255</Height>
        <Text>Year</Text>
        <Align>LeftBottom</Align>
        <ForeColor>FF17375E</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>SaleAmountLbl1</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>GroupHeader1</Section>
        <Left>4515</Left>
        <Top>720</Top>
        <Width>1350</Width>
        <Height>255</Height>
        <Text>Sales</Text>
        <Align>RightBottom</Align>
        <ForeColor>FF17375E</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>OrderQtrLbl1</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>GroupHeader1</Section>
        <Left>6015</Left>
        <Top>720</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Text>Q1</Text>
        <Align>RightBottom</Align>
        <ForeColor>FF17375E</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>OrderQtrLbl2</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>GroupHeader1</Section>
        <Left>6810</Left>
        <Top>720</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Text>Q2</Text>
        <Align>RightBottom</Align>
        <ForeColor>FF17375E</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>OrderQtrLbl3</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>GroupHeader1</Section>
        <Left>7605</Left>
        <Top>720</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Text>Q3</Text>
        <Align>RightBottom</Align>
        <ForeColor>FF17375E</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>OrderQtrLbl4</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>GroupHeader1</Section>
        <Left>8400</Left>
        <Top>720</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Text>Q4</Text>
        <Align>RightBottom</Align>
        <ForeColor>FF17375E</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF666666</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF666666</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF666666</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF666666</Color>
          </Bottom>
        </Border>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>GroupHeader1</Section>
        <Left>0</Left>
        <Top>990</Top>
        <Width>9345</Width>
        <Height>0</Height>
        <ForeColor>FF17375E</ForeColor>
        <Shape type="LineShape">
          <LineSlant>Down</LineSlant>
        </Shape>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFA9A9A9</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFA9A9A9</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFA9A9A9</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FFA9A9A9</Color>
          </Bottom>
        </Border>
        <Section>GroupFooter1</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>9345</Width>
        <Height>0</Height>
        <ForeColor>FF333333</ForeColor>
        <Shape type="LineShape">
          <LineSlant>Down</LineSlant>
        </Shape>
      </Field>
      <Field>
        <Name>Field8</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Color>00FFFFFF</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Color>00FFFFFF</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Color>00FFFFFF</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Color>00FFFFFF</Color>
          </Bottom>
        </Border>
        <Background type="Solid">
          <Color>FFF6F6F6</Color>
        </Background>
        <Section>GroupFooter1</Section>
        <Left>0</Left>
        <Top>40</Top>
        <Width>9345</Width>
        <Height>316</Height>
        <ZOrder>-1</ZOrder>
      </Field>
      <Field>
        <Name>fSales1</Name>
        <Section>GroupFooter1</Section>
        <Left>4500</Left>
        <Top>90</Top>
        <Width>1350</Width>
        <Height>255</Height>
        <Text>sum(SaleAmount)</Text>
        <Calculated>true</Calculated>
        <Format>#,##0</Format>
        <Align>RightTop</Align>
        <ForeColor>FF333333</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>fQ7</Name>
        <Section>GroupFooter1</Section>
        <Left>5985</Left>
        <Top>90</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Text>sum(SaleAmount, OrderQtr = 1)</Text>
        <Calculated>true</Calculated>
        <Format>#,##0</Format>
        <Align>RightTop</Align>
        <ForeColor>FF333333</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>fQ</Name>
        <Section>GroupFooter1</Section>
        <Left>6780</Left>
        <Top>90</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Text>sum(SaleAmount, OrderQtr = 2)</Text>
        <Calculated>true</Calculated>
        <Format>#,##0</Format>
        <Align>RightTop</Align>
        <ForeColor>FF333333</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>fQ5</Name>
        <Section>GroupFooter1</Section>
        <Left>7575</Left>
        <Top>90</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Text>sum(SaleAmount, OrderQtr = 3)</Text>
        <Calculated>true</Calculated>
        <Format>#,##0</Format>
        <Align>RightTop</Align>
        <ForeColor>FF333333</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>fQ6</Name>
        <Section>GroupFooter1</Section>
        <Left>8370</Left>
        <Top>90</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Text>sum(SaleAmount, OrderQtr = 4)</Text>
        <Calculated>true</Calculated>
        <Format>#,##0</Format>
        <Align>RightTop</Align>
        <ForeColor>FF333333</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>CompanyNameLbl</Name>
        <Section>GroupHeader3</Section>
        <Left>180</Left>
        <Top>0</Top>
        <Width>3240</Width>
        <Height>255</Height>
        <Text>CategoryName</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <ForeColor>FF666666</ForeColor>
        <HideDuplicates>true</HideDuplicates>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>OrderYearLbl</Name>
        <Section>GroupHeader3</Section>
        <Left>3510</Left>
        <Top>0</Top>
        <Width>990</Width>
        <Height>255</Height>
        <Text>OrderYear</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <ForeColor>FF666666</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>fSales</Name>
        <Section>GroupHeader3</Section>
        <Left>4515</Left>
        <Top>0</Top>
        <Width>1350</Width>
        <Height>255</Height>
        <Text>sum(SaleAmount)</Text>
        <Calculated>true</Calculated>
        <Format>#,##0</Format>
        <Align>RightTop</Align>
        <ForeColor>FF666666</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF666666</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF666666</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF666666</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF666666</Color>
          </Bottom>
        </Border>
        <Section>GroupHeader3</Section>
        <Left>5940</Left>
        <Top>0</Top>
        <Width>0</Width>
        <Height>255</Height>
        <Shape type="LineShape" />
      </Field>
      <Field>
        <Name>fQ1</Name>
        <Section>GroupHeader3</Section>
        <Left>6000</Left>
        <Top>0</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Text>sum(SaleAmount, OrderQtr = 1)</Text>
        <Calculated>true</Calculated>
        <Format>#,##0;#;#</Format>
        <Align>RightTop</Align>
        <ForeColor>FF666666</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>fQ2</Name>
        <Section>GroupHeader3</Section>
        <Left>6795</Left>
        <Top>0</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Text>sum(SaleAmount, OrderQtr = 2)</Text>
        <Calculated>true</Calculated>
        <Format>#,##0;#;#</Format>
        <Align>RightTop</Align>
        <ForeColor>FF666666</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>fQ3</Name>
        <Section>GroupHeader3</Section>
        <Left>7590</Left>
        <Top>0</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Text>sum(SaleAmount, OrderQtr = 3)</Text>
        <Calculated>true</Calculated>
        <Format>#,##0;#;#</Format>
        <Align>RightTop</Align>
        <ForeColor>FF666666</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>fQ4</Name>
        <Section>GroupHeader3</Section>
        <Left>8385</Left>
        <Top>0</Top>
        <Width>720</Width>
        <Height>255</Height>
        <Text>sum(SaleAmount, OrderQtr = 4)</Text>
        <Calculated>true</Calculated>
        <Format>#,##0;#;#</Format>
        <Align>RightTop</Align>
        <ForeColor>FF666666</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>fSales3</Name>
        <Section>GroupFooter1</Section>
        <Left>180</Left>
        <Top>105</Top>
        <Width>1350</Width>
        <Height>255</Height>
        <Text>Total</Text>
        <Format>#,##0</Format>
        <Align>LeftTop</Align>
        <ForeColor>FF333333</ForeColor>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
    </Fields>
  </Report>
</Reports>