Matrix With Rows Only.frx 4.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates how to create a matrix with no columns. To do this:&#13;&#10;- drag the data from the Data window to create a row and a cell;&#13;&#10;- we are not going to print the first row that contains column headers (they are empty). To do this, doubleclick the left-top cell and clear the text;&#13;&#10;- instead we are going to print the title. To enable it: right-click the left-top corner of the matrix (where you see the &quot;move&quot; indicator) to show the matrix context menu, and click &quot;Show Title&quot; item to enable the matrix title;&#13;&#10;- set the title text." ReportInfo.Created="05/16/2008 01:44:40" ReportInfo.Modified="04/07/2023 18:00:53" 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="107.2">
  17. <MatrixObject Name="Matrix1" Left="9.45" Top="4.94" Width="203.06" Height="102.26" FixedRows="2" FixedColumns="1" AutoSize="false" DataSource="MatrixDemo" ShowTitle="true" Style="Orange">
  18. <MatrixColumns/>
  19. <MatrixRows>
  20. <Header Expression="[MatrixDemo.Name]"/>
  21. </MatrixRows>
  22. <MatrixCells>
  23. <Cell Expression="[MatrixDemo.Revenue]"/>
  24. </MatrixCells>
  25. <TableColumn Name="Column1" Width="102.78"/>
  26. <TableColumn Name="Column2" Width="100.28"/>
  27. <TableRow Name="Row1" Height="26.66">
  28. <TableCell Name="Cell1" Border.Lines="All" Border.Color="White" Fill.Color="130, 180, 130" Text="Employee" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  29. <TableCell Name="Cell2" Border.Lines="All" Border.Color="White" Fill.Color="130, 180, 130" Text="Revenue" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  30. </TableRow>
  31. <TableRow Name="Row2" Visible="false">
  32. <TableCell Name="Cell3" Border.Lines="All" Border.Color="White" Fill.Color="130, 180, 130" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt"/>
  33. <TableCell Name="Cell4" Fill.Color="WhiteSmoke" Text="Drag data here to&#13;&#10; create a new column" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="Gray"/>
  34. </TableRow>
  35. <TableRow Name="Row4" Height="28.35">
  36. <TableCell Name="Cell5" Border.Lines="All" Border.Color="White" Fill.Color="130, 180, 130" Text="[Name]" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt"/>
  37. <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"/>
  38. </TableRow>
  39. <TableRow Name="Row5" Height="28.35">
  40. <TableCell Name="Cell7" Border.Lines="All" Border.Color="White" Fill.Color="130, 180, 130" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  41. <TableCell Name="Cell8" 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"/>
  42. </TableRow>
  43. </MatrixObject>
  44. </DataBand>
  45. <PageFooterBand Name="PageFooter1" Top="149" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
  46. <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"/>
  47. </PageFooterBand>
  48. </ReportPage>
  49. </Report>