﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <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>9FS9C1VK86R/Wui9+D3hXtFW0e/GUwGZ7U3oGGEJqHPfes8J0UpaBeJG9YBpdHdikBTRzU5Rw83hE7X0e32ku/Ng+6FWTPPx8W0lZGeEtXvCWtsCRVl6CUNM/UxxqG2P3yD1SdkOEwlFZ7j4aRllP8N4g4ld</ConnectionStringEncrypted>
        <Name>MS SQL</Name>
      </MS_x0020_SQL>
    </Databases>
    <DataSources isList="true" count="2">
      <Data2 Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>Data2</Alias>
        <Columns isList="true" count="3">
          <value>EmpName,System.String</value>
          <value>Emp_Salary,System.Int32</value>
          <value>Department,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>Data2</Name>
        <NameInSource>MS SQL</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>SELECT 'James Bond' as 'EmpName', 120 as 'Emp_Salary', 'Universal' as 'Department'
UNION ALL  SELECT 'Killer' as 'EmpName', 130 as 'Emp_Salary', 'Universal' as 'Department'

UNION  ALL  SELECT  'Harry P' as 'EmpName', 120 as 'Emp_Salary', '21 Century' as 'Department'
UNION  ALL  SELECT  'Hermeona G' as 'EmpName', 0 as 'Emp_Salary', '21 Century' as 'Department'

UNION  ALL  SELECT  'Ironman' as 'EmpName', 0 as 'Emp_Salary', 'Marvel' as 'Department'
UNION  ALL  SELECT  'Captain A' as 'EmpName', 0 as 'Emp_Salary', 'Marvel' as 'Department'
UNION  ALL  SELECT  'Lazy Developer' as 'EmpName', 0 as 'Emp_Salary', 'Marvel' as 'Department'

UNION  ALL  SELECT  'Big Jam' as 'EmpName', 0 as 'Emp_Salary', 'BIG CINEMA' as 'Department'
UNION  ALL  SELECT  'Big Bank' as 'EmpName', 101 as 'Emp_Salary', 'BIG CINEMA' as 'Department'
UNION  ALL  SELECT  'Big and Bold' as 'EmpName', 0 as 'Emp_Salary', 'BIG CINEMA' as 'Department'</SqlCommand>
      </Data2>
      <DataSource1 Ref="4" type="Stimulsoft.Report.Dictionary.StiVirtualSource" isKey="true">
        <Alias>DataSource1</Alias>
        <Columns isList="true" count="2">
          <value>Department,System.String</value>
          <value>Emp_Salary.Sum,System.Decimal</value>
        </Columns>
        <Dictionary isRef="1" />
        <Filters isList="true" count="0" />
        <GroupColumns isList="true" count="1">
          <value>Department</value>
        </GroupColumns>
        <Name>DataSource1</Name>
        <NameInSource>Data2</NameInSource>
        <Results isList="true" count="3">
          <value>Emp_Salary</value>
          <value>Sum</value>
          <value>Emp_Salary.Sum</value>
        </Results>
        <Sort isList="true" count="0" />
      </DataSource1>
    </DataSources>
    <Relations isList="true" count="1">
      <Name Ref="5" type="DataRelation" isKey="true">
        <Alias>Name</Alias>
        <ChildColumns isList="true" count="1">
          <value>Department</value>
        </ChildColumns>
        <ChildSource isRef="3" />
        <Dictionary isRef="1" />
        <Name>Name</Name>
        <NameInSource>Relation</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>Department</value>
        </ParentColumns>
        <ParentSource isRef="4" />
      </Name>
    </Relations>
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="1">
      <value>,ValuedRows,ValuedRows,ValuedRows,System.Int32,_x0030_,False,False,False,False</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page2 Ref="6" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <DataDataSource1 Ref="7" type="DataBand" isKey="true">
          <Brush>[217:150:148]</Brush>
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="2">
            <DataDataSource1_Department Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,9.6,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataDataSource1_Department</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Text>{DataSource1.Department}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataDataSource1_Department>
            <DataDataSource1_Emp_Salary_Sum Ref="9" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>9.6,0,9.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataDataSource1_Emp_Salary_Sum</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Text>{DataSource1.Emp_Salary_Sum}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataDataSource1_Emp_Salary_Sum>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>DataSource1</DataSourceName>
          <Filters isList="true" count="1">
            <value>Emp_Salary_Sum,GreaterThan,_x0030_,,Numeric</value>
          </Filters>
          <Name>DataDataSource1</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
          <Sort isList="true" count="0" />
        </DataDataSource1>
        <DataData2 Ref="10" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,2,19,0.8</ClientRectangle>
          <Components isList="true" count="3">
            <DataData2_EmpName Ref="11" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,6.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataData2_EmpName</Name>
              <Page isRef="6" />
              <Parent isRef="10" />
              <Text>{Data2.EmpName}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataData2_EmpName>
            <DataData2_Emp_Salary Ref="12" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>6.4,0,6.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataData2_Emp_Salary</Name>
              <Page isRef="6" />
              <Parent isRef="10" />
              <Text>{Data2.Emp_Salary}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataData2_Emp_Salary>
            <DataData2_Department Ref="13" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>12.8,0,6.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataData2_Department</Name>
              <Page isRef="6" />
              <Parent isRef="10" />
              <Text>{Data2.Department}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataData2_Department>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName>Relation</DataRelationName>
          <DataSourceName>Data2</DataSourceName>
          <Filters isList="true" count="1">
            <value>Emp_Salary,GreaterThan,_x0030_,,Numeric</value>
          </Filters>
          <MasterComponent isRef="7" />
          <Name>DataData2</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
          <Sort isList="true" count="0" />
        </DataData2>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>dec9297640414b7f94834f17ab84230b</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page2</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="14" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page2>
  </Pages>
  <PrinterSettings Ref="15" 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>8/4/2018 2:08:41 AM</ReportChanged>
  <ReportCreated>7/30/2018 10:56:00 AM</ReportCreated>
  <ReportFile>D:\Downloads\HideEmptyHeaders_updated.mrt</ReportFile>
  <ReportGuid>bb15b5aeb2df45d2a6f8e59f09e71627</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2018.2.3.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>