Two Row Dimensions.frx 6.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates the matrix with two row dimensions. To create such a matrix:&#13;&#10;- drag and drop data from the Data window to create a row;&#13;&#10;- drag the next data to the right of the just created row. Watch the drag indicator to select the position of where to insert a new item;&#13;&#10;- you may drag the existing rows/columns/cells to a new position. To do this, select the appropriate cell, grab its border and drag it to the new position." ReportInfo.Created="05/16/2008 01:44:40" ReportInfo.Modified="03/30/2023 00:58:12" 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="96.3">
  17. <MatrixObject Name="Matrix1" Left="9.45" Top="8.56" Width="285.48" Height="78.29" FixedRows="1" FixedColumns="2" AutoSize="false" DataSource="MatrixDemo" Style="Orange">
  18. <MatrixColumns>
  19. <Header Expression="[MatrixDemo.Name]"/>
  20. </MatrixColumns>
  21. <MatrixRows>
  22. <Header Expression="[MatrixDemo.Year]"/>
  23. <Header Expression="[MatrixDemo.Month]"/>
  24. </MatrixRows>
  25. <MatrixCells>
  26. <Cell Expression="[MatrixDemo.Revenue]"/>
  27. </MatrixCells>
  28. <TableColumn Name="Column1" Width="48.26"/>
  29. <TableColumn Name="Column2" Width="47.33"/>
  30. <TableColumn Name="Column3" Width="106.11"/>
  31. <TableColumn Name="Column4" Width="83.78"/>
  32. <TableRow Name="Row1" Height="26.66">
  33. <TableCell Name="Cell1" Border.Lines="All" Border.Color="DimGray" Fill="Glass" Fill.Color="64, 64, 64" Fill.Blend="0.13" Fill.Hatch="false" Text="Year" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  34. <TableCell Name="Cell2" Border.Lines="All" Border.Color="DimGray" Fill="Glass" Fill.Color="64, 64, 64" Fill.Blend="0.13" Fill.Hatch="false" Text="Month" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  35. <TableCell Name="Cell7" Border.Lines="All" Border.Color="DimGray" Fill="Glass" Fill.Color="64, 64, 64" Fill.Blend="0.13" Fill.Hatch="false" Text="[Name]" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  36. <TableCell Name="Cell10" Border.Lines="All" Border.Color="DimGray" Fill="Glass" Fill.Color="64, 64, 64" Fill.Blend="0.13" Fill.Hatch="false" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
  37. </TableRow>
  38. <TableRow Name="Row2" Height="17.21">
  39. <TableCell Name="Cell3" Border.Lines="All" Border.Color="DarkGray" Fill.Color="64, 64, 64" Text="[Year]" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White" RowSpan="2"/>
  40. <TableCell Name="Cell4" Border.Lines="All" Border.Color="DarkGray" Fill.Color="64, 64, 64" Text="[Month]" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  41. <TableCell Name="Cell8" Border.Lines="All" Border.Color="DarkGray" Fill.Color="Gray" Text="[Revenue]" AllowExpressions="false" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  42. <TableCell Name="Cell11" Border.Lines="All" Border.Color="DarkGray" Fill.Color="Gray" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  43. </TableRow>
  44. <TableRow Name="Row5" Height="17.21">
  45. <TableCell Name="Cell5" Font="Segoe UI, 9pt"/>
  46. <TableCell Name="Cell6" Border.Lines="All" Border.Color="DarkGray" Fill.Color="64, 64, 64" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  47. <TableCell Name="Cell9" Border.Lines="All" Border.Color="DarkGray" Fill.Color="64, 64, 64" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  48. <TableCell Name="Cell12" Border.Lines="All" Border.Color="DarkGray" Fill.Color="64, 64, 64" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
  49. </TableRow>
  50. <TableRow Name="Row7" Height="17.21">
  51. <TableCell Name="Cell13" Border.Lines="All" Border.Color="DarkGray" Fill.Color="64, 64, 64" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White" ColSpan="2"/>
  52. <TableCell Name="Cell14" Font="Segoe UI, 9pt"/>
  53. <TableCell Name="Cell15" Border.Lines="All" Border.Color="DarkGray" Fill.Color="64, 64, 64" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
  54. <TableCell Name="Cell16" Border.Lines="All" Border.Color="DarkGray" Fill.Color="64, 64, 64" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
  55. </TableRow>
  56. </MatrixObject>
  57. </DataBand>
  58. <PageFooterBand Name="PageFooter1" Top="138.1" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
  59. <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"/>
  60. </PageFooterBand>
  61. </ReportPage>
  62. </Report>