﻿<?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>9BRTz81oe5lqe/3c/lzhJ9FUaYhIa9nNy2HtQOQFpGPXQGXrZ0s6gWFL3YDghGIPxED5K2FZyp1xeM34YaAlKtVa+UjFcUFtaUmh8HJwpD/5GFPCYgV6mWtPoYTlJfYP2Xhx</ConnectionStringEncrypted>
        <Name>MS SQL</Name>
      </MS_x0020_SQL>
    </Databases>
    <DataSources isList="true" count="1">
      <Data2 Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>Data2</Alias>
        <Columns isList="true" count="4">
          <value>EmpName,System.String</value>
          <value>Emp_Salary,System.Int32</value>
          <value>Department,System.String</value>
          <value>EmptyCell,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', null as 'EmptyCell'
UNION ALL  SELECT 'Killer' as 'EmpName', 130 as 'Emp_Salary', 'Universal' as 'Department', null as 'EmptyCell'
UNION  ALL  SELECT  'Harry P' as 'EmpName', 120 as 'Emp_Salary', '21 Century' as 'Department', null as 'EmptyCell'
UNION  ALL  SELECT  'Hermeona G' as 'EmpName', 0 as 'Emp_Salary', '21 Century' as 'Department', null as 'EmptyCell'
UNION  ALL  SELECT  'Ironman' as 'EmpName', 0 as 'Emp_Salary', 'Marvel' as 'Department', null as 'EmptyCell'
UNION  ALL  SELECT  'Captain A' as 'EmpName', 0 as 'Emp_Salary', 'Marvel' as 'Department', null as 'EmptyCell'</SqlCommand>
      </Data2>
    </DataSources>
    <Relations isList="true" count="0" />
    <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">
    <Page1 Ref="4" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <DataBand1 Ref="5" type="DataBand" isKey="true">
          <BeforePrintEvent>if(Data2.Emp_Salary != 0) {
	ValuedRows += 1;
}</BeforePrintEvent>
          <Brush>[79:129:189]</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="4">
            <Text1 Ref="6" type="Text" isKey="true">
              <Border>None;[231:232:234];1;Solid;False;4;[0:0:0:0];True</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,3.6,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Tahoma,7</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>{Data2.EmpName}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text1>
            <Text2 Ref="7" type="Text" isKey="true">
              <Border>None;[231:232:234];1;Solid;False;4;[0:0:0:0];True</Border>
              <Brush>Yellow</Brush>
              <ClientRectangle>4,0,3.6,0.8</ClientRectangle>
              <Conditions isList="true" count="1">
                <value>_x007B_Data2.Emp_Salary_x0020__x003C__x0020_125_x007D_,Red,Transparent,Arial_x002C_8,True,False,,Test,None</value>
              </Conditions>
              <Font>Tahoma,12</Font>
              <Guid>6913490c244943e68994371f76810daa</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>{Data2.Emp_Salary}</Text>
              <TextBrush>[79:97:40]</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text2>
            <Text7 Ref="8" type="Text" isKey="true">
              <Border>None;[231:232:234];1;Solid;False;4;[0:0:0:0];True</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>7.6,0,5.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Tahoma,7</Font>
              <Guid>4a14b440f1af4f2494ab508e6f53929d</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text7</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>CAN BE HIDDEN BE COndition only</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text7>
            <Text3 Ref="9" type="Text" isKey="true">
              <Border>None;[231:232:234];1;Solid;False;4;[0:0:0:0];True</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>13.2,0,5.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Tahoma,7</Font>
              <Guid>eaab916a8739474aa3972bae53a433f7</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>{Data2.EmptyCell}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text3>
          </Components>
          <Conditions isList="true" count="1">
            <value>_x007B_Data2.Emp_Salary_x0020__x003D__x003D__x0020_0_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None</value>
          </Conditions>
          <DataRelationName isNull="true" />
          <DataSourceName>Data2</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <Sort isList="true" count="0" />
        </DataBand1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>ba26d2a077d74533a1867ea999b2d32a</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="10" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="11" 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/27/2019 8:55:54 AM</ReportChanged>
  <ReportCreated>7/30/2018 10:56:00 AM</ReportCreated>
  <ReportFile>C:\Users\iskandara\Downloads\Sample.mrt</ReportFile>
  <ReportGuid>d703ee200d59427a81ce4507cb149d2f</ReportGuid>
  <ReportImage isNull="true" />
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2017.1.6.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="1">
    <Test Ref="12" type="Stimulsoft.Report.StiStyle" isKey="true">
      <AllowUseHorAlignment>True</AllowUseHorAlignment>
      <Brush>Transparent</Brush>
      <Conditions isList="true" count="0" />
      <Font>Arial Black,11.25,Bold| Italic,Point,False,0</Font>
      <Name>Test</Name>
      <TextBrush>Black</TextBrush>
    </Test>
  </Styles>
</StiSerializer>