﻿<?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="2">
      <连接 Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>连接</Alias>
        <ConnectionStringEncrypted>+eb7K08K2TXiX9Vsaj315940TwtNVzGAw1v1pWPQoHuA0tGh3VnrxeJJQPhOTGtei3D3I80IQ/VveKCl6T0yP9HygePvTKuAb0v9gMocq3vfasvCTV1DrfJB7fDDhCWf0dD1r09U+vVFXP3xw4in/9dgUwPG</ConnectionStringEncrypted>
        <Name>连接</Name>
      </连接>
      <财务 Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>财务</Alias>
        <ConnectionStringEncrypted>9EL7SNcIAZlsW7XwxOzjP9FUrShFa9P1RVvojU1xJUbDYLPJYgV5yGJO0YTqAaAT035zrMZMAYHCev1Qyh0lY9NwzUhNEtNFwxU5jWFJ4C/JIPmjS0zjzXIa7Zx5ca17kDrBaEsK023LY6D4YT0=</ConnectionStringEncrypted>
        <Name>财务</Name>
      </财务>
    </Databases>
    <DataSources isList="true" count="2">
      <A_Test_Product Ref="4" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>A_Test_Product</Alias>
        <Columns isList="true" count="9">
          <value>PlaceL,System.String</value>
          <value>PlaceS,System.String</value>
          <value>TypeL,System.String</value>
          <value>TypeS,System.String</value>
          <value>Number,System.Single</value>
          <value>Price,System.Single</value>
          <value>Amount,System.Single</value>
          <value>fdb,System.Double</value>
          <value>Percent,System.Single</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Key>e2808219c4b145b7857227be0685ef55</Key>
        <Name>A_Test_Product</Name>
        <NameInSource>连接</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from A_Test_Product</SqlCommand>
      </A_Test_Product>
      <三栏式明细账 Ref="5" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>三栏式明细账</Alias>
        <Columns isList="true" count="0" />
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Key>2fe32f24de0a47aeab5674f75485c718</Key>
        <Name>三栏式明细账</Name>
        <NameInSource>财务</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>exec PROC_GL_CreateTreeColumns '22fbccb8-8c1b-43a8-bf1e-ffa6fe1869f7',2020,202001,202003</SqlCommand>
      </三栏式明细账>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="4">
      <value>UserVariable,UserId,UserId,,System.String,fa5ac6e4-76a1-4e14-8080-0757579f2ba7,True,False,False,False</value>
      <value>UserVariable,DepartmentId,DepartmentId,,System.String,_x0037_7d678ee-1ec7-45dc-9522-7d8c61126fd6,True,False,False,False</value>
      <value>SystemVariable,Year,Year,,System.String,_x0032_020,True,False,False,False</value>
      <value>SystemVariable,YearMonth,YearMonth,,System.String,_x0032_02003,True,False,False,False</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>abed4f2dc7854467a5c9fe23493eeb57</Key>
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Dashboard1 Ref="6" type="Stimulsoft.Dashboard.Components.StiDashboard" isKey="true">
      <BackColor>Transparent</BackColor>
      <Components isList="true" count="1">
        <PivotTable1 Ref="7" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotTableElement" isKey="true">
          <AltClientRectangle>0,0,0,0</AltClientRectangle>
          <BackColor>Transparent</BackColor>
          <ClientRectangle>0,0,460,300</ClientRectangle>
          <Columns isList="true" count="1">
            <Item7 Ref="8" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotColumn" isKey="true">
              <Expression>A_Test_Product.TypeL</Expression>
              <Key>571ab80f7bb5442097da966d1fe958a9</Key>
              <Label>TypeL</Label>
              <TopN Ref="9" type="Stimulsoft.Data.Engine.StiDataTopN" isKey="true" />
            </Item7>
          </Columns>
          <DataFilters isList="true" count="0" />
          <Expressions isList="true" count="0" />
          <Guid>47af81ea3cd24392bc7cebdbb80522e2</Guid>
          <Margin>3,3,3,3</Margin>
          <Name>PivotTable1</Name>
          <Padding>5,5,5,5</Padding>
          <Page isRef="6" />
          <Parent isRef="6" />
          <PivotTableConditions isList="true" count="0" />
          <Rows isList="true" count="2">
            <Item8 Ref="10" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotRow" isKey="true">
              <Expression>A_Test_Product.PlaceL</Expression>
              <Key>926dafc608bc4b36a3aa9d91e548611c</Key>
              <Label>PlaceL</Label>
              <TopN Ref="11" type="Stimulsoft.Data.Engine.StiDataTopN" isKey="true" />
            </Item8>
            <Item9 Ref="12" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotRow" isKey="true">
              <Expression>A_Test_Product.PlaceS</Expression>
              <Key>b2bc5381d6c2405094d8e623cc4ba4c2</Key>
              <Label>PlaceS</Label>
              <TopN Ref="13" type="Stimulsoft.Data.Engine.StiDataTopN" isKey="true" />
            </Item9>
          </Rows>
          <Summaries isList="true" count="3">
            <Item10 Ref="14" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotSummary" isKey="true">
              <Expression>Sum(A_Test_Product.Price)</Expression>
              <Key>3983578ce5c049748087d3fbb6448294</Key>
              <Label>Price</Label>
            </Item10>
            <Item11 Ref="15" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotSummary" isKey="true">
              <Expression>Sum(A_Test_Product.Amount)</Expression>
              <Key>51c3d3f4c2b04378846ac415de30adb1</Key>
              <Label>Amount</Label>
            </Item11>
            <Item12 Ref="16" type="Stimulsoft.Dashboard.Components.PivotTable.StiPivotSummary" isKey="true">
              <Expression>Sum(A_Test_Product.Price)/Sum(A_Test_Product.Amount)</Expression>
              <Key>d992f39ef72d4a91964980e2d4088eca</Key>
              <Label>Percent</Label>
              <TextFormat Ref="17" type="PercentageFormat" isKey="true">
                <DecimalDigits>2</DecimalDigits>
                <GroupSeparator>,</GroupSeparator>
                <NegativePattern>1</NegativePattern>
                <PositivePattern>1</PositivePattern>
                <Symbol>%</Symbol>
              </TextFormat>
            </Item12>
          </Summaries>
          <SummaryDirection>LeftToRight</SummaryDirection>
          <Title Ref="18" type="Stimulsoft.Dashboard.Components.StiTitle" isKey="true">
            <BackColor>Transparent</BackColor>
            <Font>Arial,11</Font>
            <ForeColor>Transparent</ForeColor>
            <Text>关键表格</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>b0e1a15889164f5da1f3aba26321b14f</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>12/11/2020 11:48:19 AM</ReportChanged>
  <ReportCreated>12/11/2020 11:48:19 AM</ReportCreated>
  <ReportFile>D:\WebSite\HRP_MainPortal\web\wwwroot\StimulsoftMssql\Filemanger/cef56134-d813-4482-a0a2-9ba1668d64cc.mrt</ReportFile>
  <ReportGuid>1033921e205a48738cfb2e87a1a162cd</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2020.5.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>