﻿<?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">
      <JSON Ref="2" type="Stimulsoft.Report.Dictionary.StiJsonDatabase" isKey="true">
        <Alias>JSON</Alias>
        <Key />
        <Name>JSON</Name>
        <PathData>resource://testdata</PathData>
      </JSON>
    </Databases>
    <DataSources isList="true" count="3">
      <invoices Ref="3" type="DataTableSource" isKey="true">
        <Alias>invoices</Alias>
        <Columns isList="true" count="2">
          <value>date,System.DateTime</value>
          <value>invoiceItems,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>5999c2a07ac64c80ba54f94eed022ce7</Key>
        <Name>invoices</Name>
        <NameInSource>JSON.invoices</NameInSource>
      </invoices>
      <invoices_invoiceItems Ref="4" type="DataTableSource" isKey="true">
        <Alias>invoices_invoiceItems</Alias>
        <Columns isList="true" count="3">
          <value>brutto,System.Decimal</value>
          <value>relationId,System.String</value>
          <value>invoiceDate,invoiceDate,System.DateTime,StrToDateTime_x0028_invoices_invoiceItems.invoices.date.ToString_x0028__x0022_MM.yyyy_x0022__x0029__x0029_</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>a16ddcb1f81943649d5cc9a1bf4a1b2d</Key>
        <Name>invoices_invoiceItems</Name>
        <NameInSource>JSON.invoices_invoiceItems</NameInSource>
      </invoices_invoiceItems>
      <invoices_sum Ref="5" type="Stimulsoft.Report.Dictionary.StiVirtualSource" isKey="true">
        <Alias>invoices_sum</Alias>
        <Columns isList="true" count="2">
          <value>invoiceDate,System.DateTime</value>
          <value>brutto.Sum,System.Decimal</value>
        </Columns>
        <Dictionary isRef="1" />
        <Filters isList="true" count="0" />
        <GroupColumns isList="true" count="1">
          <value>invoiceDate</value>
        </GroupColumns>
        <Key>abf1bbc450dd465d8075fd1131b42475</Key>
        <Name>invoices_sum</Name>
        <NameInSource>invoices_invoiceItems</NameInSource>
        <Results isList="true" count="3">
          <value>brutto</value>
          <value>Sum</value>
          <value>brutto.Sum</value>
        </Results>
        <Sort isList="true" count="0" />
      </invoices_sum>
    </DataSources>
    <Relations isList="true" count="1">
      <invoices Ref="6" type="DataRelation" isKey="true">
        <Alias>invoices</Alias>
        <ChildColumns isList="true" count="1">
          <value>relationId</value>
        </ChildColumns>
        <ChildSource isRef="4" />
        <Dictionary isRef="1" />
        <Name>invoices</Name>
        <NameInSource>invoices_invoiceItems</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>invoiceItems</value>
        </ParentColumns>
        <ParentSource isRef="3" />
      </invoices>
    </Relations>
    <Report isRef="0" />
    <Resources isList="true" count="1">
      <value>Name=testdata, Alias=testdata, Type=Json, Content=OG_x002B_9FCEzf_x002F_gBfcoZH6Zxmdb1jUF6F_x002B_XHJiy2_x002F_v6xkXprzbQ3qUMpJwVs9EWP_x002B_Be6M20qLyoHtSgpREq8geycepIP4r4oG3D2aV7UwiFlkPzsjicOQzAHJtn9Wo2Rpvbeoe0fV9uXDhd0O_x002F_BOiaheYDOKctBYEevH45ogp73w4K_x002F_Ebu5YIrY2wCGXwY_x002B_rP7m6p0PuiwPCNSUEmhpIC_x002F_4Nuj0c6AqhqGJ5TjPyoyVGuWYbkeZXEtBgtPv3Q_x002B_3BO2pqqt1_x002F_ujcS</value>
    </Resources>
    <Variables isList="true" count="4">
      <value>,BelegdatumVon,BelegdatumVon,,System.DateTime,_x0031__x002F_1_x002F_2019_x0020_12:00:00_x0020_AM,True,False,False,False,,fb17a20370b54da6b00b8bd0bf59ed9f</value>
      <value>,BelegdatumBis,BelegdatumBis,,System.DateTime,_x0031_2_x002F_28_x002F_2020_x0020_11:59:59_x0020_PM,True,False,False,False,,_x0032_6a3df7908c74cbd91db7a1b7bdb9560</value>
      <value>,Preiskategorien,Preiskategorien,,System.String,Test,True,False,False,False,,_x0037_093da229ab0446a8702e6204c4bc39e</value>
      <value>,Belegarten,Belegarten,,System.String,,True,False,False,False,,_x0039_266855fdc0e456eae43807590f39c3b</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>f343a2eb32624d01be6ede5650bce4bb</Key>
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="7" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <DataBand1 Ref="8" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,9</ClientRectangle>
          <Components isList="true" count="1">
            <Chart1 Ref="9" type="Stimulsoft.Report.Chart.StiChart" isKey="true">
              <Area Ref="10" type="Stimulsoft.Report.Chart.StiClusteredColumnArea" isKey="true">
                <BorderColor>Transparent</BorderColor>
                <Brush>[255:255:255]</Brush>
                <Chart isRef="9" />
                <GridLinesHorRight Ref="11" type="Stimulsoft.Report.Chart.StiGridLinesHor" isKey="true">
                  <Area isRef="10" />
                  <Color>Silver</Color>
                  <MinorColor>Gainsboro</MinorColor>
                  <Visible>False</Visible>
                </GridLinesHorRight>
                <XAxis Ref="12" type="Stimulsoft.Report.Chart.StiXBottomAxis" isKey="true">
                  <Area isRef="10" />
                  <Labels Ref="13" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Color>140, 140, 140</Color>
                    <Font>Tahoma,8</Font>
                    <Format>MM.yyyy</Format>
                  </Labels>
                  <LineColor>140, 140, 140</LineColor>
                </XAxis>
                <YAxis Ref="14" type="Stimulsoft.Report.Chart.StiYLeftAxis" isKey="true">
                  <Area isRef="10" />
                  <LineColor>140, 140, 140</LineColor>
                  <Title Ref="15" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>140, 140, 140</Color>
                    <Direction>BottomToTop</Direction>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </YAxis>
                <YRightAxis Ref="16" type="Stimulsoft.Report.Chart.StiYRightAxis" isKey="true">
                  <Area isRef="10" />
                  <Labels Ref="17" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Color>140, 140, 140</Color>
                    <Font>Tahoma,8</Font>
                    <TextAlignment>Left</TextAlignment>
                  </Labels>
                  <LineColor>140, 140, 140</LineColor>
                  <Title Ref="18" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>140, 140, 140</Color>
                    <Direction>TopToBottom</Direction>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </YRightAxis>
              </Area>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>0,0.2,19,8.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <ConstantLines isList="true" count="0" />
              <CustomStyleName />
              <Filters isList="true" count="0" />
              <Name>Chart1</Name>
              <Page isRef="7" />
              <Parent isRef="8" />
              <Series isList="true" count="1">
                <Item9 Ref="19" type="Stimulsoft.Report.Chart.StiClusteredColumnSeries" isKey="true">
                  <ArgumentDataColumn>invoices_sum.invoiceDate</ArgumentDataColumn>
                  <BorderColor>Transparent</BorderColor>
                  <Brush>[52:152:219]</Brush>
                  <BrushNegative>Firebrick</BrushNegative>
                  <Chart isRef="9" />
                  <Conditions isList="true" count="0" />
                  <Filters isList="true" count="0" />
                  <SeriesLabels Ref="20" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" isKey="true">
                    <BorderColor>Transparent</BorderColor>
                    <Brush>[119:255:255:255]</Brush>
                    <Chart isRef="9" />
                    <Font>Arial,10</Font>
                    <LabelColor>50, 58, 69</LabelColor>
                    <MarkerSize>8, 6</MarkerSize>
                    <ValueTypeSeparator>-</ValueTypeSeparator>
                    <Width>0</Width>
                  </SeriesLabels>
                  <ShowShadow>False</ShowShadow>
                  <Title>Series 2</Title>
                  <ValueDataColumn>invoices_sum.brutto_Sum</ValueDataColumn>
                </Item9>
              </Series>
              <SeriesLabels Ref="21" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" isKey="true">
                <BorderColor>Transparent</BorderColor>
                <Brush>[119:255:255:255]</Brush>
                <Chart isRef="9" />
                <Font>Arial,10</Font>
                <LabelColor>50, 58, 69</LabelColor>
                <MarkerSize>8, 6</MarkerSize>
                <ValueTypeSeparator>-</ValueTypeSeparator>
                <Width>0</Width>
              </SeriesLabels>
              <SeriesLabelsConditions isList="true" count="0" />
              <Sort isList="true" count="0" />
              <Strips isList="true" count="0" />
              <Style Ref="22" type="Stimulsoft.Report.Chart.StiStyle29" isKey="true">
                <Conditions isList="true" count="0" />
                <Name />
              </Style>
            </Chart1>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <Filters isList="true" count="0" />
          <Name>DataBand1</Name>
          <Page isRef="7" />
          <Parent isRef="7" />
          <Sort isList="true" count="0" />
        </DataBand1>
        <Datainvoices_sum Ref="23" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,10.2,19,0.8</ClientRectangle>
          <Components isList="true" count="2">
            <Datainvoices_sum_invoiceDate Ref="24" 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>Datainvoices_sum_invoiceDate</Name>
              <Page isRef="7" />
              <Parent isRef="23" />
              <Text>{invoices_sum.invoiceDate}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Datainvoices_sum_invoiceDate>
            <Datainvoices_sum_brutto_Sum Ref="25" 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>Datainvoices_sum_brutto_Sum</Name>
              <Page isRef="7" />
              <Parent isRef="23" />
              <Text>{invoices_sum.brutto_Sum}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Datainvoices_sum_brutto_Sum>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>invoices_sum</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>Datainvoices_sum</Name>
          <Page isRef="7" />
          <Parent isRef="7" />
          <Sort isList="true" count="0" />
        </Datainvoices_sum>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>3125e5bef8f74e9bbfca94cc5c7a42db</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <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>Auswertung Belege</ReportAlias>
  <ReportChanged>10/13/2020 2:30:57 PM</ReportChanged>
  <ReportCreated>9/15/2020 8:55:56 AM</ReportCreated>
  <ReportFile>testReport.mrt</ReportFile>
  <ReportGuid>5b11c554ee1c455083a6de77a7664037</ReportGuid>
  <ReportName>Auswertung Belege</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2020.4.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 Auswertung_Belege : Stimulsoft.Report.StiReport
    {
        public Auswertung_Belege()        {
            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="4">
    <LanStyle Ref="26" type="Stimulsoft.Report.StiChartStyle" isKey="true">
      <AxisLabelsColor>69, 95, 99</AxisLabelsColor>
      <AxisLineColor>69, 95, 99</AxisLineColor>
      <AxisTitleColor>69, 95, 99</AxisTitleColor>
      <BasicStyleColor>219, 245, 249</BasicStyleColor>
      <Border>None;[219:245:249];1;Solid;False;4;Black</Border>
      <Brush>[255:255:255]</Brush>
      <ChartAreaBorderColor>69, 95, 99</ChartAreaBorderColor>
      <ChartAreaBrush>GradientBrush,[255:255:255],[255:255:255],90</ChartAreaBrush>
      <Conditions isList="true" count="0" />
      <GridLinesHorColor>100, 69, 95, 99</GridLinesHorColor>
      <GridLinesVertColor>100, 69, 95, 99</GridLinesVertColor>
      <InterlacingHorBrush>[10:119:145:149]</InterlacingHorBrush>
      <InterlacingVertBrush>[10:119:145:149]</InterlacingVertBrush>
      <LegendBorderColor>119, 145, 149</LegendBorderColor>
      <LegendBrush>GradientBrush,[255:255:255],[239:255:255],90</LegendBrush>
      <LegendLabelsColor>69, 95, 99</LegendLabelsColor>
      <LegendTitleColor>69, 95, 99</LegendTitleColor>
      <Name>LanStyle</Name>
      <SeriesLabelsBorderColor>69, 95, 99</SeriesLabelsBorderColor>
      <SeriesLabelsBrush>[219:245:249]</SeriesLabelsBrush>
      <SeriesLabelsColor>69, 95, 99</SeriesLabelsColor>
      <SeriesLabelsLineColor>69, 95, 99</SeriesLabelsLineColor>
      <SeriesLighting>True</SeriesLighting>
      <SeriesShowBorder>True</SeriesShowBorder>
      <StyleColors>[3:50:108], [25:118:210], [71:145:219], [124:202:98], [165:198:73]</StyleColors>
      <TrendLineColor>69, 95, 99</TrendLineColor>
    </LanStyle>
    <LanHintergrundfarbe Ref="27" type="Stimulsoft.Report.StiStyle" isKey="true">
      <Border>Left, Right;[3:50:108];1;Solid;False;4;Black</Border>
      <Brush>[3:50:108]</Brush>
      <Conditions isList="true" count="0" />
      <Font>Arial,10,Bold</Font>
      <Name>LanHintergrundfarbe</Name>
      <NegativeTextBrush>Red</NegativeTextBrush>
      <TextBrush>White</TextBrush>
    </LanHintergrundfarbe>
    <HintergrundFarbe2 Ref="28" type="Stimulsoft.Report.StiStyle" isKey="true">
      <Border>Left, Right;[25:118:210];1;Solid;False;4;Black</Border>
      <Brush>[25:118:210]</Brush>
      <Conditions isList="true" count="0" />
      <Font>Arial,10,Bold</Font>
      <Name>HintergrundFarbe2</Name>
      <NegativeTextBrush>Red</NegativeTextBrush>
      <TextBrush>White</TextBrush>
    </HintergrundFarbe2>
    <HintergrundFarbe3 Ref="29" type="Stimulsoft.Report.StiStyle" isKey="true">
      <Brush>[71:145:219]</Brush>
      <Conditions isList="true" count="0" />
      <Font>Arial,10</Font>
      <Name>HintergrundFarbe3</Name>
      <NegativeTextBrush>Red</NegativeTextBrush>
      <TextBrush>White</TextBrush>
    </HintergrundFarbe3>
  </Styles>
</StiSerializer>