﻿<?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">
      <kpis_data Ref="2" type="Stimulsoft.Report.Dictionary.StiExcelDatabase" isKey="true">
        <Alias>kpis_data</Alias>
        <Key />
        <Name>kpis_data</Name>
        <PathData>D:\wiixt\Wiiprot4\ANALYTICS\Stimulsoft\kpis_data.xlsx</PathData>
      </kpis_data>
    </Databases>
    <DataSources isList="true" count="1">
      <data Ref="3" type="DataTableSource" isKey="true">
        <Alias>data</Alias>
        <Columns isList="true" count="7">
          <value>id,System.Double</value>
          <value>idkpi,System.Double</value>
          <value>kpiname,System.String</value>
          <value>max,System.Double</value>
          <value>min,System.Double</value>
          <value>Operation,System.String</value>
          <value>value,System.Double</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>d45e7b8bcf3a41b68816c3dd6ed663f8</Key>
        <Name>data</Name>
        <NameInSource>kpis_data.data</NameInSource>
      </data>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>bd0240e6b0104428a7be48b41b24873e</Key>
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Dashboard1 Ref="4" type="Stimulsoft.Dashboard.Components.StiDashboard" isKey="true">
      <BackColor>Transparent</BackColor>
      <Components isList="true" count="1">
        <PivotTable1 Ref="5" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotTableElement" isKey="true">
          <AltClientRectangle>0,0,0,0</AltClientRectangle>
          <BackColor>Transparent</BackColor>
          <ClientRectangle>20,0,580,360</ClientRectangle>
          <Columns isList="true" count="1">
            <Item5 Ref="6" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotColumn" isKey="true">
              <Expression>data.Operation</Expression>
              <Key>dce04fc7a7174520be9e7a417898a2ac</Key>
              <Label>Operation</Label>
              <ShowTotal>False</ShowTotal>
              <Size Ref="7" type="Stimulsoft.Report.Dashboard.StiTableColumnSize" isKey="true" />
              <TopN Ref="8" type="Stimulsoft.Data.Engine.StiDataTopN" isKey="true" />
            </Item5>
          </Columns>
          <DataFilters isList="true" count="0" />
          <Expressions isList="true" count="0" />
          <Guid>74e766eb0e574a62aeec72abb68a41f4</Guid>
          <Margin>3,3,3,3</Margin>
          <Name>PivotTable1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <PivotTableConditions isList="true" count="0" />
          <Rows isList="true" count="4">
            <Item6 Ref="9" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotRow" isKey="true">
              <Expression>data.idkpi</Expression>
              <Key>0603e467282144ad85480963c23d987a</Key>
              <Label>idkpi</Label>
              <ShowTotal>False</ShowTotal>
              <Size Ref="10" type="Stimulsoft.Report.Dashboard.StiTableColumnSize" isKey="true" />
              <TopN Ref="11" type="Stimulsoft.Data.Engine.StiDataTopN" isKey="true" />
            </Item6>
            <Item7 Ref="12" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotRow" isKey="true">
              <Expression>data.kpiname</Expression>
              <Key>fd26386b41834e0ba2fa27c8b4b81e01</Key>
              <Label>kpiname</Label>
              <ShowTotal>False</ShowTotal>
              <Size Ref="13" type="Stimulsoft.Report.Dashboard.StiTableColumnSize" isKey="true" />
              <TopN Ref="14" type="Stimulsoft.Data.Engine.StiDataTopN" isKey="true" />
            </Item7>
            <Item8 Ref="15" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotRow" isKey="true">
              <Expression>data.min</Expression>
              <Key>086b78f21dd441728ecf53ef63562bbe</Key>
              <Label>min</Label>
              <ShowTotal>False</ShowTotal>
              <Size Ref="16" type="Stimulsoft.Report.Dashboard.StiTableColumnSize" isKey="true" />
              <TopN Ref="17" type="Stimulsoft.Data.Engine.StiDataTopN" isKey="true" />
            </Item8>
            <Item9 Ref="18" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotRow" isKey="true">
              <Expression>data.max</Expression>
              <Key>85d7a3854e0d4a07945797d2b976d5c6</Key>
              <Label>max</Label>
              <ShowTotal>False</ShowTotal>
              <Size Ref="19" type="Stimulsoft.Report.Dashboard.StiTableColumnSize" isKey="true" />
              <TopN Ref="20" type="Stimulsoft.Data.Engine.StiDataTopN" isKey="true" />
            </Item9>
          </Rows>
          <Summaries isList="true" count="1">
            <Item10 Ref="21" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotSummary" isKey="true">
              <Expression>Sum(data.value)</Expression>
              <HorAlignment>Center</HorAlignment>
              <Key>78cdacb91eed47b085aba45ba85289d2</Key>
              <Label>value</Label>
              <Size Ref="22" type="Stimulsoft.Report.Dashboard.StiTableColumnSize" isKey="true" />
            </Item10>
          </Summaries>
          <Title Ref="23" type="Stimulsoft.Dashboard.Components.StiTitle" isKey="true">
            <BackColor>Transparent</BackColor>
            <Font>Arial,11</Font>
            <ForeColor>Transparent</ForeColor>
            <SizeMode>Fit</SizeMode>
            <Text>Pivot Table</Text>
          </Title>
          <TransformActions isList="true" count="0" />
          <TransformFilters isList="true" count="0" />
          <TransformSorts isList="true" count="0" />
        </PivotTable1>
      </Components>
      <Expressions isList="true" count="0" />
      <Guid>847a4e2e07224ef095eebb1fed3231e2</Guid>
      <Name>Dashboard1</Name>
      <Report isRef="0" />
    </Dashboard1>
  </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>2/23/2022 5:31:35 AM</ReportChanged>
  <ReportCreated>2/23/2022 4:59:43 AM</ReportCreated>
  <ReportFile>D:\wiixt\Wiiprot4\ANALYTICS\Stimulsoft\test.mrt</ReportFile>
  <ReportGuid>929a3c4ce7f0463c9219e4efc32f6699</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2022.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="0" />
</StiSerializer>