3rdpartylibs/fastreports.wpf/Demos/Reports.New/Table/Complex Column Headers.frx

<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates how to print multiple Table rows and columns with a script. To do this:&#13;&#10;- select the Table object;&#13;&#10;- go to the &quot;Properties&quot; window and click the &quot;Events&quot; button to view list of available events;&#13;&#10;- doubleclick the &quot;ManualBuild&quot; event;&#13;&#10;- you will see an empty event handler. You need to print rows using TableObject.PrintRow method; in each row, you must also print all columns (using PrintColumns method). See the script's code for more details.&#13;&#10;&#13;&#10;When you run a report, the Table will repeat its rows and columns and fill them with data. Note that cell spans are handled automatically.&#13;&#10;&#13;&#10;Note that this report is not bound to any data; all table cell values are static." ReportInfo.Created="05/16/2008 00:56:09" ReportInfo.Modified="04/07/2023 18:07:47" ReportInfo.CreatorVersion="1.0.0.0">
  <ScriptText>using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Windows.Forms;
using System.Drawing;
using System.Data;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;

namespace FastReport
{
  public class ReportScript
  {

    private void Table1_ManualBuild(object sender, EventArgs e)
    {
      // we will print header, then two &quot;Year&quot; groups (first one with 2 and 
      // second with 3 &quot;Month&quot; groups), then total
      int[] columnIndices = new int[] { 0, 1, 1, 2, 1, 1, 1, 2, 3 };
      
      // print header (first 2 rows), then four &quot;Employee&quot; rows, then total
      int[] rowIndices = new int[] { 0, 1, 2, 2, 2, 2, 3 };
      
      // print rows/columns
      foreach (int rowIndex in rowIndices)
      {
        Table1.PrintRow(rowIndex);
        foreach (int columnIndex in columnIndices)
        {
          Table1.PrintColumn(columnIndex);
        }
      }
    }
  }
}
</ScriptText>
  <Dictionary/>
  <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="37.8" CanGrow="true"/>
    <DataBand Name="Data1" Top="39.8" Width="718.2" Height="91.01">
      <TableObject Name="Table1" Left="9.45" Top="5.96" Width="274.05" Height="75.6" ManualBuildEvent="Table1_ManualBuild">
        <TableColumn Name="Column1" Width="75.6"/>
        <TableColumn Name="Column2"/>
        <TableColumn Name="Column3"/>
        <TableColumn Name="Column4"/>
        <TableRow Name="Row1">
          <TableCell Name="Cell1" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White" RowSpan="2"/>
          <TableCell Name="Cell2" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="Year" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White" ColSpan="2"/>
          <TableCell Name="Cell3" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt"/>
          <TableCell Name="Cell19" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White" RowSpan="2"/>
        </TableRow>
        <TableRow Name="Row2">
          <TableCell Name="Cell6" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
          <TableCell Name="Cell7" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="Month" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
          <TableCell Name="Cell8" 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="Cell20" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Font="Segoe UI, 9pt"/>
        </TableRow>
        <TableRow Name="Row3">
          <TableCell Name="Cell11" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="Employee" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
          <TableCell Name="Cell12" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="0" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
          <TableCell Name="Cell13" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="0" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
          <TableCell Name="Cell21" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="0" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
        </TableRow>
        <TableRow Name="Row4">
          <TableCell Name="Cell16" 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="Cell17" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="0" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
          <TableCell Name="Cell18" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="0" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
          <TableCell Name="Cell22" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="0" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
        </TableRow>
      </TableObject>
    </DataBand>
    <PageFooterBand Name="PageFooter1" Top="132.81" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
      <TextObject Name="Text12" 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>