﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <CalculationMode>Interpretation</CalculationMode>
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="1">
      <MS_x0020_SQL Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>MS SQL</Alias>
        <ConnectionStringEncrypted>9MhpiddfAQVrTKVETUnh54Fw+4xnTGHtRgjtxGQcrG7EYMsJxlmj3eJhRRxj3GIT+cj9KFZ0AYViWjnJatg=</ConnectionStringEncrypted>
        <Name>MS SQL</Name>
      </MS_x0020_SQL>
    </Databases>
    <DataSources isList="true" count="2">
      <detail Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>detail</Alias>
        <Columns isList="true" count="3">
          <value>id,System.Int32</value>
          <value>masterid,System.Int32</value>
          <value>name,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Key>b7637e5c3bb94daca480e7e41e621986</Key>
        <Name>detail</Name>
        <NameInSource>MS SQL</NameInSource>
        <Parameters isList="true" count="1">
          <value>_x0040_p1,this_x005B__x0022_DrillDownParam1_x0022__x005D_,8,0</value>
        </Parameters>
        <SqlCommand>select * from detail where masterid = @p1</SqlCommand>
      </detail>
      <master Ref="4" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>master</Alias>
        <Columns isList="true" count="2">
          <value>id,System.Int32</value>
          <value>name,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Key>c1b66d6c2fa2411498f7f6df8a7853db</Key>
        <Name>master</Name>
        <NameInSource>MS SQL</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from master</SqlCommand>
      </master>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <UserFunctions isList="true" count="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>733ca21645bf49fd96293f73d06fe791</Key>
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="2">
    <Page1 Ref="5" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <DataBand1 Ref="6" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.4,19,1.2</ClientRectangle>
          <Components isList="true" count="2">
            <Text1 Ref="7" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,8,1.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Interaction Ref="8" type="Stimulsoft.Report.Components.StiInteraction" isKey="true">
                <DrillDownEnabled>True</DrillDownEnabled>
                <DrillDownPageGuid>66a6679e224a46599de1c81efe7bf6bb</DrillDownPageGuid>
                <DrillDownParameter1 Ref="9" type="Stimulsoft.Report.Components.StiDrillDownParameter" isKey="true">
                  <Expression>master.id</Expression>
                  <Name>DrillDownParam1</Name>
                </DrillDownParameter1>
              </Interaction>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>{master.id}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text1>
            <Text2 Ref="10" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>8,0,8,1.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>{master.name}</Text>
              <TextBrush>Black</TextBrush>
              <Type>DataColumn</Type>
            </Text2>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>master</DataSourceName>
          <Expressions isList="true" count="0" />
          <Filters isList="true" count="0" />
          <Name>DataBand1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <Sort isList="true" count="0" />
        </DataBand1>
      </Components>
      <Conditions isList="true" count="0" />
      <Expressions isList="true" count="0" />
      <Guid>1104f345f4dc4e72aa071e97aa6f9c6b</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
    </Page1>
    <Page2 Ref="11" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <Datadetail Ref="12" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="3">
            <Datadetail_id Ref="13" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,6.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Datadetail_id</Name>
              <Page isRef="11" />
              <Parent isRef="12" />
              <Text>{detail.id}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Datadetail_id>
            <Datadetail_masterid Ref="14" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>6.4,0,6.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Datadetail_masterid</Name>
              <Page isRef="11" />
              <Parent isRef="12" />
              <Text>{detail.masterid}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Datadetail_masterid>
            <Datadetail_name Ref="15" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>12.8,0,6.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Datadetail_name</Name>
              <Page isRef="11" />
              <Parent isRef="12" />
              <Text>{detail.name}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Datadetail_name>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>detail</DataSourceName>
          <Expressions isList="true" count="0" />
          <Filters isList="true" count="0" />
          <Name>Datadetail</Name>
          <Page isRef="11" />
          <Parent isRef="11" />
          <Sort isList="true" count="0" />
        </Datadetail>
      </Components>
      <Conditions isList="true" count="0" />
      <Expressions isList="true" count="0" />
      <Guid>66a6679e224a46599de1c81efe7bf6bb</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page2</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
    </Page2>
  </Pages>
  <ReferencedAssemblies isList="true" count="8">
    <value>System.Dll</value>
    <value>System.Drawing.Dll</value>
    <value>System.Windows.Forms.Dll</value>
    <value>System.Data.Dll</value>
    <value>System.Xml.Dll</value>
    <value>Stimulsoft.Controls.Dll</value>
    <value>Stimulsoft.Base.Dll</value>
    <value>Stimulsoft.Report.Dll</value>
  </ReferencedAssemblies>
  <ReportAlias>Report</ReportAlias>
  <ReportChanged>12/18/2023 11:33:16 PM</ReportChanged>
  <ReportCreated>12/18/2023 11:30:12 PM</ReportCreated>
  <ReportFile>E:\DrillDownParameterInQuery.mrt</ReportFile>
  <ReportGuid>f18c4e51be864eee8194d5d57167fd2e</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2024.1.1.0</ReportVersion>
  <Script>using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.Dialogs;
using Stimulsoft.Report.Components;

namespace Reports
{
    public class Report : Stimulsoft.Report.StiReport
    {
        public Report()        {
            this.InitializeComponent();
        }

        #region StiReport Designer generated code - do not modify
        #endregion StiReport Designer generated code - do not modify
    }
}
</Script>
  <ScriptLanguage>CSharp</ScriptLanguage>
  <Styles isList="true" count="0" />
</StiSerializer>