3rdpartylibs/fastreports.wpf/Demos/Reports.New/Miscellaneous/Databand Columns, Row Numbers.frx

<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates the databand columns feature. To use it:&#13;&#10;- select a data band;&#13;&#10;- go to the &quot;Properties&quot; window and open the &quot;Columns&quot; property;&#13;&#10;- set the &quot;Count&quot; property to 2 or more;&#13;&#10;- set the &quot;Layout&quot; property if needed.&#13;&#10;&#13;&#10;To print a row number, use the &quot;Row#&quot; system variable. Row numbers will reset on each new group. The &quot;AbsRow#&quot; system variable will display absolute numbers that are not reset by a group." ReportInfo.Created="01/17/2008 04:31:41" ReportInfo.Modified="03/28/2023 20:02:49" ReportInfo.CreatorVersion="1.0.0.0">
  <Styles>
    <Style Name="EvenRows" Fill.Color="OldLace" 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>
  </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="47.25" KeepWithData="true" Condition="[Products.ProductName].Substring(0,1)">
      <TextObject Name="Text7" Top="9.45" Width="37.8" Height="37.8" Border.Color="LightSkyBlue" Fill.Color="110, 145, 190" Text="[[Products.ProductName].Substring(0,1)]" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold" TextFill.Color="White"/>
      <DataBand Name="Data1" Top="89.05" Width="359.1" Height="18.9" DataSource="Products" Columns.Count="2">
        <TextObject Name="Text2" Left="37.8" Width="264.6" Height="18.9" Text="[Products.ProductName]" VertAlign="Center" Font="Segoe UI, 9pt"/>
        <TextObject Name="Text3" Width="37.8" Height="18.9" Text="[Row#]." HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
        <Sort>
          <Sort Expression="[Products.ProductName]"/>
        </Sort>
      </DataBand>
    </GroupHeaderBand>
    <PageFooterBand Name="PageFooter1" Top="109.95" 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>