﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <CacheAllData>True</CacheAllData>
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="1">
      <Book2 Ref="2" type="Stimulsoft.Report.Dictionary.StiExcelDatabase" isKey="true">
        <Alias>Book2</Alias>
        <Key />
        <Name>Book2</Name>
        <PathData>C:\Stimulsoft\Support\vinnet\Master-detail\Book2.xlsx</PathData>
      </Book2>
    </Databases>
    <DataSources isList="true" count="3">
      <Class Ref="3" type="DataTableSource" isKey="true">
        <Alias>Class</Alias>
        <Columns isList="true" count="3">
          <value>Class,System.String</value>
          <value>Id,System.Double</value>
          <value>SchoolId,System.Double</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Class</Name>
        <NameInSource>Book2.Class</NameInSource>
      </Class>
      <School Ref="4" type="DataTableSource" isKey="true">
        <Alias>School</Alias>
        <Columns isList="true" count="2">
          <value>School,System.String</value>
          <value>Id,System.Double</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>School</Name>
        <NameInSource>Book2.School</NameInSource>
      </School>
      <Students Ref="5" type="DataTableSource" isKey="true">
        <Alias>Students</Alias>
        <Columns isList="true" count="4">
          <value>Student,System.String</value>
          <value>Id,System.Double</value>
          <value>ClassId,System.Double</value>
          <value>Marks,System.Double</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Students</Name>
        <NameInSource>Book2.Students</NameInSource>
      </Students>
    </DataSources>
    <Relations isList="true" count="2">
      <School Ref="6" type="DataRelation" isKey="true">
        <Alias>School</Alias>
        <ChildColumns isList="true" count="1">
          <value>SchoolId</value>
        </ChildColumns>
        <ChildSource isRef="3" />
        <Dictionary isRef="1" />
        <Name>School</Name>
        <NameInSource>Relation</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>Id</value>
        </ParentColumns>
        <ParentSource isRef="4" />
      </School>
      <Class Ref="7" type="DataRelation" isKey="true">
        <Alias>Class</Alias>
        <ChildColumns isList="true" count="1">
          <value>ClassId</value>
        </ChildColumns>
        <ChildSource isRef="5" />
        <Dictionary isRef="1" />
        <Name>Class</Name>
        <NameInSource>Class</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>Id</value>
        </ParentColumns>
        <ParentSource isRef="3" />
      </Class>
    </Relations>
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="8" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="4">
        <ReportTitleBand3 Ref="9" type="ReportTitleBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,2.8</ClientRectangle>
          <Components isList="true" count="1">
            <hdr2Text12 Ref="10" type="Text" isKey="true">
              <Bookmark>General recommendations</Bookmark>
              <Border>None;[180:68:114:196];1;Solid;False;4;[180:68:114:196]</Border>
              <Brush>EmptyBrush</Brush>
              <ClientRectangle>0,0,9.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,20,Bold</Font>
              <Guid>5612a38b8b0543c384605876ed18e8a9</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>hdr2Text12</Name>
              <Page isRef="8" />
              <Parent isRef="9" />
              <Text>Sample report title band</Text>
              <TextBrush>Gray</TextBrush>
              <Type>Expression</Type>
            </hdr2Text12>
          </Components>
          <Conditions isList="true" count="0" />
          <Guid>7f3193f53ce448fcb5947044fa9af348</Guid>
          <Name>ReportTitleBand3</Name>
          <Page isRef="8" />
          <Parent isRef="8" />
        </ReportTitleBand3>
        <DataBand1 Ref="11" type="DataBand" isKey="true">
          <Brush>Red</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,4,19,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>School</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataBand1</Name>
          <Page isRef="8" />
          <Parent isRef="8" />
          <Sort isList="true" count="0" />
        </DataBand1>
        <DataBand2 Ref="12" type="DataBand" isKey="true">
          <Brush>Yellow</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,4.8,19,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <DataRelationName>Relation</DataRelationName>
          <DataSourceName>Class</DataSourceName>
          <Filters isList="true" count="0" />
          <MasterComponent isRef="11" />
          <Name>DataBand2</Name>
          <Page isRef="8" />
          <Parent isRef="8" />
          <PrintIfDetailEmpty>True</PrintIfDetailEmpty>
          <Sort isList="true" count="0" />
        </DataBand2>
        <DataBand3 Ref="13" type="DataBand" isKey="true">
          <Brush>[146:208:80]</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,5.6,19,0.8</ClientRectangle>
          <Components isList="true" count="4">
            <Text3 Ref="14" type="Text" isKey="true">
              <Border>None;[180:68:114:196];1;Solid;False;4;[180:68:114:196]</Border>
              <Brush>EmptyBrush</Brush>
              <ClientRectangle>9.6,0,9,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="8" />
              <Parent isRef="13" />
              <Text>{Students.Student}</Text>
              <TextBrush>Black</TextBrush>
            </Text3>
            <Text4 Ref="15" type="Text" isKey="true">
              <Border>None;[180:68:114:196];1;Solid;False;4;[180:68:114:196]</Border>
              <Brush>EmptyBrush</Brush>
              <ClientRectangle>17.4,0,1.6,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text4</Name>
              <Page isRef="8" />
              <Parent isRef="13" />
              <Text>{Students.Marks}</Text>
              <TextBrush>Black</TextBrush>
            </Text4>
            <Text6 Ref="16" type="Text" isKey="true">
              <Border>None;[180:68:114:196];1;Solid;False;4;[180:68:114:196]</Border>
              <Brush>EmptyBrush</Brush>
              <ClientRectangle>5.4,0,4.2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Guid>af666db4809f430f90e6a20b9e4aeb0e</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text6</Name>
              <Page isRef="8" />
              <Parent isRef="13" />
              <Text>{Class.Class}</Text>
              <TextBrush>Black</TextBrush>
            </Text6>
            <Text7 Ref="17" type="Text" isKey="true">
              <Border>None;[180:68:114:196];1;Solid;False;4;[180:68:114:196]</Border>
              <Brush>EmptyBrush</Brush>
              <ClientRectangle>0,0,5.4,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12,Bold</Font>
              <Guid>564a3505813a442dbfbd314dbdf0986c</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text7</Name>
              <Page isRef="8" />
              <Parent isRef="13" />
              <Text>{School.School}</Text>
              <TextBrush>Black</TextBrush>
            </Text7>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName>Class</DataRelationName>
          <DataSourceName>Students</DataSourceName>
          <FilterOn>False</FilterOn>
          <Filters isList="true" count="1">
            <value>Marks,GreaterThan,_x0038_0,,Numeric</value>
          </Filters>
          <MasterComponent isRef="12" />
          <Name>DataBand3</Name>
          <Page isRef="8" />
          <Parent isRef="8" />
          <PrintIfDetailEmpty>True</PrintIfDetailEmpty>
          <Sort isList="true" count="0" />
        </DataBand3>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>70b589b2ad60499ab59863333ef38fba</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="18" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="19" type="Stimulsoft.Report.Print.StiPrinterSettings" isKey="true" />
  <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/9/2017 1:41:25 PM</ReportChanged>
  <ReportCreated>12/6/2017 6:31:32 PM</ReportCreated>
  <ReportFile>C:\Stimulsoft\Support\vinnet\Master-detail\Report1_wih_colours.mrt</ReportFile>
  <ReportGuid>2b3c54a446fd43fc92579b65642992c7</ReportGuid>
  <ReportImage isNull="true" />
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2018.1.2.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>