12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667 |
- <?xml version="1.0" encoding="utf-8"?>
- <Report ScriptLanguage="CSharp" DoublePass="true" ReportInfo.Description="Demonstrates how to use the double pass feature. To create a report like this: - go to the "Report|Options..." menu and check the "Double pass" checkbox; - to display the number of total pages, use the "TotalPages" or "PageNofM" system variables." ReportInfo.Created="01/18/2008 00:04:46" ReportInfo.Modified="03/28/2023 16:30:14" ReportInfo.CreatorVersion="1.0.0.0">
- <Styles>
- <Style Name="EvenRows" Fill.Color="Linen" Font="Arial, 10pt"/>
- </Styles>
- <Dictionary>
- <TableDataSource Name="Customers" ReferenceName="NorthWind.Customers" DataType="System.Int32" Enabled="true">
- <Column Name="CustomerID" DataType="System.String"/>
- <Column Name="CompanyName" DataType="System.String"/>
- <Column Name="ContactName" DataType="System.String"/>
- <Column Name="ContactTitle" DataType="System.String"/>
- <Column Name="Address" DataType="System.String"/>
- <Column Name="City" DataType="System.String"/>
- <Column Name="Region" DataType="System.String"/>
- <Column Name="PostalCode" DataType="System.String"/>
- <Column Name="Country" DataType="System.String"/>
- <Column Name="Phone" DataType="System.String"/>
- <Column Name="Fax" DataType="System.String"/>
- </TableDataSource>
- <TableDataSource Name="Orders" ReferenceName="NorthWind.Orders" DataType="System.Int32" Enabled="true">
- <Column Name="OrderID" DataType="System.Int32"/>
- <Column Name="CustomerID" DataType="System.String"/>
- <Column Name="EmployeeID" DataType="System.Int32"/>
- <Column Name="OrderDate" DataType="System.DateTime"/>
- <Column Name="RequiredDate" DataType="System.DateTime"/>
- <Column Name="ShippedDate" DataType="System.DateTime"/>
- <Column Name="ShipVia" DataType="System.Int32"/>
- <Column Name="Freight" DataType="System.Decimal"/>
- <Column Name="ShipName" DataType="System.String"/>
- <Column Name="ShipAddress" DataType="System.String"/>
- <Column Name="ShipCity" DataType="System.String"/>
- <Column Name="ShipRegion" DataType="System.String"/>
- <Column Name="ShipPostalCode" DataType="System.String"/>
- <Column Name="ShipCountry" DataType="System.String"/>
- <Column Name="Latitude" DataType="System.Double"/>
- <Column Name="Longitude" DataType="System.Double"/>
- </TableDataSource>
- <Relation Name="CustomersOrders" ReferenceName="NorthWind.CustomersOrders" ParentDataSource="Customers" ChildDataSource="Orders" ParentColumns="CustomerID" ChildColumns="CustomerID" Enabled="true"/>
- <Total Name="TotalOrders" TotalType="Count" Evaluator="Data2" PrintOn="GroupFooter1"/>
- </Dictionary>
- <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
- <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="37.8" CanGrow="true">
- <TextObject Name="Text6" Width="718.2" Height="37.8" Text="CUSTOMERS ORDERS" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold"/>
- </ReportTitleBand>
- <GroupHeaderBand Name="GroupHeader1" Top="39.8" Width="718.2" Height="56.7" Condition="[Orders.CustomerID]">
- <TextObject Name="Text1" Width="718.2" Height="37.8" Fill.Color="200, 160, 120" Text="[Orders.Customers.CompanyName]" VertAlign="Center" Font="Segoe UI, 12pt, style=Bold" TextFill.Color="White"/>
- <TextObject Name="Text5" Top="37.8" Width="94.5" Height="18.9" Text="OrderID" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
- <TextObject Name="Text3" Left="122.85" Top="37.8" Width="94.5" Height="18.9" Text="OrderDate" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
- <TextObject Name="Text8" Left="255.15" Top="37.8" Width="94.5" Height="18.9" Text="ShippedDate" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
- <DataBand Name="Data2" Top="98.5" Width="718.2" Height="18.9" DataSource="Orders">
- <TextObject Name="Text4" Width="94.5" Height="18.9" Text="[Orders.OrderID]" VertAlign="Center" Font="Segoe UI, 9pt"/>
- <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"/>
- <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"/>
- <Sort>
- <Sort Expression="[Orders.OrderID]"/>
- </Sort>
- </DataBand>
- <GroupFooterBand Name="GroupFooter1" Top="119.4" Width="718.2" Height="37.8">
- <TextObject Name="Text9" Width="349.65" Height="18.9" Text="Total orders: [TotalOrders]" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
- </GroupFooterBand>
- </GroupHeaderBand>
- <PageFooterBand Name="PageFooter1" Top="159.2" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
- <TextObject Name="Text10" Left="538.65" Width="170.1" Height="28.35" Text="[PageNofM]" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
- <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"/>
- </PageFooterBand>
- </ReportPage>
- </Report>
|