Keep Together.frx 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates the &quot;Keep Together&quot; feature. To use it:&#13;&#10;- select the group header;&#13;&#10;- right-click it and select the &quot;Keep Together&quot; menu item. &#13;&#10;&#13;&#10;This will keep the entire group on a page. If the group can not fit on a page, it will start from a new page.&#13;&#10;&#13;&#10;Note: you can use the Keep properties of a data band as well. " ReportInfo.Created="01/18/2008 00:04:46" ReportInfo.Modified="03/28/2023 20:03:45" ReportInfo.CreatorVersion="1.0.0.0">
  3. <Styles>
  4. <Style Name="EvenRows" Fill.Color="WhiteSmoke" 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. <Relation Name="CustomersOrders" ReferenceName="NorthWind.CustomersOrders" ParentDataSource="Customers" ChildDataSource="Orders" ParentColumns="CustomerID" ChildColumns="CustomerID" Enabled="true"/>
  39. <Total Name="TotalOrders" TotalType="Count" Evaluator="Data2" PrintOn="GroupFooter1"/>
  40. </Dictionary>
  41. <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
  42. <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="37.8" CanGrow="true">
  43. <TextObject Name="Text6" Width="718.2" Height="37.8" Text="CUSTOMERS ORDERS" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold"/>
  44. </ReportTitleBand>
  45. <GroupHeaderBand Name="GroupHeader1" Top="39.8" Width="718.2" Height="37.8" Fill.Color="160, 120, 120" Condition="[Orders.CustomerID]" KeepTogether="true">
  46. <TextObject Name="Text1" Width="349.65" Height="37.8" Text="[Orders.Customers.CompanyName]" VertAlign="Center" Font="Segoe UI, 12pt, style=Bold" TextFill.Color="White"/>
  47. <ChildBand Name="Child1" Top="79.6" Width="718.2" Height="28.35">
  48. <TextObject Name="Text8" Left="255.15" Top="9.45" Width="94.5" Height="18.9" Text="ShippedDate" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  49. <TextObject Name="Text5" Top="9.45" Width="94.5" Height="18.9" Text="OrderID" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  50. <TextObject Name="Text3" Left="122.85" Top="9.45" Width="94.5" Height="18.9" Text="OrderDate" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  51. </ChildBand>
  52. <DataBand Name="Data2" Top="109.95" Width="718.2" Height="18.9" EvenStyle="EvenRows" DataSource="Orders">
  53. <TextObject Name="Text4" Width="94.5" Height="18.9" Text="[Orders.OrderID]" VertAlign="Center" Font="Segoe UI, 9pt"/>
  54. <TextObject Name="Text2" Left="122.85" Width="94.5" Height="18.9" Text="[Orders.OrderDate]" Format="Date" Format.Format="d" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  55. <TextObject Name="Text7" Left="255.15" Width="94.5" Height="18.9" Text="[Orders.ShippedDate]" Format="Date" Format.Format="d" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  56. <Sort>
  57. <Sort Expression="[Orders.OrderID]"/>
  58. </Sort>
  59. </DataBand>
  60. <GroupFooterBand Name="GroupFooter1" Top="130.85" Width="718.2" Height="37.8">
  61. <TextObject Name="Text9" Width="349.65" Height="18.9" Text="Total orders: [TotalOrders]" HorzAlign="Right" Font="Segoe UI, 9pt, style=Bold"/>
  62. </GroupFooterBand>
  63. </GroupHeaderBand>
  64. <PageFooterBand Name="PageFooter1" Top="170.65" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
  65. <TextObject Name="Text10" Left="614.25" Top="9.45" Width="94.5" Height="18.9" Text="[PageN]" HorzAlign="Right" Font="Segoe UI, 9pt"/>
  66. <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"/>
  67. </PageFooterBand>
  68. </ReportPage>
  69. </Report>