3rdpartylibs/fastreports.wpf/Demos/Reports.New/Advanced Matrix/Stepped Layout.frx

<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates the following AdvMatrixObject features:&#13;&#10;- collapse/expand header elements;&#13;&#10;- stepped layout of row groups;&#13;&#10;- use of Display Text setting for &quot;Month&quot; element" ReportInfo.Created="09/01/2021 21:12:23" ReportInfo.Modified="04/07/2023 01:06:24" ReportInfo.CreatorVersion="1.0.0.0">
  <Dictionary>
    <TableDataSource Name="MatrixDemo" ReferenceName="NorthWind.MatrixDemo" DataType="System.Int32" Enabled="true">
      <Column Name="Name" DataType="System.String"/>
      <Column Name="Year" DataType="System.Int32"/>
      <Column Name="Month" DataType="System.Int32"/>
      <Column Name="ItemsSold" DataType="System.Int32"/>
      <Column Name="Revenue" DataType="System.Decimal"/>
    </TableDataSource>
  </Dictionary>
  <ReportPage Name="Page1" RawPaperSize="9" Watermark.Font="Arial, 60pt" LastPageSource="15" FirstPageSource="15">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="37.8" CanGrow="true">
      <TextObject Name="Text1" Width="718.2" Height="37.8" Text="REVENUE BY EMPLOYEES" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold"/>
    </ReportTitleBand>
    <DataBand Name="Data1" Top="39.8" Width="718.2" Height="113.4">
      <AdvMatrixObject Name="AdvMatrix1" Left="15.12" Top="20.79" Width="343.98" Height="85.05" DataSource="MatrixDemo" Style="BlueWhite">
        <Columns>
          <Descriptor Expression="[MatrixDemo.Name]"/>
          <Descriptor DisplayText="Total"/>
        </Columns>
        <Rows>
          <Descriptor Expression="[MatrixDemo.Year]" Stepped="true">
            <Descriptor Expression="[MatrixDemo.Month]" DisplayText="[MonthName([MatrixDemo.Month])]" VisibleToggledBy="CollapseButton1"/>
          </Descriptor>
          <Descriptor DisplayText="Total"/>
        </Rows>
        <TableColumn Name="Column1" Width="111.51" AutoSize="true"/>
        <TableColumn Name="Column2" Width="122.85" AutoSize="true"/>
        <TableColumn Name="Column3" Width="109.62" AutoSize="true"/>
        <TableRow Name="Row1" Height="28.35">
          <TableCell Name="Cell1" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="Year/Month" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
          <TableCell Name="Cell2" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="[MatrixDemo.Name]" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
          <TableCell Name="Cell5" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="Total" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
        </TableRow>
        <TableRow Name="Row2">
          <TableCell Name="Cell3" Border.Lines="All" Border.Color="White" Fill.Color="Gainsboro" Text="[MatrixDemo.Year]" Padding="16, 1, 2, 1" AllowExpressions="false" VertAlign="Center" Font="Segoe UI, 9pt">
            <MatrixCollapseButton Name="CollapseButton1" Width="16" Height="18.9" Dock="Left" SymbolSize="5"/>
          </TableCell>
          <TableCell Name="Cell4" Border.Lines="All" Border.Color="White" Fill.Color="Gainsboro" Text="[Sum([MatrixDemo.Revenue])]" AllowExpressions="false" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" Font="Segoe UI, 9pt"/>
          <TableCell Name="Cell6" Border.Lines="All" Border.Color="White" Fill.Color="Gainsboro" Text="[Sum([MatrixDemo.Revenue])]" AllowExpressions="false" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" WordWrap="false" Font="Segoe UI, 9pt"/>
        </TableRow>
        <TableRow Name="Row3">
          <TableCell Name="Cell7" Border.Lines="All" Border.Color="WhiteSmoke" Text="[MatrixDemo.Month]" Padding="20, 1, 2, 1" AllowExpressions="false" VertAlign="Center" Font="Segoe UI, 9pt"/>
          <TableCell Name="Cell8" Border.Lines="All" Border.Color="WhiteSmoke" Text="[Sum([MatrixDemo.Revenue])]" AllowExpressions="false" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" Font="Segoe UI, 9pt"/>
          <TableCell Name="Cell9" Border.Lines="All" Border.Color="WhiteSmoke" Fill.Color="White" Text="[Sum([MatrixDemo.Revenue])]" AllowExpressions="false" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" WordWrap="false" Font="Segoe UI, 9pt"/>
        </TableRow>
        <TableRow Name="Row4">
          <TableCell Name="Cell10" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
          <TableCell Name="Cell11" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="[Sum([MatrixDemo.Revenue])]" AllowExpressions="false" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
          <TableCell Name="Cell12" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="[Sum([MatrixDemo.Revenue])]" AllowExpressions="false" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" WordWrap="false" Font="Segoe UI, 9pt" TextFill.Color="White"/>
        </TableRow>
      </AdvMatrixObject>
    </DataBand>
    <PageFooterBand Name="PageFooter1" Top="155.2" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
      <TextObject Name="Text12" Left="9.45" Width="217.35" Height="28.35" Cursor="Hand" Hyperlink.Value="https://www.fast-report.com/en/product/fast-report-net/" Text="Generated by FastReport" VertAlign="Center" Font="Segoe UI, 9pt, style=Underline" TextFill.Color="Blue"/>
    </PageFooterBand>
  </ReportPage>
</Report>