﻿<?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">
      <DefaultConnection Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>DefaultConnection</Alias>
        <ConnectionStringEncrypted>4zCbCc50083hSZyA6owka40U2QliSw==</ConnectionStringEncrypted>
        <Key>d777347689894c4cb7cbd70e0c953de1</Key>
        <Name>DefaultConnection</Name>
      </DefaultConnection>
    </Databases>
    <DataSources isList="true" count="2">
      <GetDetails Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>GetDetails</Alias>
        <Columns isList="true" count="4">
          <value>ORIGINAL,CompanyName,CompanyName,CompanyName,System.String,_x0037_ead2ed0d2754923a1b76d4011b74556</value>
          <value>ORIGINAL,StartDate,StartDate,StartDate,System.DateTime,_x0030_a843d6c3431488fbce7cddfde6be2e5</value>
          <value>ORIGINAL,EndDate,EndDate,EndDate,System.DateTime,fd5b79c47def4a88a9cceb2ffc4a89ea</value>
          <value>ORIGINAL,GroupName,GroupName,GroupName,System.String,_x0036_649dec257534a259b6f15e6354c132d</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Key>91f5a3030c044716a3a8bed9aaea4cbe</Key>
        <Name>GetDetails</Name>
        <NameInSource>DefaultConnection</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>SELECT * FROM dbo.GetDetails({period},{year},{groupId})</SqlCommand>
      </GetDetails>
      <GetUsage Ref="4" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>GetUsage</Alias>
        <Columns isList="true" count="4">
          <value>ORIGINAL,GroupId,GroupId,GroupId,System.Int32,b379daeff3244d3ea859150cbad51b98</value>
          <value>ORIGINAL,BillingType,BillingType,BillingType,System.Int32,_x0031_cd9216ea50f48609208cb95c472cbe9</value>
          <value>ORIGINAL,DaysInPeriod,DaysInPeriod,DaysInPeriod,System.Int32,_x0030_9ae38765741454cb22a91a1fd0fe782</value>
          <value>GroupName,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Key>70a80dedc18e44fead42c5114db4886f</Key>
        <Name>GetUsage</Name>
        <NameInSource>DefaultConnection</NameInSource>
        <Parameters isList="true" count="3">
          <value>_x0040_period,period,8,0,5ba80310ba7d42d8be461a6a5cc0d2df</value>
          <value>_x0040_year,year,8,0,ed86c8643fa94cb99a56baf9ee89e669</value>
          <value>_x0040_groupId,groupId_x000D__x000A_,8,0,854c3c56bf8c49dd990021e2e6396c1f</value>
        </Parameters>
        <SqlCommand>GetUsage</SqlCommand>
        <Type>StoredProcedure</Type>
      </GetUsage>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="3">
      <value>,period,period,,System.Int32,_x0035_,False,False,False,False,,b2adac22b7ff4381a0e43c4580713b30,True</value>
      <value>,year,year,,System.Int32,_x0032_023,False,False,False,False,,b19df7168436408fba3c08c21a8aed03,True</value>
      <value>,groupId,groupId,,System.Int32,_x0030_,False,False,False,False,,_x0030_5e8fe188cbc45b695d2dda0d6280341</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>abfeec13fb9e42afa88e8597fc0664da</Key>
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="5" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="8">
        <PageHeaderBand1 Ref="6" type="PageHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.2,7.72,0.5</ClientRectangle>
          <Components isList="true" count="1">
            <Text46 Ref="7" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,4.8,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Verdana,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text46</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>Usage Report - {new DateTime(1, period, 1).ToString("MMMM")} {year}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text46>
          </Components>
          <Conditions isList="true" count="0" />
          <Expressions isList="true" count="0" />
          <Name>PageHeaderBand1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
        </PageHeaderBand1>
        <PageFooterBand1 Ref="8" type="PageFooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,9.82,7.72,0.4</ClientRectangle>
          <Components isList="true" count="2">
            <Text47 Ref="9" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>6.7,-0.02,1,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Verdana,9</Font>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text47</Name>
              <Page isRef="5" />
              <Parent isRef="8" />
              <Text>{PageNofM}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text47>
            <Text48 Ref="10" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,-0.02,0.6,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text48</Name>
              <Page isRef="5" />
              <Parent isRef="8" />
              <Text>{Today}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="11" type="DateFormat" isKey="true" />
              <Type>Expression</Type>
            </Text48>
          </Components>
          <Conditions isList="true" count="0" />
          <Expressions isList="true" count="0" />
          <Name>PageFooterBand1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
        </PageFooterBand1>
        <GroupHeaderBand1 Ref="12" type="GroupHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,1.1,7.72,0.2</ClientRectangle>
          <Components isList="true" count="1">
            <Text13 Ref="13" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,2.1,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text13</Name>
              <Page isRef="5" />
              <Parent isRef="12" />
              <Text>{GetDetails.GroupName}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text13>
          </Components>
          <Condition>{GetDetails.GroupName}</Condition>
          <Conditions isList="true" count="0" />
          <Expressions isList="true" count="0" />
          <Name>GroupHeaderBand1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
        </GroupHeaderBand1>
        <DataBand1 Ref="14" type="DataBand" isKey="true">
          <Border>None;[127:127:127];1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,1.7,7.72,0.2</ClientRectangle>
          <Components isList="true" count="2">
            <Text3 Ref="15" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,0.9,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="5" />
              <Parent isRef="14" />
              <Text>{GetDetails.StartDate}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="16" type="DateFormat" isKey="true" />
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text3>
            <Text4 Ref="17" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0.9,0,0.9,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text4</Name>
              <Page isRef="5" />
              <Parent isRef="14" />
              <Text>{GetDetails.EndDate}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="18" type="DateFormat" isKey="true" />
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text4>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>GetDetails</DataSourceName>
          <Expressions isList="true" count="0" />
          <Filters isList="true" count="0" />
          <Name>DataBand1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <Sort isList="true" count="2">
            <value>ASC</value>
            <value>BillingType</value>
          </Sort>
        </DataBand1>
        <GroupFooterBand1 Ref="19" type="GroupFooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,2.3,7.72,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <Expressions isList="true" count="0" />
          <Name>GroupFooterBand1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
        </GroupFooterBand1>
        <GroupHeaderBand2 Ref="20" type="GroupHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,2.7,7.72,0.2</ClientRectangle>
          <Components isList="true" count="1">
            <Text16 Ref="21" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,2.1,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text16</Name>
              <Page isRef="5" />
              <Parent isRef="20" />
              <Text>{GetUsage.GroupName}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text16>
          </Components>
          <Condition>{GetUsage.GroupName}</Condition>
          <Conditions isList="true" count="0" />
          <Expressions isList="true" count="0" />
          <Name>GroupHeaderBand2</Name>
          <NewPageBefore>True</NewPageBefore>
          <Page isRef="5" />
          <Parent isRef="5" />
        </GroupHeaderBand2>
        <DataBand2 Ref="22" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,3.3,7.72,0.2</ClientRectangle>
          <Components isList="true" count="2">
            <Text9 Ref="23" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.6,0,2.1,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text9</Name>
              <Page isRef="5" />
              <Parent isRef="22" />
              <Text>{GetUsage.BillingType}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="24" type="NumberFormat" isKey="true">
                <DecimalDigits>2</DecimalDigits>
                <GroupSeparator>,</GroupSeparator>
                <NegativePattern>1</NegativePattern>
                <State>DecimalDigits</State>
              </TextFormat>
              <Type>Expression</Type>
            </Text9>
            <Text14 Ref="25" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,0.6,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text14</Name>
              <Page isRef="5" />
              <Parent isRef="22" />
              <Text>{GetUsage.GroupId}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="26" type="DateFormat" isKey="true" />
              <Type>Expression</Type>
            </Text14>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>GetUsage</DataSourceName>
          <Expressions isList="true" count="0" />
          <Filters isList="true" count="0" />
          <Name>DataBand2</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <Sort isList="true" count="2">
            <value>ASC</value>
            <value>{GetEmergingTechUsage.SuiteName}</value>
          </Sort>
        </DataBand2>
        <GroupFooterBand2 Ref="27" type="GroupFooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,3.9,7.72,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <Expressions isList="true" count="0" />
          <Name>GroupFooterBand2</Name>
          <NewPageAfter>True</NewPageAfter>
          <Page isRef="5" />
          <Parent isRef="5" />
        </GroupFooterBand2>
      </Components>
      <Conditions isList="true" count="0" />
      <Expressions isList="true" count="0" />
      <Guid>677b839ab79a4241b9ce4ae07862baaa</Guid>
      <Margins>0.39,0.39,0.39,0.39</Margins>
      <Name>Page1</Name>
      <PageHeight>11</PageHeight>
      <PageWidth>8.5</PageWidth>
      <PaperSize>Letter</PaperSize>
      <Report isRef="0" />
    </Page1>
  </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>3/10/2025 1:50:37 PM</ReportChanged>
  <ReportCreated>3/3/2020 6:39:23 PM</ReportCreated>
  <ReportFile>C:\Users\MKathiresan\Downloads\Combining 2 datasources.mrt</ReportFile>
  <ReportGuid>7b7fff3ab869421eb3b5a2955d2bc396</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2023.1.8.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">
    <Lime_x0020_Data_x0020_Even Ref="28" type="Stimulsoft.Report.StiStyle" isKey="true">
      <Border>None;[43:43:43];1;Solid;False;4;Black</Border>
      <Brush>[236:240:241]</Brush>
      <Conditions isList="true" count="1">
        <Item23 Ref="29" type="Stimulsoft.Report.StiStyleCondition" isKey="true">
          <ComponentName>Data</ComponentName>
          <Placement>DataEvenStyle</Placement>
        </Item23>
      </Conditions>
      <Font>Microsoft Sans Serif,9.75</Font>
      <Name>Lime Data Even</Name>
      <NegativeTextBrush>Red</NegativeTextBrush>
      <TextBrush>[43:43:43]</TextBrush>
    </Lime_x0020_Data_x0020_Even>
  </Styles>
</StiSerializer>