<?xml version="1.0"?>
<Reports>
  <FormatVersion>1.0 1.0.0.0</FormatVersion>
  <Report ref="1">
    <Name>Products Report</Name>
    <DataSourceName>Main</DataSourceName>
    <OnOpen>' -- style script start
_styleCtr = 0
' -- style script end
</OnOpen>
    <ReportInfo>
      <Author>dima</Author>
    </ReportInfo>
    <Layout>
      <Width>9435</Width>
      <Orientation>Portrait</Orientation>
    </Layout>
    <Font>
      <Name>Corbel</Name>
      <Size>10</Size>
      <Bold>false</Bold>
      <Italic>false</Italic>
      <Underline>false</Underline>
      <Strikethrough>false</Strikethrough>
      <GdiCharSet>1</GdiCharSet>
    </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 * from Products</RecordSource>
      </DataSource>
    </DataSources>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Height>1106</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
        <OnPrint>' -- style script start
detail.BackColor = iif(_styleCtr mod 2 = 0, rgb(255,255,255),rgb(239,239,239))
_styleCtr = _styleCtr + 1
' -- style script end
</OnPrint>
      </Section>
      <Section>
        <Name>Header</Name>
        <Background type="Solid">
          <Color>FF383265</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Background type="Solid">
              <Color>FFFFFFFF</Color>
            </Background>
            <Height>5370</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>Footer</Type>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <Background type="Solid">
          <Color>FF383265</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Background type="Solid">
              <Color>FFFFFFFF</Color>
            </Background>
            <Visible>false</Visible>
          </SubSection>
        </SubSections>
        <Type>PageHeader</Type>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <SubSections>
          <SubSection>
            <Height>500</Height>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
      </Section>
    </Sections>
    <Fields>
      <TextField>
        <Name>titleLbl</Name>
        <Section>Header</Section>
        <Left>50</Left>
        <Top>810</Top>
        <Width>3055</Width>
        <Height>455</Height>
        <Align>LeftMiddle</Align>
        <ForeColor>FF0070C0</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>19</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
        <Text>
          <Value sys="string">Paragraph Field</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>ftrLeft</Name>
        <Section>PageFooter</Section>
        <Left>50</Left>
        <Top>30</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>LeftTop</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
        <Text>
          <Expression>Now()</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>ftrRight</Name>
        <Section>PageFooter</Section>
        <Left>4680</Left>
        <Top>30</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Align>RightTop</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
        <Text>
          <Expression>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Expression>
        </Text>
      </TextField>
      <ParagraphField>
        <Name>Field1</Name>
        <Section>Detail</Section>
        <Left>50</Left>
        <Top>90</Top>
        <Width>8052</Width>
        <Height>1016</Height>
        <AutoHeight>GrowAndShrink</AutoHeight>
        <Font>
          <Name>Calibri</Name>
          <Size>10</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
        <Content>
          <ParagraphText>
            <Background type="Solid">
              <Color>FFFFFFFF</Color>
            </Background>
            <ForeColor>FF00B050</ForeColor>
            <Font>
              <Name>Calibri</Name>
              <Size>13</Size>
              <Bold>true</Bold>
              <Italic>false</Italic>
              <Underline>false</Underline>
              <Strikethrough>false</Strikethrough>
              <GdiCharSet>1</GdiCharSet>
            </Font>
            <Text>
              <Value sys="string">Product: </Value>
            </Text>
          </ParagraphText>
          <ParagraphText>
            <Background type="Solid">
              <Color>FFFFFFFF</Color>
            </Background>
            <ForeColor>FF00B050</ForeColor>
            <Font>
              <Name>Calibri</Name>
              <Size>13</Size>
              <Bold>true</Bold>
              <Italic>false</Italic>
              <Underline>false</Underline>
              <Strikethrough>false</Strikethrough>
              <GdiCharSet>1</GdiCharSet>
            </Font>
            <Text>
              <Expression>ProductName</Expression>
            </Text>
          </ParagraphText>
          <ParagraphText>
            <Text>
              <Value sys="string">
Unit price is </Value>
            </Text>
          </ParagraphText>
          <ParagraphText>
            <Font>
              <Name>Calibri</Name>
              <Size>11</Size>
              <Bold>true</Bold>
              <Italic>false</Italic>
              <Underline>false</Underline>
              <Strikethrough>false</Strikethrough>
              <GdiCharSet>1</GdiCharSet>
            </Font>
            <Text>
              <Expression>UnitPrice</Expression>
            </Text>
            <Format>Currency</Format>
          </ParagraphText>
          <ParagraphText>
            <Text>
              <Value sys="string">. We have </Value>
            </Text>
          </ParagraphText>
          <ParagraphText>
            <Font>
              <Name>Calibri</Name>
              <Size>11</Size>
              <Bold>true</Bold>
              <Italic>false</Italic>
              <Underline>false</Underline>
              <Strikethrough>false</Strikethrough>
              <GdiCharSet>1</GdiCharSet>
            </Font>
            <Text>
              <Expression>Iif(UnitsInStock &gt; 0, UnitsInStock, "No")</Expression>
            </Text>
          </ParagraphText>
          <ParagraphText>
            <Text>
              <Value sys="string"> units in stock.
</Value>
            </Text>
          </ParagraphText>
          <ParagraphText>
            <Background type="Solid">
              <Color>FFFCD5B5</Color>
            </Background>
            <ForeColor>FFFF0000</ForeColor>
            <Text>
              <Expression>Iif(Discontinued, "This product is no longer available", "")</Expression>
            </Text>
          </ParagraphText>
        </Content>
      </ParagraphField>
      <Field>
        <Name>Field6</Name>
        <Section>Header</Section>
        <Left>60</Left>
        <Top>30</Top>
        <Width>4065</Width>
        <Height>600</Height>
        <PictureScale>Scale</PictureScale>
        <Picture>
          <Image> </Image>
        </Picture>
      </Field>
      <Field>
        <Name>Field5</Name>
        <Section>Header</Section>
        <Left>5490</Left>
        <Top>1025</Top>
        <Width>1545</Width>
        <Height>240</Height>
        <Text>Today</Text>
        <Align>RightTop</Align>
        <ForeColor>FF0070C0</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft1</Name>
        <Section>Header</Section>
        <Left>7125</Left>
        <Top>1025</Top>
        <Width>2235</Width>
        <Height>225</Height>
        <Text>Now()</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <ForeColor>FF0070C0</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <ShapeField>
        <Name>Field2</Name>
        <Border>
          <Left>
            <Width>90</Width>
            <Color>FF0070C0</Color>
          </Left>
          <Top>
            <Width>90</Width>
            <Color>FF0070C0</Color>
          </Top>
          <Right>
            <Width>90</Width>
            <Color>FF0070C0</Color>
          </Right>
          <Bottom>
            <Width>90</Width>
            <Color>FF0070C0</Color>
          </Bottom>
        </Border>
        <Section>Header</Section>
        <Left>90</Left>
        <Top>5115</Top>
        <Width>9165</Width>
        <Height>165</Height>
        <Shape type="LineShape" />
      </ShapeField>
      <TextField>
        <Name>Field3</Name>
        <Section>Header</Section>
        <Left>75</Left>
        <Top>1355</Top>
        <Width>8940</Width>
        <Height>3475</Height>
        <Text>
          <Value sys="string">This report demonstrates the use of Paragraph Field. You can - 

- type any static text. To insert a newline, press Ctrl+Enter.

- set font/fore color/back color for any part of text - to do this, select some text and use the ribbon text group's buttons to set font/colors on just the selected text;

- insert expressions (like DB field values) - to do this, while in paragraph edit mode, open context menu (right click) and select "insert expression..." - this will open the expression editor, and the resulting expression will get inserted into the text of the paragraph. You can then apply fonts/colors to it too (via the ribbon), or press
Alt-Enter to go to that expression's properties and edit them in the property grid.

- over an existing expression within the paragraph, you can right
click - 'edit expression' to edit it. Or, edit in the property grid.
</Value>
        </Text>
      </TextField>
    </Fields>
  </Report>
</Reports>