123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100 |
- <?xml version="1.0" encoding="utf-8"?>
- <Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates the "Reset Page Numbers" feature. To use it: - right-click the group header and select the "Reset Page Numbers" menu item; - also check the "Start New Page" item. 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">
- <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>
- <TableDataSource Name="Order Details" ReferenceName="NorthWind.Order Details" DataType="System.Int32" Enabled="true">
- <Column Name="OrderID" DataType="System.Int32"/>
- <Column Name="ProductID" DataType="System.Int32"/>
- <Column Name="UnitPrice" DataType="System.Decimal"/>
- <Column Name="Quantity" DataType="System.Int16"/>
- <Column Name="Discount" DataType="System.Single"/>
- </TableDataSource>
- <TableDataSource Name="Products" ReferenceName="NorthWind.Products" DataType="System.Int32" Enabled="true">
- <Column Name="ProductID" DataType="System.Int32"/>
- <Column Name="ProductName" DataType="System.String"/>
- <Column Name="SupplierID" DataType="System.Int32"/>
- <Column Name="CategoryID" DataType="System.Int32"/>
- <Column Name="QuantityPerUnit" DataType="System.String"/>
- <Column Name="UnitPrice" DataType="System.Decimal"/>
- <Column Name="UnitsInStock" DataType="System.Int16"/>
- <Column Name="UnitsOnOrder" DataType="System.Int16"/>
- <Column Name="ReorderLevel" DataType="System.Int16"/>
- <Column Name="Discontinued" DataType="System.Boolean" BindableControl="CheckBox"/>
- <Column Name="EAN13" DataType="System.String"/>
- </TableDataSource>
- <Relation Name="CustomersOrders" ReferenceName="NorthWind.CustomersOrders" ParentDataSource="Customers" ChildDataSource="Orders" ParentColumns="CustomerID" ChildColumns="CustomerID" Enabled="true"/>
- <Relation Name="OrdersOrderDetails" ReferenceName="NorthWind.OrdersOrderDetails" ParentDataSource="Orders" ChildDataSource="Order Details" ParentColumns="OrderID" ChildColumns="OrderID" Enabled="true"/>
- <Relation Name="ProductsOrderDetails" ReferenceName="NorthWind.ProductsOrderDetails" ParentDataSource="Products" ChildDataSource="Order Details" ParentColumns="ProductID" ChildColumns="ProductID" Enabled="true"/>
- <Total Name="SumOfOrder" Expression="[Order Details.UnitPrice] * [Order Details.Quantity]" Evaluator="Data1" PrintOn="DataFooter1"/>
- </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="37.8" Fill.Color="130, 180, 130" StartNewPage="true" Condition="[Orders.CustomerID]" ResetPageNumber="true">
- <TextObject Name="Text1" Width="349.65" Height="37.8" Text="[Orders.Customers.CompanyName]" VertAlign="Center" Font="Segoe UI, 12pt, style=Bold" TextFill.Color="White"/>
- <DataBand Name="Data2" Top="79.6" Width="718.2" Height="47.25" DataSource="Orders" PrintIfDetailEmpty="true">
- <TextObject Name="Text4" Left="94.5" Width="94.5" Height="18.9" Fill.Color="WhiteSmoke" Text="[Orders.OrderID]" VertAlign="Center" Font="Segoe UI, 9pt"/>
- <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"/>
- <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"/>
- <TextObject Name="Text5" Width="94.5" Height="18.9" Fill.Color="WhiteSmoke" Text="OrderID" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <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"/>
- <DataBand Name="Data1" Top="128.85" Width="718.2" Height="18.9" DataSource="Order Details">
- <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"/>
- <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"/>
- <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"/>
- <DataFooterBand Name="DataFooter1" Top="149.75" Width="718.2" Height="37.8">
- <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"/>
- </DataFooterBand>
- <Sort>
- <Sort Expression="[Order Details.ProductID]"/>
- </Sort>
- </DataBand>
- <Sort>
- <Sort Expression="[Orders.OrderID]"/>
- </Sort>
- </DataBand>
- </GroupHeaderBand>
- <PageFooterBand Name="PageFooter1" Top="189.55" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
- <TextObject Name="Text10" Left="614.25" Width="94.5" Height="28.35" Text="[PageN]" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
- <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"/>
- </PageFooterBand>
- </ReportPage>
- </Report>
|