Home Explore Help
Register Sign In
PRSDigital
/
3rdpartylibs
3
0
Fork 0
Files Pull Requests 0
Branch: master
Branches Tags
3rdpartylibs
/
fastreports.wpf
/
Demos
/
Reports.New
/
Simple Matrix
/
Using Expressions.frx

Using Expressions.frx 12 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146 
  1. <?xml version="1.0" encoding="utf-8"?>
    2. 

  2. <Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates how to use expressions in the matrix. To do this:&#13;&#10;- create a matrix by dragging data from the Data Dictionary window;&#13;&#10;- doubleclick the item that you want to edit, and change the expression." ReportInfo.Created="05/15/2008 00:47:48" ReportInfo.Modified="03/30/2023 01:29:21" ReportInfo.CreatorVersion="1.0.0.0">
    3. 

  3.   <Dictionary>
    4. 

  4.     <TableDataSource Name="Categories" ReferenceName="NorthWind.Categories" DataType="System.Int32" Enabled="true">
    5. 

  5.       <Column Name="CategoryID" DataType="System.Int32"/>
    6. 

  6.       <Column Name="CategoryName" DataType="System.String"/>
    7. 

  7.       <Column Name="Description" DataType="System.String"/>
    8. 

  8.       <Column Name="Picture" DataType="System.Byte[]" BindableControl="Picture"/>
    9. 

  9.     </TableDataSource>
    10. 

  10.     <TableDataSource Name="Customers" ReferenceName="NorthWind.Customers" DataType="System.Int32" Enabled="true">
    11. 

  11.       <Column Name="CustomerID" DataType="System.String"/>
    12. 

  12.       <Column Name="CompanyName" DataType="System.String"/>
    13. 

  13.       <Column Name="ContactName" DataType="System.String"/>
    14. 

  14.       <Column Name="ContactTitle" DataType="System.String"/>
    15. 

  15.       <Column Name="Address" DataType="System.String"/>
    16. 

  16.       <Column Name="City" DataType="System.String"/>
    17. 

  17.       <Column Name="Region" DataType="System.String"/>
    18. 

  18.       <Column Name="PostalCode" DataType="System.String"/>
    19. 

  19.       <Column Name="Country" DataType="System.String"/>
    20. 

  20.       <Column Name="Phone" DataType="System.String"/>
    21. 

  21.       <Column Name="Fax" DataType="System.String"/>
    22. 

  22.     </TableDataSource>
    23. 

  23.     <TableDataSource Name="Employees" ReferenceName="NorthWind.Employees" DataType="System.Int32" Enabled="true">
    24. 

  24.       <Column Name="EmployeeID" DataType="System.Int32"/>
    25. 

  25.       <Column Name="LastName" DataType="System.String"/>
    26. 

  26.       <Column Name="FirstName" DataType="System.String"/>
    27. 

  27.       <Column Name="Title" DataType="System.String"/>
    28. 

  28.       <Column Name="TitleOfCourtesy" DataType="System.String"/>
    29. 

  29.       <Column Name="BirthDate" DataType="System.DateTime"/>
    30. 

  30.       <Column Name="HireDate" DataType="System.DateTime"/>
    31. 

  31.       <Column Name="Address" DataType="System.String"/>
    32. 

  32.       <Column Name="City" DataType="System.String"/>
    33. 

  33.       <Column Name="Region" DataType="System.String"/>
    34. 

  34.       <Column Name="PostalCode" DataType="System.String"/>
    35. 

  35.       <Column Name="Country" DataType="System.String"/>
    36. 

  36.       <Column Name="HomePhone" DataType="System.String"/>
    37. 

  37.       <Column Name="Extension" DataType="System.String"/>
    38. 

  38.       <Column Name="Photo" DataType="System.Byte[]" BindableControl="Picture"/>
    39. 

  39.       <Column Name="Notes" DataType="System.String"/>
    40. 

  40.       <Column Name="ReportsTo" DataType="System.Int32"/>
    41. 

  41.     </TableDataSource>
    42. 

  42.     <TableDataSource Name="Order Details" ReferenceName="NorthWind.Order Details" DataType="System.Int32" Enabled="true">
    43. 

  43.       <Column Name="OrderID" DataType="System.Int32"/>
    44. 

  44.       <Column Name="ProductID" DataType="System.Int32"/>
    45. 

  45.       <Column Name="UnitPrice" DataType="System.Decimal"/>
    46. 

  46.       <Column Name="Quantity" DataType="System.Int16"/>
    47. 

  47.       <Column Name="Discount" DataType="System.Single"/>
    48. 

  48.     </TableDataSource>
    49. 

  49.     <TableDataSource Name="Orders" ReferenceName="NorthWind.Orders" DataType="System.Int32" Enabled="true">
    50. 

  50.       <Column Name="OrderID" DataType="System.Int32"/>
    51. 

  51.       <Column Name="CustomerID" DataType="System.String"/>
    52. 

  52.       <Column Name="EmployeeID" DataType="System.Int32"/>
    53. 

  53.       <Column Name="OrderDate" DataType="System.DateTime"/>
    54. 

  54.       <Column Name="RequiredDate" DataType="System.DateTime"/>
    55. 

  55.       <Column Name="ShippedDate" DataType="System.DateTime"/>
    56. 

  56.       <Column Name="ShipVia" DataType="System.Int32"/>
    57. 

  57.       <Column Name="Freight" DataType="System.Decimal"/>
    58. 

  58.       <Column Name="ShipName" DataType="System.String"/>
    59. 

  59.       <Column Name="ShipAddress" DataType="System.String"/>
    60. 

  60.       <Column Name="ShipCity" DataType="System.String"/>
    61. 

  61.       <Column Name="ShipRegion" DataType="System.String"/>
    62. 

  62.       <Column Name="ShipPostalCode" DataType="System.String"/>
    63. 

  63.       <Column Name="ShipCountry" DataType="System.String"/>
    64. 

  64.       <Column Name="Latitude" DataType="System.Double"/>
    65. 

  65.       <Column Name="Longitude" DataType="System.Double"/>
    66. 

  66.     </TableDataSource>
    67. 

  67.     <TableDataSource Name="Products" ReferenceName="NorthWind.Products" DataType="System.Int32" Enabled="true">
    68. 

  68.       <Column Name="ProductID" DataType="System.Int32"/>
    69. 

  69.       <Column Name="ProductName" DataType="System.String"/>
    70. 

  70.       <Column Name="SupplierID" DataType="System.Int32"/>
    71. 

  71.       <Column Name="CategoryID" DataType="System.Int32"/>
    72. 

  72.       <Column Name="QuantityPerUnit" DataType="System.String"/>
    73. 

  73.       <Column Name="UnitPrice" DataType="System.Decimal"/>
    74. 

  74.       <Column Name="UnitsInStock" DataType="System.Int16"/>
    75. 

  75.       <Column Name="UnitsOnOrder" DataType="System.Int16"/>
    76. 

  76.       <Column Name="ReorderLevel" DataType="System.Int16"/>
    77. 

  77.       <Column Name="Discontinued" DataType="System.Boolean" BindableControl="CheckBox"/>
    78. 

  78.       <Column Name="EAN13" DataType="System.String"/>
    79. 

  79.     </TableDataSource>
    80. 

  80.     <TableDataSource Name="Shippers" ReferenceName="NorthWind.Shippers" DataType="System.Int32" Enabled="true">
    81. 

  81.       <Column Name="ShipperID" DataType="System.Int32"/>
    82. 

  82.       <Column Name="CompanyName" DataType="System.String"/>
    83. 

  83.       <Column Name="Phone" DataType="System.String"/>
    84. 

  84.     </TableDataSource>
    85. 

  85.     <TableDataSource Name="Suppliers" ReferenceName="NorthWind.Suppliers" DataType="System.Int32" Enabled="true">
    86. 

  86.       <Column Name="SupplierID" DataType="System.Int32"/>
    87. 

  87.       <Column Name="CompanyName" DataType="System.String"/>
    88. 

  88.       <Column Name="ContactName" DataType="System.String"/>
    89. 

  89.       <Column Name="ContactTitle" DataType="System.String"/>
    90. 

  90.       <Column Name="Address" DataType="System.String"/>
    91. 

  91.       <Column Name="City" DataType="System.String"/>
    92. 

  92.       <Column Name="Region" DataType="System.String"/>
    93. 

  93.       <Column Name="PostalCode" DataType="System.String"/>
    94. 

  94.       <Column Name="Country" DataType="System.String"/>
    95. 

  95.       <Column Name="Phone" DataType="System.String"/>
    96. 

  96.       <Column Name="Fax" DataType="System.String"/>
    97. 

  97.       <Column Name="HomePage" DataType="System.String"/>
    98. 

  98.     </TableDataSource>
    99. 

  99.     <Relation Name="SuppliersProducts" ReferenceName="NorthWind.SuppliersProducts" ParentDataSource="Suppliers" ChildDataSource="Products" ParentColumns="SupplierID" ChildColumns="SupplierID" Enabled="true"/>
    100. 

  100.     <Relation Name="CategoriesProducts" ReferenceName="NorthWind.CategoriesProducts" ParentDataSource="Categories" ChildDataSource="Products" ParentColumns="CategoryID" ChildColumns="CategoryID" Enabled="true"/>
    101. 

  101.     <Relation Name="EmployeesOrders" ReferenceName="NorthWind.EmployeesOrders" ParentDataSource="Employees" ChildDataSource="Orders" ParentColumns="EmployeeID" ChildColumns="EmployeeID" Enabled="true"/>
    102. 

  102.     <Relation Name="ShippersOrders" ReferenceName="NorthWind.ShippersOrders" ParentDataSource="Shippers" ChildDataSource="Orders" ParentColumns="ShipperID" ChildColumns="ShipVia" Enabled="true"/>
    103. 

  103.     <Relation Name="CustomersOrders" ReferenceName="NorthWind.CustomersOrders" ParentDataSource="Customers" ChildDataSource="Orders" ParentColumns="CustomerID" ChildColumns="CustomerID" Enabled="true"/>
    104. 

  104.     <Relation Name="OrdersOrderDetails" ReferenceName="NorthWind.OrdersOrderDetails" ParentDataSource="Orders" ChildDataSource="Order Details" ParentColumns="OrderID" ChildColumns="OrderID" Enabled="true"/>
    105. 

  105.     <Relation Name="ProductsOrderDetails" ReferenceName="NorthWind.ProductsOrderDetails" ParentDataSource="Products" ChildDataSource="Order Details" ParentColumns="ProductID" ChildColumns="ProductID" Enabled="true"/>
    106. 

  106.   </Dictionary>
    107. 

  107.   <ReportPage Name="Page1" Landscape="true" PaperWidth="297" PaperHeight="210" RawPaperSize="9" Watermark.Font="Arial, 60pt" UnlimitedHeight="true" UnlimitedWidth="true" LastPageSource="15" FirstPageSource="15">
    108. 

  108.     <ReportTitleBand Name="ReportTitle1" Width="1047.06" Height="37.8" CanGrow="true">
    109. 

  109.       <TextObject Name="Text1" Width="1048.95" Height="37.8" Text="PRODUCTS BY EMPLOYEES" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold"/>
    110. 

  110.     </ReportTitleBand>
    111. 

  111.     <DataBand Name="Data1" Top="39.8" Width="1047.06" Height="193.71">
    112. 

  112.       <MatrixObject Name="Matrix1" Top="11.16" Width="316.92" Height="173.1" FixedRows="1" FixedColumns="1" DataSource="Order Details" Style="Green">
    113. 

  113.         <MatrixColumns>
    114. 

  114.           <Header Expression="[Order Details.Orders.Employees.FirstName] + &quot; &quot; + [Order Details.Orders.Employees.LastName]"/>
    115. 

  115.         </MatrixColumns>
    116. 

  116.         <MatrixRows>
    117. 

  117.           <Header Expression="[Order Details.Products.ProductName]"/>
    118. 

  118.         </MatrixRows>
    119. 

  119.         <MatrixCells>
    120. 

  120.           <Cell Expression="[Order Details.UnitPrice] * [Order Details.Quantity] * (decimal)(1 - [Order Details.Discount])"/>
    121. 

  121.         </MatrixCells>
    122. 

  122.         <TableColumn Name="Column1" MaxWidth="151.2" Width="91.73" AutoSize="true"/>
    123. 

  123.         <TableColumn Name="Column2" MaxWidth="189" Width="189" AutoSize="true"/>
    124. 

  124.         <TableColumn Name="Column3" Width="36.19" AutoSize="true"/>
    125. 

  125.         <TableRow Name="Row1" Height="84.3" AutoSize="true">
    126. 

  126.           <TableCell Name="Cell1" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Text="Product" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
    127. 

  127.           <TableCell Name="Cell2" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Text="[Order Details.Orders.Employees.FirstName] + &quot; &quot; + [Order Details.Orders.Employees.LastName]" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
    128. 

  128.           <TableCell Name="Cell7" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
    129. 

  129.         </TableRow>
    130. 

  130.         <TableRow Name="Row2" Height="68.34" AutoSize="true">
    131. 

  131.           <TableCell Name="Cell3" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Text="[ProductName]" AllowExpressions="false" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
    132. 

  132.           <TableCell Name="Cell4" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[[Order Details.UnitPrice] * [Order Details.Quantity] * (decimal)(1 - [Order Details.Discount])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
    133. 

  133.           <TableCell Name="Cell8" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
    134. 

  134.         </TableRow>
    135. 

  135.         <TableRow Name="Row3" Height="20.46" AutoSize="true">
    136. 

  136.           <TableCell Name="Cell5" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
    137. 

  137.           <TableCell Name="Cell6" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
    138. 

  138.           <TableCell Name="Cell9" Border.Lines="All" Border.Color="White" Fill.Color="170, 150, 130" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
    139. 

  139.         </TableRow>
    140. 

  140.       </MatrixObject>
    141. 

  141.     </DataBand>
    142. 

  142.     <PageFooterBand Name="PageFooter1" Top="235.51" Width="1047.06" Height="28.35" Fill.Color="WhiteSmoke">
    143. 

  143.       <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"/>
    144. 

  144.     </PageFooterBand>
    145. 

  145.   </ReportPage>
    146. 

  146. </Report>
    147.