Home Explore Help
Register Sign In
PRSDigital
/
3rdpartylibs
3
0
Fork 0
Files Pull Requests 0
Tree: ba58514a84
Branches Tags
3rdpartylibs
/
fastreports.wpf
/
Demos
/
Reports.New
/
NorthWind Reports
/
Sales Analysis.frx

Sales Analysis.frx 21 KB
History Raw

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

  2. <Report ScriptLanguage="CSharp" ReportInfo.Created="05/15/2008 00:47:48" ReportInfo.Modified="03/29/2023 23:25:43" ReportInfo.CreatorVersion="1.0.0.0">
    3. 

  3.   <Styles>
    4. 

  4.     <Style Name="EvenRows" Fill.Color="Honeydew" Font="Segoe UI, 10pt" ApplyBorder="false" ApplyTextFill="false" ApplyFont="false"/>
    5. 

  5.   </Styles>
    6. 

  6.   <Dictionary>
    7. 

  7.     <TableDataSource Name="Categories" ReferenceName="NorthWind.Categories" DataType="System.Int32" Enabled="true">
    8. 

  8.       <Column Name="CategoryID" DataType="System.Int32"/>
    9. 

  9.       <Column Name="CategoryName" DataType="System.String"/>
    10. 

  10.       <Column Name="Description" DataType="System.String"/>
    11. 

  11.       <Column Name="Picture" DataType="System.Byte[]" BindableControl="Picture"/>
    12. 

  12.     </TableDataSource>
    13. 

  13.     <TableDataSource Name="Customers" ReferenceName="NorthWind.Customers" DataType="System.Int32" Enabled="true">
    14. 

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

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

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

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

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

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

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

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

  22.       <Column Name="Country" DataType="System.String"/>
    23. 

  23.       <Column Name="Phone" DataType="System.String"/>
    24. 

  24.       <Column Name="Fax" DataType="System.String"/>
    25. 

  25.     </TableDataSource>
    26. 

  26.     <TableDataSource Name="Employees" ReferenceName="NorthWind.Employees" DataType="System.Int32" Enabled="true">
    27. 

  27.       <Column Name="EmployeeID" DataType="System.Int32"/>
    28. 

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

  29.       <Column Name="FirstName" DataType="System.String"/>
    30. 

  30.       <Column Name="Title" DataType="System.String"/>
    31. 

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

  32.       <Column Name="BirthDate" DataType="System.DateTime"/>
    33. 

  33.       <Column Name="HireDate" DataType="System.DateTime"/>
    34. 

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

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

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

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

  38.       <Column Name="Country" DataType="System.String"/>
    39. 

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

  40.       <Column Name="Extension" DataType="System.String"/>
    41. 

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

  42.       <Column Name="Notes" DataType="System.String"/>
    43. 

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

  44.     </TableDataSource>
    45. 

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

  46.       <Column Name="OrderID" DataType="System.Int32"/>
    47. 

  47.       <Column Name="ProductID" DataType="System.Int32"/>
    48. 

  48.       <Column Name="UnitPrice" DataType="System.Decimal"/>
    49. 

  49.       <Column Name="Quantity" DataType="System.Int16"/>
    50. 

  50.       <Column Name="Discount" DataType="System.Single"/>
    51. 

  51.       <Column Name="Column" Alias="Price" DataType="System.Decimal" Calculated="true" Expression="[Order Details.Quantity]*[Order Details.UnitPrice]*(decimal)(1 - [Order Details.Discount])"/>
    52. 

  52.     </TableDataSource>
    53. 

  53.     <TableDataSource Name="Orders" ReferenceName="NorthWind.Orders" DataType="System.Int32" Enabled="true">
    54. 

  54.       <Column Name="OrderID" DataType="System.Int32"/>
    55. 

  55.       <Column Name="CustomerID" DataType="System.String"/>
    56. 

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

  57.       <Column Name="OrderDate" DataType="System.DateTime"/>
    58. 

  58.       <Column Name="RequiredDate" DataType="System.DateTime"/>
    59. 

  59.       <Column Name="ShippedDate" DataType="System.DateTime"/>
    60. 

  60.       <Column Name="ShipVia" DataType="System.Int32"/>
    61. 

  61.       <Column Name="Freight" DataType="System.Decimal"/>
    62. 

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

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

  64.       <Column Name="ShipCity" DataType="System.String"/>
    65. 

  65.       <Column Name="ShipRegion" DataType="System.String"/>
    66. 

  66.       <Column Name="ShipPostalCode" DataType="System.String"/>
    67. 

  67.       <Column Name="ShipCountry" DataType="System.String"/>
    68. 

  68.       <Column Name="Latitude" DataType="System.Double"/>
    69. 

  69.       <Column Name="Longitude" DataType="System.Double"/>
    70. 

  70.     </TableDataSource>
    71. 

  71.     <TableDataSource Name="Products" ReferenceName="NorthWind.Products" DataType="System.Int32" Enabled="true">
    72. 

  72.       <Column Name="ProductID" DataType="System.Int32"/>
    73. 

  73.       <Column Name="ProductName" DataType="System.String"/>
    74. 

  74.       <Column Name="SupplierID" DataType="System.Int32"/>
    75. 

  75.       <Column Name="CategoryID" DataType="System.Int32"/>
    76. 

  76.       <Column Name="QuantityPerUnit" DataType="System.String"/>
    77. 

  77.       <Column Name="UnitPrice" DataType="System.Decimal"/>
    78. 

  78.       <Column Name="UnitsInStock" DataType="System.Int16"/>
    79. 

  79.       <Column Name="UnitsOnOrder" DataType="System.Int16"/>
    80. 

  80.       <Column Name="ReorderLevel" DataType="System.Int16"/>
    81. 

  81.       <Column Name="Discontinued" DataType="System.Boolean" BindableControl="CheckBox"/>
    82. 

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

  83.     </TableDataSource>
    84. 

  84.     <TableDataSource Name="Shippers" ReferenceName="NorthWind.Shippers" DataType="System.Int32" Enabled="true">
    85. 

  85.       <Column Name="ShipperID" DataType="System.Int32"/>
    86. 

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

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

  88.     </TableDataSource>
    89. 

  89.     <TableDataSource Name="Suppliers" ReferenceName="NorthWind.Suppliers" DataType="System.Int32" Enabled="true">
    90. 

  90.       <Column Name="SupplierID" DataType="System.Int32"/>
    91. 

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

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

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

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

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

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

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

  98.       <Column Name="Country" DataType="System.String"/>
    99. 

  99.       <Column Name="Phone" DataType="System.String"/>
    100. 

  100.       <Column Name="Fax" DataType="System.String"/>
    101. 

  101.       <Column Name="HomePage" DataType="System.String"/>
    102. 

  102.     </TableDataSource>
    103. 

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

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

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

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

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

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

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

  110.   </Dictionary>
    111. 

  111.   <ReportPage Name="Page1" Landscape="true" PaperWidth="297" PaperHeight="210" RawPaperSize="9" Watermark.Font="Segoe UI, 60pt" UnlimitedHeight="true" UnlimitedWidth="true" LastPageSource="1" FirstPageSource="1">
    112. 

  112.     <ReportTitleBand Name="ReportTitle1" Width="1047.06" Height="66.15" CanGrow="true">
    113. 

  113.       <TextObject Name="Text29" Left="189" Width="529.2" Height="56.7" Text="SALES ANALYSIS" VertAlign="Center" Font="Segoe UI, 24pt, style=Bold" TextFill.Color="DimGray"/>
    114. 

  114.       <TextObject Name="Text30" Width="56.7" Height="56.7" Text="Ṅ" VertAlign="Center" Font="Segoe UI, 36pt, style=Bold" TextFill.Color="DimGray"/>
    115. 

  115.       <TextObject Name="Text31" Left="56.7" Top="9.45" Width="94.5" Height="37.8" Border.Lines="Left" Text="NORTHWIND&#13;&#10;TRADERS" Padding="10, 0, 2, 0" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="DimGray"/>
    116. 

  116.     </ReportTitleBand>
    117. 

  117.     <DataBand Name="Data1" Top="68.15" Width="1047.06" Height="183.33">
    118. 

  118.       <AdvMatrixObject Name="AdvMatrix1" Left="9.45" Top="47.25" Width="793.8" Height="132.3" DataSource="Order Details" Style="Blue">
    119. 

  119.         <Columns>
    120. 

  120.           <Descriptor DisplayText="Employees">
    121. 

  121.             <Descriptor Expression="[Order Details.Orders.Employees.FirstName] + &quot; &quot; + [Order Details.Orders.Employees.LastName]" SortByTotal="Sum([Order Details.Quantity]*[Order Details.UnitPrice]*(decimal)(1 - [Order Details.Discount]))"/>
    122. 

  122.           </Descriptor>
    123. 

  123.           <Descriptor DisplayText="Top 5 customers">
    124. 

  124.             <Descriptor Expression="[Order Details.Orders.Customers.CompanyName]" Sort="Descending" SortByTotal="Sum([Order Details.Quantity]*[Order Details.UnitPrice]*(decimal)(1 - [Order Details.Discount]))" Visible="false" VisibleToggledBy="CollapseButton3" TopN.Count="5" TopN.Total.Name="TotalItem1" TopN.Others.Name="OthersItem1" TopN.OthersTotal.Name="OthersTotalItem1"/>
    125. 

  125.             <Descriptor Name="TotalItem1" DisplayText="Total" Visible="false"/>
    126. 

  126.             <Descriptor Name="OthersItem1" Visible="false" VisibleToggledBy="CollapseButton2"/>
    127. 

  127.             <Descriptor Name="OthersTotalItem1" DisplayText="Others ([AdvMatrix1.ItemCount])"/>
    128. 

  128.           </Descriptor>
    129. 

  129.           <Descriptor DisplayText="Total"/>
    130. 

  130.         </Columns>
    131. 

  131.         <Rows>
    132. 

  132.           <Descriptor Expression="[Order Details.Products.Categories.CategoryName]" DisplayText="[Order Details.Products.Categories.CategoryName] ([AdvMatrix1.ItemCount])" SortToggledBy="SortButton2" Stepped="true">
    133. 

  133.             <Descriptor Expression="[Order Details.Products.ProductName]" DisplayText="[AdvMatrix1.RowNo]. [Order Details.Products.ProductName]" Visible="false" VisibleToggledBy="CollapseButton1"/>
    134. 

  134.           </Descriptor>
    135. 

  135.           <Descriptor DisplayText="Total"/>
    136. 

  136.         </Rows>
    137. 

  137.         <TableColumn Name="Column1" Width="149.58"/>
    138. 

  138.         <TableColumn Name="Column2" Width="109.89" AutoSize="true"/>
    139. 

  139.         <TableColumn Name="Column3" Width="109.89" AutoSize="true"/>
    140. 

  140.         <TableColumn Name="Column4" Width="109.89" AutoSize="true"/>
    141. 

  141.         <TableColumn Name="Column5" Width="109.89" AutoSize="true"/>
    142. 

  142.         <TableColumn Name="Column6" Width="109.89" AutoSize="true"/>
    143. 

  143.         <TableColumn Name="Column7" Width="94.77" AutoSize="true"/>
    144. 

  144.         <TableRow Name="Row1" Height="28.35">
    145. 

  145.           <TableCell Name="Cell1" Border.Lines="All" Border.Color="White" Fill.Color="112, 146, 190" Text="Categories/Products" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White" RowSpan="2"/>
    146. 

  146.           <TableCell Name="Cell2" Border.Lines="All" Border.Color="White" Fill.Color="112, 146, 190" Text="Employees" Padding="16, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
    147. 

  147.           <TableCell Name="Cell7" Border.Lines="All" Border.Color="White" Fill.Color="173, 152, 130" Text="Top 5 customers" Padding="16, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White" ColSpan="4">
    148. 

  148.             <MatrixCollapseButton Name="CollapseButton3" Width="16" Height="28.35" Dock="Left" Border.Lines="None" Border.Color="White" SymbolSize="8" Symbol="Pointer"/>
    149. 

  149.           </TableCell>
    150. 

  150.           <TableCell Name="Cell10" Fill.Color="173, 152, 130" Font="Segoe UI, 10pt"/>
    151. 

  151.           <TableCell Name="Cell17" Fill.Color="173, 152, 130" Font="Segoe UI, 10pt"/>
    152. 

  152.           <TableCell Name="Cell18" Fill.Color="173, 152, 130" Font="Segoe UI, 10pt"/>
    153. 

  153.           <TableCell Name="Cell19" Border.Lines="All" Border.Color="White" Fill.Color="112, 146, 190" Text="Total" Padding="2, 1, 16, 1" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White" RowSpan="2">
    154. 

  154.             <MatrixSortButton Name="SortButton3" Left="78.77" Width="16" Height="56.7" Dock="Right" Border.Color="White" SymbolSize="7" InactiveSortColor="DarkGray"/>
    155. 

  155.           </TableCell>
    156. 

  156.         </TableRow>
    157. 

  157.         <TableRow Name="Row2" Height="28.35">
    158. 

  158.           <TableCell Name="Cell3" Border.Lines="All" Border.Color="White" Fill.Color="151, 189, 253" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt"/>
    159. 

  159.           <TableCell Name="Cell4" Border.Lines="All" Border.Color="White" Fill.Color="112, 146, 190" Text="[Order Details.Orders.Employees.FirstName] + &quot; &quot; + [Order Details.Orders.Employees.LastName]" Padding="4, 1, 4, 1" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
    160. 

  160.           <TableCell Name="Cell8" Border.Lines="All" Border.Color="White" Fill.Color="173, 152, 130" Text="[Order Details.Orders.Customers.CompanyName]" Padding="4, 1, 4, 1" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
    161. 

  161.           <TableCell Name="Cell11" Border.Lines="All" Border.Color="White" Fill.Color="173, 152, 130" Text="Total" Padding="4, 1, 4, 1" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
    162. 

  162.           <TableCell Name="Cell20" Border.Lines="All" Border.Color="White" Fill.Color="173, 152, 130" Padding="4, 1, 4, 1" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
    163. 

  163.           <TableCell Name="Cell21" Border.Lines="All" Border.Color="White" Fill.Color="173, 152, 130" Text="Others ([AdvMatrix1.ItemCount])" Padding="16, 1, 4, 1" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White">
    164. 

  164.             <MatrixCollapseButton Name="CollapseButton2" Width="16" Height="28.35" Dock="Left" Border.Lines="None" Border.Color="White" SymbolSize="8" Symbol="Pointer"/>
    165. 

  165.           </TableCell>
    166. 

  166.           <TableCell Name="Cell22" Font="Segoe UI, 10pt"/>
    167. 

  167.         </TableRow>
    168. 

  168.         <TableRow Name="Row3" Height="28.35" AutoSize="true">
    169. 

  169.           <TableCell Name="Cell5" Border.Lines="All" Border.Color="White" Fill.Color="112, 146, 190" Text="[Order Details.Products.Categories.CategoryName]" Padding="16, 1, 16, 1" AllowExpressions="false" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White">
    170. 

  170.             <MatrixCollapseButton Name="CollapseButton1" Width="16" Height="28.35" Dock="Left" Border.Lines="None" Border.Color="White" SymbolSize="8" Symbol="Pointer" ShowCollapseExpandMenu="true"/>
    171. 

  171.             <MatrixSortButton Name="SortButton1" Left="133.58" Width="16" Height="28.35" Dock="Right" Border.Color="White" SymbolSize="7" InactiveSortColor="DarkGray"/>
    172. 

  172.           </TableCell>
    173. 

  173.           <TableCell Name="Cell6" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
    174. 

  174.           <TableCell Name="Cell9" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
    175. 

  175.           <TableCell Name="Cell12" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
    176. 

  176.           <TableCell Name="Cell23" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
    177. 

  177.           <TableCell Name="Cell24" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
    178. 

  178.           <TableCell Name="Cell25" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
    179. 

  179.         </TableRow>
    180. 

  180.         <TableRow Name="Row4" AutoSize="true">
    181. 

  181.           <TableCell Name="Cell13" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Order Details.Products.ProductName]" Padding="20, 1, 2, 1" AllowExpressions="false" VertAlign="Center" Font="Segoe UI, 9pt"/>
    182. 

  182.           <TableCell Name="Cell14" Border.Lines="Bottom" Border.Color="WhiteSmoke" Fill.Color="White" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
    183. 

  183.           <TableCell Name="Cell15" Border.Lines="Bottom" Border.Color="WhiteSmoke" Fill.Color="White" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
    184. 

  184.           <TableCell Name="Cell16" Border.Lines="Bottom" Border.Color="WhiteSmoke" Fill.Color="White" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
    185. 

  185.           <TableCell Name="Cell26" Border.Lines="Bottom" Border.Color="WhiteSmoke" Fill.Color="White" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
    186. 

  186.           <TableCell Name="Cell27" Border.Lines="Bottom" Border.Color="WhiteSmoke" Fill.Color="White" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
    187. 

  187.           <TableCell Name="Cell28" Border.Lines="Bottom" Border.Color="WhiteSmoke" Fill.Color="White" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
    188. 

  188.         </TableRow>
    189. 

  189.         <TableRow Name="Row5" Height="28.35">
    190. 

  190.           <TableCell Name="Cell29" Border.Lines="All" Border.Color="White" Fill.Color="112, 146, 190" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
    191. 

  191.           <TableCell Name="Cell30" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
    192. 

  192.           <TableCell Name="Cell31" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
    193. 

  193.           <TableCell Name="Cell32" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
    194. 

  194.           <TableCell Name="Cell33" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
    195. 

  195.           <TableCell Name="Cell34" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
    196. 

  196.           <TableCell Name="Cell35" Border.Lines="All" Border.Color="White" Fill.Color="WhiteSmoke" Text="[Sum([Order Details.Price])]" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
    197. 

  197.         </TableRow>
    198. 

  198.       </AdvMatrixObject>
    199. 

  199.       <TextObject Name="Text13" Left="9.45" Top="9.45" Width="151.2" Height="28.35" Border.Lines="All" Border.Color="White" Fill.Color="112, 146, 190" Text="Sort Category:" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
    200. 

  200.       <MatrixSortButton Name="SortButton2" Left="141.75" Top="9.45" Width="18.9" Height="28.35" Border.Color="White" SymbolSize="7" Sort="Ascending" AllowInactiveSort="false" InactiveSortColor="DarkGray"/>
    201. 

  201.       <ChildBand Name="Child1" Top="253.48" Width="1047.06" Height="37.8"/>
    202. 

  202.     </DataBand>
    203. 

  203.     <PageFooterBand Name="PageFooter1" Top="293.28" Width="1047.06" Height="28.35" Fill.Color="WhiteSmoke">
    204. 

  204.       <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"/>
    205. 

  205.     </PageFooterBand>
    206. 

  206.   </ReportPage>
    207. 

  207. </Report>
    208.