<?xml version="1.0"?>
<Reports>
  <FormatVersion>1.0 1.0.0.0</FormatVersion>
  <Report ref="1">
    <Name>Parameters</Name>
    <DataSourceName>Main</DataSourceName>
    <OnOpen>cnt = 0</OnOpen>
    <ReportInfo>
      <Author>Work</Author>
    </ReportInfo>
    <Layout />
    <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 Categories.*, Products.*
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
where Categories.CategoryID in prmCategory </RecordSource>
      </DataSource>
      <DataSource>
        <Name>dsCategories</Name>
        <DataProvider>OLEDB</DataProvider>
        <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|C1NWind.mdb;Persist Security Info=False</ConnectionString>
        <RecordSource>Categories</RecordSource>
        <SortDefinitions>
          <SortDefinition>
            <Expression>
              <Value>CategoryName</Value>
            </Expression>
          </SortDefinition>
        </SortDefinitions>
        <CalculatedFields>
          <CalculatedField>
            <Name>CalculatedField 0</Name>
            <Expression>CategoryID*2</Expression>
          </CalculatedField>
        </CalculatedFields>
      </DataSource>
    </DataSources>
    <ReportParameters>
      <ReportParameter>
        <Name>prmCategory</Name>
        <MultiValue>true</MultiValue>
        <AllowedValuesDefinition>
          <Binding>
            <DataSourceName>dsCategories</DataSourceName>
            <ValueExpression>CategoryID</ValueExpression>
            <LabelExpression>CategoryName</LabelExpression>
          </Binding>
          <Values />
        </AllowedValuesDefinition>
        <Prompt>Categories</Prompt>
        <ParameterType>Integer</ParameterType>
      </ReportParameter>
    </ReportParameters>
    <Groups>
      <Group>
        <Name>CategoryName</Name>
        <GroupBy>CategoryName</GroupBy>
        <Sort>Ascending</Sort>
        <KeepTogether>KeepFirstDetail</KeepTogether>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <Background type="Linear">
          <GradientStops>
            <GradientStop>
              <Position>0</Position>
              <Color>FFC8DCC8</Color>
            </GradientStop>
            <GradientStop>
              <Position>1</Position>
              <Color>00FFFFFF</Color>
            </GradientStop>
          </GradientStops>
        </Background>
        <SubSections>
          <SubSection>
            <Height>370</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
        <OnFormat>cnt = cnt + 1
if cnt mod 2 = 0 then
  detail.background.StartColor = rgb(200,220,200)
else
  detail.background.StartColor = "Transparent"
endif</OnFormat>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Background type="Solid">
              <Color>FFFFFFFF</Color>
            </Background>
            <Height>2640</Height>
          </SubSection>
          <SubSection>
            <Height>885</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>Footer</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>PageHeader</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <SubSections>
          <SubSection>
            <Border>
              <Top>
                <Style>Solid</Style>
                <Width>15</Width>
              </Top>
            </Border>
            <Height>452</Height>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
      </Section>
      <Section>
        <Name>CategoryName_Header</Name>
        <SubSections>
          <SubSection>
            <Border>
              <Left>
                <Width>20</Width>
              </Left>
              <Top>
                <Width>20</Width>
              </Top>
              <Right>
                <Width>20</Width>
              </Right>
              <Bottom>
                <Style>Solid</Style>
                <Width>20</Width>
              </Bottom>
            </Border>
            <Height>2580</Height>
          </SubSection>
        </SubSections>
        <Type>GroupHeader1</Type>
      </Section>
      <Section>
        <Name>CategoryName_Footer</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>GroupFooter1</Type>
        <Visible>false</Visible>
      </Section>
    </Sections>
    <Fields>
      <TextField>
        <Name>Field1</Name>
        <Section>Header</Section>
        <Left>180</Left>
        <Top>915</Top>
        <Width>2415</Width>
        <Height>525</Height>
        <ForeColor>FF0070C0</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>18</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Value sys="string">Parameters</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>fldCategoryName</Name>
        <Border>
          <Bottom>
            <Width>30</Width>
            <Color>FF4682B4</Color>
          </Bottom>
        </Border>
        <Section>GroupHeader1</Section>
        <Left>2025</Left>
        <Top>315</Top>
        <Width>7155</Width>
        <Height>480</Height>
        <ForeColor>FF4682B4</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>15.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Expression>CategoryName</Expression>
        </Text>
      </TextField>
      <ImageField>
        <Name>fldPicture</Name>
        <Section>GroupHeader1</Section>
        <Left>180</Left>
        <Top>90</Top>
        <Width>1665</Width>
        <Height>1824</Height>
        <PictureAlign>CenterMiddle</PictureAlign>
        <PictureScale>Scale</PictureScale>
        <Picture>
          <Expression>Picture</Expression>
        </Picture>
      </ImageField>
      <TextField>
        <Name>fldCategoryName</Name>
        <Section>GroupHeader1</Section>
        <Left>2025</Left>
        <Top>1059</Top>
        <Width>7155</Width>
        <Height>855</Height>
        <ForeColor>FF4682B4</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Expression>Description</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>GroupHeader1</Section>
        <Left>441</Left>
        <Top>2004</Top>
        <Width>3390</Width>
        <Height>405</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF4682B4</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Value sys="string">Product Name</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>GroupHeader1</Section>
        <Left>4011</Left>
        <Top>2004</Top>
        <Width>1821</Width>
        <Height>405</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF4682B4</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Value sys="string">Quantity Per Unit</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>GroupHeader1</Section>
        <Left>6012</Left>
        <Top>2004</Top>
        <Width>1494</Width>
        <Height>405</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF4682B4</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Value sys="string">Unit Price</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>GroupHeader1</Section>
        <Left>7686</Left>
        <Top>2004</Top>
        <Width>1494</Width>
        <Height>405</Height>
        <Align>LeftBottom</Align>
        <ForeColor>FF4682B4</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Value sys="string">In Stock</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>Detail</Section>
        <Left>441</Left>
        <Top>90</Top>
        <Width>3390</Width>
        <Height>280</Height>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Expression>ProductName</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>Detail</Section>
        <Left>4011</Left>
        <Top>90</Top>
        <Width>1821</Width>
        <Height>280</Height>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Expression>QuantityPerUnit</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>Detail</Section>
        <Left>6012</Left>
        <Top>90</Top>
        <Width>1494</Width>
        <Height>280</Height>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Expression>UnitPrice</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>Detail</Section>
        <Left>7686</Left>
        <Top>90</Top>
        <Width>1494</Width>
        <Height>280</Height>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Expression>UnitsInStock</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field4</Name>
        <Section>PageFooter</Section>
        <Left>441</Left>
        <Top>90</Top>
        <Width>4299</Width>
        <Height>272</Height>
        <Align>LeftMiddle</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Expression>Format(Now, "Medium Date")</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field5</Name>
        <Section>PageFooter</Section>
        <Left>4920</Left>
        <Top>90</Top>
        <Width>4260</Width>
        <Height>272</Height>
        <Align>RightMiddle</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Expression>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field6</Name>
        <Section>Header</Section>
        <SubSectionIndex>1</SubSectionIndex>
        <Left>180</Left>
        <Top>90</Top>
        <Width>2970</Width>
        <Height>270</Height>
        <Text>
          <Value sys="string">Categories to include in the report:</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field6</Name>
        <Section>Header</Section>
        <SubSectionIndex>1</SubSectionIndex>
        <Left>600</Left>
        <Top>450</Top>
        <Width>8580</Width>
        <Height>270</Height>
        <AutoHeight>GrowAndShrink</AutoHeight>
        <Font>
          <Name>Arial</Name>
          <Size>9</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Expression>prmCategory.DisplayText</Expression>
        </Text>
      </TextField>
      <Field>
        <Name>Field7</Name>
        <Section>Header</Section>
        <Left>60</Left>
        <Top>30</Top>
        <Width>4065</Width>
        <Height>600</Height>
        <PictureScale>Scale</PictureScale>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Picture>
          <Image> </Image>
        </Picture>
      </Field>
      <Field>
        <Name>Field8</Name>
        <Section>Header</Section>
        <Left>5460</Left>
        <Top>1125</Top>
        <Width>1545</Width>
        <Height>315</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>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft1</Name>
        <Section>Header</Section>
        <Left>7050</Left>
        <Top>1125</Top>
        <Width>2160</Width>
        <Height>300</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>
        </Font>
      </Field>
      <TextField>
        <Name>Field2</Name>
        <Section>Header</Section>
        <Left>180</Left>
        <Top>1890</Top>
        <Width>8925</Width>
        <Height>540</Height>
        <Font>
          <Name>Calibri</Name>
          <Size>10</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Value sys="string">This report contains multivalue parameter, list of available parameters generated on the base of Categories dataset. It also shows how Parameter field value can be directly used in Report.</Value>
        </Text>
      </TextField>
      <ShapeField>
        <Name>Field9</Name>
        <Border>
          <Left>
            <Width>20</Width>
          </Left>
          <Top>
            <Width>20</Width>
          </Top>
          <Right>
            <Width>20</Width>
          </Right>
          <Bottom>
            <Width>20</Width>
          </Bottom>
        </Border>
        <Section>Header</Section>
        <Left>195</Left>
        <Top>1575</Top>
        <Width>9165</Width>
        <Height>225</Height>
        <Shape type="LineShape" />
      </ShapeField>
    </Fields>
  </Report>
</Reports>