3rdpartylibs/fastreports.wpf/Demos/Reports.New/Script/Print Total in The Group Header.frx

<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" DoublePass="true" ReportInfo.Description="Demonstrates how to use a script to print group's total in the group header (normally it is printed in the group footer). To create such a report:&#13;&#10;- the idea is to collect group totals on the first report pass, and to print the collected values on the second pass. So you have to set the report to double-pass (this can be done in the Report|Options... menu).&#13;&#10;- switch to Code tab and see the script for more details." ReportInfo.Created="01/17/2008 04:31:41" ReportInfo.Modified="03/30/2023 02:26:23" 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
  {
    // The idea is to collect group totals on the first report pass, and to print
    // the collected values on the second pass. 
    
    // The variable that we going to print in the group header.
    private int total;
    
    // The list that will hold totals for each group.
    private List&lt;int&gt; totals = new List&lt;int&gt;();
    
    
    // This handler is called before printing the group header. To create this handler:
    // - select the group header;
    // - go Properties window;
    // - press &quot;Events&quot; button;
    // - select &quot;BeforePrint&quot; event and doubleclick it.
    private void GroupHeader1_BeforePrint(object sender, EventArgs e)
    {
      // Note: ((Int32)Report.GetVariableValue(&quot;Row#&quot;)) is a current group number;
      // this string is automatically inserted when you drag &amp; drop
      // the &quot;Row#&quot; system variable from the Data Dictionary window to the script.
      // This value is not zero-based.
      int groupNumber = ((Int32)Report.GetVariableValue(&quot;Row#&quot;));

      // If this pass is final, get the collected value.
      if (Engine.FinalPass)
        total = totals[groupNumber - 1];
    }

    // This handler is called before printing the group footer.
    private void GroupFooter1_BeforePrint(object sender, EventArgs e)
    {
      // Note: Report.GetTotalValue(&quot;TotalProducts&quot;) is a total value;
      // this string is automatically inserted when you drag &amp; drop
      // the &quot;TotalProducts&quot; total from the Data Dictionary window to the script.
      int totalValue = (int)Report.GetTotalValue(&quot;TotalProducts&quot;);
      
      // if this pass is not final, add the total value to the totals list.
      if (!Engine.FinalPass)
        totals.Add(totalValue);
    }
  }
}
</ScriptText>
  <Styles>
    <Style Name="EvenRows" Fill.Color="216, 233, 220" Font="Arial, 10pt"/>
  </Styles>
  <Dictionary>
    <TableDataSource Name="Products" ReferenceName="NorthWind.Products" DataType="System.Int32" Enabled="true">
      <Column Name="ProductID" DataType="System.Int32"/>
      <Column Name="ProductName" DataType="System.String"/>
      <Column Name="SupplierID" DataType="System.Int32"/>
      <Column Name="CategoryID" DataType="System.Int32"/>
      <Column Name="QuantityPerUnit" DataType="System.String"/>
      <Column Name="UnitPrice" DataType="System.Decimal"/>
      <Column Name="UnitsInStock" DataType="System.Int16"/>
      <Column Name="UnitsOnOrder" DataType="System.Int16"/>
      <Column Name="ReorderLevel" DataType="System.Int16"/>
      <Column Name="Discontinued" DataType="System.Boolean" BindableControl="CheckBox"/>
      <Column Name="EAN13" DataType="System.String"/>
    </TableDataSource>
    <Total Name="TotalProducts" TotalType="Count" Evaluator="Data1" PrintOn="GroupFooter1"/>
  </Dictionary>
  <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="37.8" CanGrow="true">
      <TextObject Name="Text1" Width="718.2" Height="37.8" Text="ALPHABETICAL PRODUCT LIST" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold"/>
    </ReportTitleBand>
    <GroupHeaderBand Name="GroupHeader1" Top="39.8" Width="718.2" Height="37.8" BeforePrintEvent="GroupHeader1_BeforePrint" KeepWithData="true" Condition="[Products.ProductName].Substring(0,1)" SortOrder="None">
      <TextObject Name="Text7" Left="9.45" Top="9.45" Width="538.65" Height="28.35" Border.Color="LightSkyBlue" Fill.Color="DarkSeaGreen" Text="[[Products.ProductName].Substring(0,1)]" Padding="5, 0, 0, 0" VertAlign="Center" Font="Segoe UI, 12pt, style=Bold" TextFill.Color="White"/>
      <TextObject Name="Text10" Left="548.1" Top="9.45" Width="160.65" Height="28.35" Border.Color="LightSkyBlue" Fill.Color="DarkSeaGreen" Text="Total: [total]" Padding="5, 0, 0, 0" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
      <DataBand Name="Data1" Top="79.6" Width="718.2" Height="18.9" DataSource="Products">
        <TextObject Name="Text4" Left="548.1" Width="160.65" Height="18.9" Border.Lines="Right" Border.Color="DarkSeaGreen" EvenStyle="EvenRows" Text="[Products.UnitPrice]" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
        <TextObject Name="Text2" Left="9.45" Width="538.65" Height="18.9" Border.Lines="Left" Border.Color="DarkSeaGreen" EvenStyle="EvenRows" Text="[Products.ProductName]" VertAlign="Center" Font="Segoe UI, 9pt"/>
        <Sort>
          <Sort Expression="[Products.ProductName]"/>
        </Sort>
      </DataBand>
      <GroupFooterBand Name="GroupFooter1" Top="100.5" Width="718.2" Height="28.35" BeforePrintEvent="GroupFooter1_BeforePrint" KeepWithData="true">
        <TextObject Name="Text8" Left="9.45" Width="699.3" Height="18.9" Border.Lines="Left, Right, Bottom" Border.Color="DarkSeaGreen" Text="Total products: [TotalProducts]" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
      </GroupFooterBand>
    </GroupHeaderBand>
    <PageFooterBand Name="PageFooter1" Top="130.85" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
      <TextObject Name="Text9" Left="614.25" Width="94.5" Height="28.35" Text="[PageN]" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
      <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>