Two Data Cells.frx 7.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates the following AdvMatrixObject features:&#13;&#10;- two adjacent data cells" ReportInfo.Created="05/16/2008 01:44:40" ReportInfo.Modified="04/07/2023 17:58:15" 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" Watermark.Font="Arial, 60pt">
  13. <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="37.8" CanGrow="true">
  14. <TextObject Name="Text1" Width="718.2" Height="37.8" Text="REVENUE BY EMPLOYEE" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold"/>
  15. </ReportTitleBand>
  16. <DataBand Name="Data1" Top="39.8" Width="718.2" Height="115.87">
  17. <AdvMatrixObject Name="Matrix1" Left="9.45" Top="11.92" Width="330.75" Height="103.95" Layout="Wrapped" WrappedGap="37.8" DataSource="MatrixDemo">
  18. <Columns>
  19. <Descriptor Expression="[MatrixDemo.Name]"/>
  20. <Descriptor DisplayText="Total"/>
  21. </Columns>
  22. <Rows>
  23. <Descriptor Expression="[MatrixDemo.Year]">
  24. <Descriptor DisplayText="Sum"/>
  25. <Descriptor DisplayText="Count"/>
  26. </Descriptor>
  27. <Descriptor DisplayText="Total">
  28. <Descriptor DisplayText="Sum"/>
  29. <Descriptor DisplayText="Count"/>
  30. </Descriptor>
  31. </Rows>
  32. <TableColumn Name="Column1"/>
  33. <TableColumn Name="Column2" Width="51.03"/>
  34. <TableColumn Name="Column3" Width="102.06" AutoSize="true"/>
  35. <TableColumn Name="Column4" Width="111.51" AutoSize="true"/>
  36. <TableRow Name="Row1" Height="28.35">
  37. <TableCell Name="Cell1" 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"/>
  38. <TableCell Name="Cell2" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="Month / Quarter" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  39. <TableCell Name="Cell21" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="[Name]" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  40. <TableCell Name="Cell7" 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"/>
  41. </TableRow>
  42. <TableRow Name="Row2">
  43. <TableCell Name="Cell1_" 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" RowSpan="2"/>
  44. <TableCell Name="Cell2_" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="Sum" AllowExpressions="false" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  45. <TableCell Name="Cell21_" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([MatrixDemo.Revenue])]" AllowExpressions="false" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  46. <TableCell Name="Cell7_" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([MatrixDemo.Revenue])]" AllowExpressions="false" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  47. </TableRow>
  48. <TableRow Name="Row3">
  49. <TableCell Name="Cell3" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" AllowExpressions="false" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  50. <TableCell Name="Cell4" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Text="Count" AllowExpressions="false" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  51. <TableCell Name="Cell41" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Count([MatrixDemo.Revenue])]" AllowExpressions="false" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  52. <TableCell Name="Cell8" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Count([MatrixDemo.Revenue])]" AllowExpressions="false" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  53. </TableRow>
  54. <TableRow Name="Row4">
  55. <TableCell Name="Cell5" 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" RowSpan="2"/>
  56. <TableCell Name="Cell6" Border.Lines="All" Border.Color="White" Fill.Color="110, 145, 190" Text="Sum" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  57. <TableCell Name="Cell61" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([MatrixDemo.Revenue])]" AllowExpressions="false" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  58. <TableCell Name="Cell9" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([MatrixDemo.Revenue])]" AllowExpressions="false" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  59. </TableRow>
  60. <TableRow Name="Row4">
  61. <TableCell Name="Cell8" 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"/>
  62. <TableCell Name="Cell10" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Text="Count" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  63. <TableCell Name="Cell12" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Count([MatrixDemo.Revenue])]" AllowExpressions="false" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  64. <TableCell Name="Cell13" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Count([MatrixDemo.Revenue])]" AllowExpressions="false" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  65. </TableRow>
  66. </AdvMatrixObject>
  67. </DataBand>
  68. <PageFooterBand Name="PageFooter1" Top="157.67" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
  69. <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"/>
  70. </PageFooterBand>
  71. </ReportPage>
  72. </Report>