Duplicate Values.frx 3.1 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates the &quot;Duplicates&quot; feature. To use it:&#13;&#10;- select a Text object that prints duplicate values;&#13;&#10;- set its &quot;Duplicates&quot; property to one of the following: &#13;&#10; - &quot;Show&quot; will show duplicates;&#13;&#10; - &quot;Hide&quot; will hide the object;&#13;&#10; - &quot;Clear&quot; will clear the object's text but show the object;&#13;&#10; - &quot;Merge&quot; will merge objects with the same values." ReportInfo.Created="01/17/2008 04:31:41" ReportInfo.Modified="04/08/2023 14:10:14" ReportInfo.CreatorVersion="1.0.0.0">
  3. <Styles>
  4. <Style Name="EvenRows" Fill.Color="AliceBlue" Font="Arial, 10pt"/>
  5. </Styles>
  6. <Dictionary>
  7. <TableDataSource Name="Products" ReferenceName="NorthWind.Products" DataType="System.Int32" Enabled="true">
  8. <Column Name="ProductID" DataType="System.Int32"/>
  9. <Column Name="ProductName" DataType="System.String"/>
  10. <Column Name="SupplierID" DataType="System.Int32"/>
  11. <Column Name="CategoryID" DataType="System.Int32"/>
  12. <Column Name="QuantityPerUnit" DataType="System.String"/>
  13. <Column Name="UnitPrice" DataType="System.Decimal"/>
  14. <Column Name="UnitsInStock" DataType="System.Int16"/>
  15. <Column Name="UnitsOnOrder" DataType="System.Int16"/>
  16. <Column Name="ReorderLevel" DataType="System.Int16"/>
  17. <Column Name="Discontinued" DataType="System.Boolean" BindableControl="CheckBox"/>
  18. <Column Name="EAN13" DataType="System.String"/>
  19. </TableDataSource>
  20. </Dictionary>
  21. <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
  22. <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="37.8" CanGrow="true">
  23. <TextObject Name="Text1" Width="718.2" Height="37.8" Text="ALPHABETICAL PRODUCT LIST" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold"/>
  24. </ReportTitleBand>
  25. <DataBand Name="Data1" Top="39.8" Width="718.2" Height="28.35" CanGrow="true" EvenStyle="EvenRows" DataSource="Products">
  26. <TextObject Name="Text2" Left="56.7" Width="264.6" Height="28.35" Text="[Products.ProductName]" VertAlign="Center" Font="Segoe UI, 9pt"/>
  27. <TextObject Name="Text7" Width="37.8" Height="28.35" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" CanGrow="true" Text="[[Products.ProductName].Substring(0,1)]" Duplicates="Merge" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold" TextFill.Color="White"/>
  28. <Sort>
  29. <Sort Expression="[Products.ProductName]"/>
  30. </Sort>
  31. </DataBand>
  32. <PageFooterBand Name="PageFooter1" Top="70.15" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
  33. <TextObject Name="Text9" Left="614.25" Width="94.5" Height="28.35" Text="[PageN]" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  34. <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"/>
  35. </PageFooterBand>
  36. </ReportPage>
  37. </Report>