<?xml version="1.0"?>
<Reports>
  <FormatVersion>1.0 1.0.0.0</FormatVersion>
  <Report ref="1">
    <Name>Cascading Parameters</Name>
    <DataSourceName>Main</DataSourceName>
    <ReportInfo>
      <Author>Work</Author>
    </ReportInfo>
    <Layout>
      <Width>10560</Width>
    </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 * from [order details] where productid = prmProduct</RecordSource>
      </DataSource>
      <DataSource>
        <Name>dsCategory</Name>
        <DataProvider>OLEDB</DataProvider>
        <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|C1NWind.mdb;Persist Security Info=False</ConnectionString>
        <RecordSource>select * from categories</RecordSource>
      </DataSource>
      <DataSource>
        <Name>dsProduct</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 where categoryid  = prmCategory</RecordSource>
      </DataSource>
    </DataSources>
    <ReportParameters>
      <ReportParameter>
        <Name>prmCategory</Name>
        <AllowedValuesDefinition>
          <Binding>
            <DataSourceName>dsCategory</DataSourceName>
            <ValueExpression>CategoryID</ValueExpression>
            <LabelExpression>CategoryName</LabelExpression>
          </Binding>
          <Values />
        </AllowedValuesDefinition>
        <ParameterType>Integer</ParameterType>
      </ReportParameter>
      <ReportParameter>
        <Name>prmProduct</Name>
        <AllowedValuesDefinition>
          <Binding>
            <DataSourceName>dsProduct</DataSourceName>
            <ValueExpression>ProductID</ValueExpression>
            <LabelExpression>ProductName</LabelExpression>
          </Binding>
          <Values />
        </AllowedValuesDefinition>
        <ParameterType>Integer</ParameterType>
      </ReportParameter>
    </ReportParameters>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <SubSections>
          <SubSection>
            <Height>420</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Height>3360</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>Footer</Type>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <SubSections>
          <SubSection>
            <Height>360</Height>
          </SubSection>
        </SubSections>
        <Type>PageHeader</Type>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <SubSections>
          <SubSection />
        </SubSections>
        <Type>PageFooter</Type>
      </Section>
    </Sections>
    <Fields>
      <TextField>
        <Name>Field2</Name>
        <Section>Header</Section>
        <Left>180</Left>
        <Top>2505</Top>
        <Width>2070</Width>
        <Height>285</Height>
        <Align>LeftMiddle</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>11</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Value sys="string">Category:</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>Header</Section>
        <Left>2430</Left>
        <Top>2505</Top>
        <Width>2625</Width>
        <Height>285</Height>
        <Align>LeftMiddle</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>11</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Expression>prmCategory.DisplayText</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field3</Name>
        <Section>Header</Section>
        <Left>2430</Left>
        <Top>2880</Top>
        <Width>3435</Width>
        <Height>435</Height>
        <Align>LeftMiddle</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>11</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Expression>prmProduct.DisplayText</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field2</Name>
        <Section>Header</Section>
        <Left>180</Left>
        <Top>2880</Top>
        <Width>2070</Width>
        <Height>285</Height>
        <Align>LeftMiddle</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>11</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Value sys="string">Product:</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>fldUnitPrice</Name>
        <Section>Detail</Section>
        <Left>180</Left>
        <Top>90</Top>
        <Width>2880</Width>
        <Height>270</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>fldQuantity</Name>
        <Section>Detail</Section>
        <Left>3435</Left>
        <Top>90</Top>
        <Width>2880</Width>
        <Height>270</Height>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Expression>Quantity</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>fldDiscount</Name>
        <Section>Detail</Section>
        <Left>6495</Left>
        <Top>90</Top>
        <Width>2880</Width>
        <Height>270</Height>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Expression>Discount</Expression>
        </Text>
      </TextField>
      <TextField>
        <Name>Field4</Name>
        <Section>PageHeader</Section>
        <Left>285</Left>
        <Top>45</Top>
        <Width>2775</Width>
        <Height>225</Height>
        <Align>RightTop</Align>
        <ForeColor>FF984807</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>10</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>true</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Value sys="string">Unit Price</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field5</Name>
        <Section>PageHeader</Section>
        <Left>3330</Left>
        <Top>90</Top>
        <Width>2970</Width>
        <Height>270</Height>
        <Align>RightTop</Align>
        <ForeColor>FF984807</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>10</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>true</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Value sys="string">Quantity</Value>
        </Text>
      </TextField>
      <TextField>
        <Name>Field6</Name>
        <Section>PageHeader</Section>
        <Left>6480</Left>
        <Top>45</Top>
        <Width>2895</Width>
        <Height>225</Height>
        <Align>RightTop</Align>
        <ForeColor>FF984807</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>10</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>true</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Text>
          <Value sys="string">Discount</Value>
        </Text>
      </TextField>
      <Field>
        <Name>titleLbl</Name>
        <Section>Header</Section>
        <Left>90</Left>
        <Top>1020</Top>
        <Width>4035</Width>
        <Height>600</Height>
        <Text>Cascading Parameters</Text>
        <Align>LeftMiddle</Align>
        <ForeColor>FF984807</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>18</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field1</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>Field7</Name>
        <Section>Header</Section>
        <Left>5460</Left>
        <Top>1245</Top>
        <Width>1545</Width>
        <Height>315</Height>
        <Text>Today</Text>
        <Align>RightTop</Align>
        <ForeColor>FF984807</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>1245</Top>
        <Width>2160</Width>
        <Height>300</Height>
        <Text>Now()</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <ForeColor>FF984807</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <ShapeField>
        <Name>Field8</Name>
        <Border>
          <Left>
            <Color>FF984807</Color>
          </Left>
          <Top>
            <Color>FF984807</Color>
          </Top>
          <Right>
            <Color>FF984807</Color>
          </Right>
          <Bottom>
            <Color>FF984807</Color>
          </Bottom>
        </Border>
        <Section>Header</Section>
        <Left>45</Left>
        <Top>1650</Top>
        <Width>10515</Width>
        <Height>165</Height>
        <Shape type="LineShape" />
      </ShapeField>
      <TextField>
        <Name>Field9</Name>
        <Section>Header</Section>
        <Left>240</Left>
        <Top>1965</Top>
        <Width>9780</Width>
        <Height>450</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 demonstrates use of Cascading Parameters. </Value>
        </Text>
      </TextField>
    </Fields>
  </Report>
</Reports>