Two Matrices.frx 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates how to print two Matrix objects side-by-side. To do this:&#13;&#10;- put two Matrix objects on the same band, side-by-side." ReportInfo.Created="05/16/2008 01:44:40" ReportInfo.Modified="03/18/2024 12:32:06" ReportInfo.CreatorVersion="1.0.0.0">
  3. <Dictionary>
  4. <TableDataSource Name="MatrixDemo" ReferenceName="NorthWind.MatrixDemo" DataType="System.Int32" Enabled="true">
  5. <Column Name="Name" DataType="System.String"/>
  6. <Column Name="Year" DataType="System.Int32"/>
  7. <Column Name="Month" DataType="System.Int32"/>
  8. <Column Name="ItemsSold" DataType="System.Int32"/>
  9. <Column Name="Revenue" DataType="System.Decimal"/>
  10. </TableDataSource>
  11. </Dictionary>
  12. <ReportPage Name="Page1" Landscape="true" PaperWidth="297" PaperHeight="210" RawPaperSize="9" Watermark.Font="Arial, 60pt">
  13. <ReportTitleBand Name="ReportTitle1" Width="1047.06" Height="37.8" CanGrow="true">
  14. <TextObject Name="Text1" Width="1048.95" Height="37.8" Text="REVENUE AND ITEMS SOLD BY EMPLOYEE" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold"/>
  15. </ReportTitleBand>
  16. <DataBand Name="Data1" Top="39.8" Width="1047.06" Height="102.23">
  17. <MatrixObject Name="Matrix1" Left="9.45" Top="7.73" Width="283.5" Height="85.05" FixedRows="2" FixedColumns="1" Layout="DownThenAcross" AutoSize="false" DataSource="MatrixDemo" ShowTitle="true" Style="Orange">
  18. <MatrixColumns>
  19. <Header Expression="[MatrixDemo.Year]"/>
  20. </MatrixColumns>
  21. <MatrixRows>
  22. <Header Expression="[MatrixDemo.Name]"/>
  23. </MatrixRows>
  24. <MatrixCells>
  25. <Cell Expression="[MatrixDemo.Revenue]"/>
  26. </MatrixCells>
  27. <TableColumn Name="Column1" Width="103.95"/>
  28. <TableColumn Name="Column2" Width="85.05"/>
  29. <TableColumn Name="Column3" Width="94.5"/>
  30. <TableRow Name="Row1">
  31. <TableCell Name="Cell1" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  32. <TableCell Name="Cell2" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Text="Revenue" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 10pt, style=Bold" TextFill.Color="White" ColSpan="2"/>
  33. <TableCell Name="Cell7" Fill.Color="200, 160, 120" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  34. </TableRow>
  35. <TableRow Name="Row2" Height="28.35">
  36. <TableCell Name="Cell3" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Text="Employee" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  37. <TableCell Name="Cell4" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Text="[Year]" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  38. <TableCell Name="Cell8" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
  39. </TableRow>
  40. <TableRow Name="Row4">
  41. <TableCell Name="Cell5" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Text="[Name]" AllowExpressions="false" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  42. <TableCell Name="Cell6" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Revenue]" AllowExpressions="false" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  43. <TableCell Name="Cell9" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  44. </TableRow>
  45. <TableRow Name="Row11">
  46. <TableCell Name="Cell28" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
  47. <TableCell Name="Cell29" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  48. <TableCell Name="Cell30" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  49. </TableRow>
  50. </MatrixObject>
  51. <MatrixObject Name="Matrix3" Left="292.95" Top="7.73" Width="95.5" Height="85.05" FixedRows="2" FixedColumns="1" Layout="DownThenAcross" AutoSize="false" DataSource="MatrixDemo" ShowTitle="true" Style="Orange">
  52. <MatrixColumns>
  53. <Header Expression="[MatrixDemo.Year]"/>
  54. </MatrixColumns>
  55. <MatrixRows>
  56. <Header Expression="[MatrixDemo.Name]"/>
  57. </MatrixRows>
  58. <MatrixCells>
  59. <Cell Expression="[MatrixDemo.ItemsSold]"/>
  60. </MatrixCells>
  61. <TableColumn Name="Column7" Visible="false" Width="1"/>
  62. <TableColumn Name="Column8" Width="47.25"/>
  63. <TableColumn Name="Column9" Width="47.25"/>
  64. <TableRow Name="Row8">
  65. <TableCell Name="Cell19" Border.Lines="All" Border.Color="White" Fill.Color="255, 218, 70" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 10pt"/>
  66. <TableCell Name="Cell20" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="Items sold" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 10pt, style=Bold" TextFill.Color="White" ColSpan="2"/>
  67. <TableCell Name="Cell21" Fill.Color="110, 145, 190" Font="Segoe UI, 10pt" TextFill.Color="White"/>
  68. </TableRow>
  69. <TableRow Name="Row9" Height="28.35">
  70. <TableCell Name="Cell22" Border.Lines="All" Border.Color="White" Fill="Glass" Fill.Color="Gold" Fill.Blend="0.35" Fill.Hatch="true" Text="Employee" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt"/>
  71. <TableCell Name="Cell23" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="[Year]" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  72. <TableCell Name="Cell24" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
  73. </TableRow>
  74. <TableRow Name="Row10">
  75. <TableCell Name="Cell25" Border.Lines="All" Border.Color="White" Fill.Color="255, 218, 70" Text="[Name]" AllowExpressions="false" VertAlign="Center" Font="Segoe UI, 9pt"/>
  76. <TableCell Name="Cell26" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[ItemsSold]" AllowExpressions="false" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  77. <TableCell Name="Cell27" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  78. </TableRow>
  79. <TableRow Name="Row12">
  80. <TableCell Name="Cell31" Border.Lines="All" Border.Color="White" Fill.Color="255, 218, 70" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  81. <TableCell Name="Cell32" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  82. <TableCell Name="Cell33" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  83. </TableRow>
  84. </MatrixObject>
  85. </DataBand>
  86. <PageFooterBand Name="PageFooter1" Top="144.03" Width="1047.06" Height="28.35" Fill.Color="WhiteSmoke">
  87. <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"/>
  88. </PageFooterBand>
  89. </ReportPage>
  90. </Report>