Start New Page, Reset Page Numbers.frx 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates the &quot;Reset Page Numbers&quot; feature. To use it:&#13;&#10;- right-click the group header and select the &quot;Reset Page Numbers&quot; menu item;&#13;&#10;- also check the &quot;Start New Page&quot; item. &#13;&#10;&#13;&#10;Each new group will start on a new page, and each one will have its own page numbers." ReportInfo.Created="01/18/2008 00:04:46" ReportInfo.Modified="03/28/2023 16:45:13" ReportInfo.CreatorVersion="1.0.0.0">
  3. <Styles>
  4. <Style Name="EvenRows" Fill.Color="Linen" Font="Arial, 10pt"/>
  5. </Styles>
  6. <Dictionary>
  7. <TableDataSource Name="Customers" ReferenceName="NorthWind.Customers" DataType="System.Int32" Enabled="true">
  8. <Column Name="CustomerID" DataType="System.String"/>
  9. <Column Name="CompanyName" DataType="System.String"/>
  10. <Column Name="ContactName" DataType="System.String"/>
  11. <Column Name="ContactTitle" DataType="System.String"/>
  12. <Column Name="Address" DataType="System.String"/>
  13. <Column Name="City" DataType="System.String"/>
  14. <Column Name="Region" DataType="System.String"/>
  15. <Column Name="PostalCode" DataType="System.String"/>
  16. <Column Name="Country" DataType="System.String"/>
  17. <Column Name="Phone" DataType="System.String"/>
  18. <Column Name="Fax" DataType="System.String"/>
  19. </TableDataSource>
  20. <TableDataSource Name="Orders" ReferenceName="NorthWind.Orders" DataType="System.Int32" Enabled="true">
  21. <Column Name="OrderID" DataType="System.Int32"/>
  22. <Column Name="CustomerID" DataType="System.String"/>
  23. <Column Name="EmployeeID" DataType="System.Int32"/>
  24. <Column Name="OrderDate" DataType="System.DateTime"/>
  25. <Column Name="RequiredDate" DataType="System.DateTime"/>
  26. <Column Name="ShippedDate" DataType="System.DateTime"/>
  27. <Column Name="ShipVia" DataType="System.Int32"/>
  28. <Column Name="Freight" DataType="System.Decimal"/>
  29. <Column Name="ShipName" DataType="System.String"/>
  30. <Column Name="ShipAddress" DataType="System.String"/>
  31. <Column Name="ShipCity" DataType="System.String"/>
  32. <Column Name="ShipRegion" DataType="System.String"/>
  33. <Column Name="ShipPostalCode" DataType="System.String"/>
  34. <Column Name="ShipCountry" DataType="System.String"/>
  35. <Column Name="Latitude" DataType="System.Double"/>
  36. <Column Name="Longitude" DataType="System.Double"/>
  37. </TableDataSource>
  38. <TableDataSource Name="Order Details" ReferenceName="NorthWind.Order Details" DataType="System.Int32" Enabled="true">
  39. <Column Name="OrderID" DataType="System.Int32"/>
  40. <Column Name="ProductID" DataType="System.Int32"/>
  41. <Column Name="UnitPrice" DataType="System.Decimal"/>
  42. <Column Name="Quantity" DataType="System.Int16"/>
  43. <Column Name="Discount" DataType="System.Single"/>
  44. </TableDataSource>
  45. <TableDataSource Name="Products" ReferenceName="NorthWind.Products" DataType="System.Int32" Enabled="true">
  46. <Column Name="ProductID" DataType="System.Int32"/>
  47. <Column Name="ProductName" DataType="System.String"/>
  48. <Column Name="SupplierID" DataType="System.Int32"/>
  49. <Column Name="CategoryID" DataType="System.Int32"/>
  50. <Column Name="QuantityPerUnit" DataType="System.String"/>
  51. <Column Name="UnitPrice" DataType="System.Decimal"/>
  52. <Column Name="UnitsInStock" DataType="System.Int16"/>
  53. <Column Name="UnitsOnOrder" DataType="System.Int16"/>
  54. <Column Name="ReorderLevel" DataType="System.Int16"/>
  55. <Column Name="Discontinued" DataType="System.Boolean" BindableControl="CheckBox"/>
  56. <Column Name="EAN13" DataType="System.String"/>
  57. </TableDataSource>
  58. <Relation Name="CustomersOrders" ReferenceName="NorthWind.CustomersOrders" ParentDataSource="Customers" ChildDataSource="Orders" ParentColumns="CustomerID" ChildColumns="CustomerID" Enabled="true"/>
  59. <Relation Name="OrdersOrderDetails" ReferenceName="NorthWind.OrdersOrderDetails" ParentDataSource="Orders" ChildDataSource="Order Details" ParentColumns="OrderID" ChildColumns="OrderID" Enabled="true"/>
  60. <Relation Name="ProductsOrderDetails" ReferenceName="NorthWind.ProductsOrderDetails" ParentDataSource="Products" ChildDataSource="Order Details" ParentColumns="ProductID" ChildColumns="ProductID" Enabled="true"/>
  61. <Total Name="SumOfOrder" Expression="[Order Details.UnitPrice] * [Order Details.Quantity]" Evaluator="Data1" PrintOn="DataFooter1"/>
  62. </Dictionary>
  63. <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
  64. <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="37.8" CanGrow="true">
  65. <TextObject Name="Text6" Width="718.2" Height="37.8" Text="CUSTOMERS ORDERS" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold"/>
  66. </ReportTitleBand>
  67. <GroupHeaderBand Name="GroupHeader1" Top="39.8" Width="718.2" Height="37.8" Fill.Color="130, 180, 130" StartNewPage="true" Condition="[Orders.CustomerID]" ResetPageNumber="true">
  68. <TextObject Name="Text1" Width="349.65" Height="37.8" Text="[Orders.Customers.CompanyName]" VertAlign="Center" Font="Segoe UI, 12pt, style=Bold" TextFill.Color="White"/>
  69. <DataBand Name="Data2" Top="79.6" Width="718.2" Height="47.25" DataSource="Orders" PrintIfDetailEmpty="true">
  70. <TextObject Name="Text4" Left="94.5" Width="94.5" Height="18.9" Fill.Color="WhiteSmoke" Text="[Orders.OrderID]" VertAlign="Center" Font="Segoe UI, 9pt"/>
  71. <TextObject Name="Text2" Left="283.5" Width="94.5" Height="18.9" Fill.Color="WhiteSmoke" Text="[Orders.OrderDate]" Format="Date" Format.Format="d" VertAlign="Center" Font="Segoe UI, 9pt"/>
  72. <TextObject Name="Text7" Left="472.5" Width="245.7" Height="18.9" Fill.Color="WhiteSmoke" Text="[Orders.ShippedDate]" Format="Date" Format.Format="d" VertAlign="Center" Font="Segoe UI, 9pt"/>
  73. <TextObject Name="Text5" Width="94.5" Height="18.9" Fill.Color="WhiteSmoke" Text="OrderID" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  74. <TextObject Name="Text3" Left="189" Width="94.5" Height="18.9" Fill.Color="WhiteSmoke" Text="OrderDate" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  75. <TextObject Name="Text8" Left="378" Width="94.5" Height="18.9" Fill.Color="WhiteSmoke" Text="ShippedDate" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  76. <TextObject Name="Text14" Left="18.9" Top="28.35" Width="189" Height="18.9" Border.Lines="Left, Top, Bottom" Border.Color="LightGray" Text="Product name" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  77. <TextObject Name="Text15" Left="207.9" Top="28.35" Width="94.5" Height="18.9" Border.Lines="Top, Bottom" Border.Color="LightGray" Text="Unit Price" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  78. <TextObject Name="Text16" Left="302.4" Top="28.35" Width="94.5" Height="18.9" Border.Lines="Right, Top, Bottom" Border.Color="LightGray" Text="Quantity" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  79. <DataBand Name="Data1" Top="128.85" Width="718.2" Height="18.9" DataSource="Order Details">
  80. <TextObject Name="Text11" Left="18.9" Width="189" Height="18.9" Border.Lines="Left, Top, Bottom" Border.Color="LightGray" Text="[Order Details.Products.ProductName]" VertAlign="Center" Font="Segoe UI, 9pt"/>
  81. <TextObject Name="Text12" Left="207.9" Width="94.5" Height="18.9" Border.Lines="Top, Bottom" Border.Color="LightGray" Text="[Order Details.UnitPrice]" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  82. <TextObject Name="Text13" Left="302.4" Width="94.5" Height="18.9" Border.Lines="Right, Top, Bottom" Border.Color="LightGray" Text="[Order Details.Quantity]" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt"/>
  83. <DataFooterBand Name="DataFooter1" Top="149.75" Width="718.2" Height="37.8">
  84. <TextObject Name="Text9" Left="18.9" Width="378" Height="18.9" Border.Lines="All" Border.Color="LightGray" Text="Total this order: [SumOfOrder]" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  85. </DataFooterBand>
  86. <Sort>
  87. <Sort Expression="[Order Details.ProductID]"/>
  88. </Sort>
  89. </DataBand>
  90. <Sort>
  91. <Sort Expression="[Orders.OrderID]"/>
  92. </Sort>
  93. </DataBand>
  94. </GroupHeaderBand>
  95. <PageFooterBand Name="PageFooter1" Top="189.55" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
  96. <TextObject Name="Text10" Left="614.25" Width="94.5" Height="28.35" Text="[PageN]" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  97. <TextObject Name="Text17" 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"/>
  98. </PageFooterBand>
  99. </ReportPage>
  100. </Report>