55 lines
12 KiB
XML
55 lines
12 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<TfrxReport Version="4.11.4" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="37871,9961568403" ReportOptions.Description.Text="Demonstrates how to create Master/Detail/SubDetail report. This report contains three data-bands which are connected to datasets." ReportOptions.LastChange="41019,9902173032" ScriptLanguage="PascalScript" ScriptText.Text="begin end." PropData="044C656674025803546F7003700108446174617365747301010C3900000020446174615365743D225265706F7274446174612E437573746F6D65727344532220446174615365744E616D653D22437573746F6D6572732200010C3100000020446174615365743D225265706F7274446174612E4974656D7344532220446174615365744E616D653D224974656D732200010C3300000020446174615365743D225265706F7274446174612E4F726465727344532220446174615365744E616D653D224F72646572732200010C3000000020446174615365743D225265706F7274446174612E5061727444532220446174615365744E616D653D225061727473220000095661726961626C65730100055374796C650100">
|
|
<TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000"/>
|
|
<TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="5" RightMargin="5" TopMargin="5" BottomMargin="5" Columns="1" ColumnWidth="210" ColumnPositions.Text="0" PrintOnPreviousPage="True" HGuides.Text="" VGuides.Text="">
|
|
<TfrxPageFooter Name="Band1" Height="22,67718" Left="0" Top="423,30736" Width="755,906">
|
|
<TfrxMemoView Name="Memo5" Left="3,77953" Top="3,77953000000008" Width="706,77211" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="4" Frame.Width="2" HAlign="haRight" ParentFont="False" Text="[Page#]"/>
|
|
</TfrxPageFooter>
|
|
<TfrxReportTitle Name="Band2" Height="30,23624" Left="0" Top="18,89765" Width="755,906">
|
|
<TfrxMemoView Name="Memo6" Left="3,77953" Top="3,77953" Width="706,77211" Height="22,67718" ShowHint="False" Color="8421504" Font.Charset="1" Font.Color="16777215" Font.Height="-16" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Wysiwyg="False" Text="Customers"/>
|
|
</TfrxReportTitle>
|
|
<TfrxMasterData Name="Band4" Height="45,35436" Left="0" Top="105,82684" Width="755,906" Columns="1" ColumnWidth="200" ColumnGap="20" DataSet="ReportData.CustomersDS" DataSetName="Customers" RowCount="0">
|
|
<TfrxGradientView Name="Gradient1" Left="3,77953" Top="0" Width="706,77211" Height="45,35436" ShowHint="False" EndColor="128" Style="gsVertical" Color="8421568"/>
|
|
<TfrxMemoView Name="Memo23" Left="11,33859" Top="0" Width="283,46475" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" Frame.Typ="4" ParentFont="False" Wysiwyg="False" VAlign="vaBottom" Text="Company"/>
|
|
<TfrxMemoView Name="Memo24" Left="11,33859" Top="18,89765" Width="283,46475" Height="26,45671" ShowHint="False" DataField="Company" DataSet="ReportData.CustomersDS" DataSetName="Customers" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="2" Frame.Color="12632256" ParentFont="False" Wysiwyg="False" VAlign="vaBottom" Text="[Customers."Company"]"/>
|
|
<TfrxMemoView Name="Memo25" Left="294,80334" Top="0" Width="173,85838" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" Frame.Typ="4" ParentFont="False" Wysiwyg="False" VAlign="vaBottom" Text="Phone"/>
|
|
<TfrxMemoView Name="Memo26" Left="468,66172" Top="0" Width="162,51979" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" Frame.Typ="4" ParentFont="False" Wysiwyg="False" VAlign="vaBottom" Text="Fax"/>
|
|
<TfrxMemoView Name="Memo27" Left="294,80334" Top="18,89765" Width="173,85838" Height="26,45671" ShowHint="False" DataField="Phone" DataSet="ReportData.CustomersDS" DataSetName="Customers" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="2" Frame.Color="12632256" ParentFont="False" Wysiwyg="False" VAlign="vaBottom" Text="[Customers."Phone"]"/>
|
|
<TfrxMemoView Name="Memo28" Left="468,66172" Top="18,89765" Width="162,51979" Height="26,45671" ShowHint="False" DataField="FAX" DataSet="ReportData.CustomersDS" DataSetName="Customers" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="2" Frame.Color="12632256" ParentFont="False" Wysiwyg="False" VAlign="vaBottom" Text="[Customers."FAX"]"/>
|
|
<TfrxMemoView Name="Memo29" Left="631,18151" Top="0" Width="79,37013" Height="45,35436" ShowHint="False" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="3" Frame.Color="12632256" Frame.Typ="6" ParentFont="False" VAlign="vaCenter" Text=""/>
|
|
<TfrxMemoView Name="Memo7" Left="3,77953" Top="0" Width="7,55906" Height="45,35436" ShowHint="False" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="3" Frame.Color="12632256" Frame.Typ="5" ParentFont="False" VAlign="vaCenter" Text=""/>
|
|
</TfrxMasterData>
|
|
<TfrxDetailData Name="Band5" Height="18,89765" Left="0" Top="170,07885" Width="755,906" Columns="1" ColumnWidth="200" ColumnGap="20" DataSet="ReportData.OrdersDS" DataSetName="Orders" RowCount="0">
|
|
<TfrxMemoView Name="Memo4" Left="3,77953" Top="0" Width="3,77953" Height="18,89765" ShowHint="False" Color="12632256" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="12632256" Frame.Typ="1" ParentFont="False" Wysiwyg="False" Text=""/>
|
|
<TfrxMemoView Name="Memo8" Left="7,55906" Top="0" Width="117,16543" Height="18,89765" ShowHint="False" Color="12632256" Wysiwyg="False" Text="Order No [Orders."Order No"]"/>
|
|
<TfrxMemoView Name="Memo9" Left="124,72449" Top="0" Width="585,82715" Height="18,89765" ShowHint="False" Color="12632256" Frame.Color="12632256" Frame.Typ="2" Wysiwyg="False" Text="Date [Orders."Sale Date"]"/>
|
|
</TfrxDetailData>
|
|
<TfrxFooter Name="Band6" Height="26,45671" Left="0" Top="215,43321" Width="755,906">
|
|
<TfrxMemoView Name="Memo10" Left="3,77953" Top="0" Width="706,77211" Height="18,89765" ShowHint="False" Color="12632256" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Frame.Color="12632256" Frame.Typ="11" Wysiwyg="False" Text="Total sales this customer: [Sum(<Items."Qty">*<Parts."Cost">, Band8)]"/>
|
|
</TfrxFooter>
|
|
<TfrxHeader Name="Band7" Height="18,89765" Left="0" Top="260,78757" Width="755,906">
|
|
<TfrxMemoView Name="Memo3" Left="3,77953" Top="0" Width="41,57483" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="12632256" Frame.Typ="1" ParentFont="False" Wysiwyg="False" Text=""/>
|
|
<TfrxMemoView Name="Memo11" Left="45,35436" Top="0" Width="56,69295" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="False" Wysiwyg="False" Text="Part"/>
|
|
<TfrxMemoView Name="Memo12" Left="109,60637" Top="0" Width="226,7718" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="False" Wysiwyg="False" Text="Description"/>
|
|
<TfrxMemoView Name="Memo13" Left="343,93723" Top="0" Width="79,37013" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="False" Wysiwyg="False" Text="Price"/>
|
|
<TfrxMemoView Name="Memo14" Left="430,86642" Top="0" Width="56,69295" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="False" Wysiwyg="False" Text="Qty"/>
|
|
<TfrxMemoView Name="Memo15" Left="495,11843" Top="0" Width="79,37013" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="False" Wysiwyg="False" Text="Total"/>
|
|
<TfrxMemoView Name="Memo30" Left="574,48856" Top="0" Width="136,06308" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="12632256" Frame.Typ="2" ParentFont="False" Wysiwyg="False" Text=""/>
|
|
</TfrxHeader>
|
|
<TfrxSubdetailData Name="Band8" Height="15,11812" Left="0" Top="306,14193" Width="755,906" Columns="1" ColumnWidth="200" ColumnGap="20" DataSet="ReportData.ItemsDS" DataSetName="Items" RowCount="0">
|
|
<TfrxMemoView Name="Memo2" Left="3,77953" Top="0" Width="41,57483" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="12632256" Frame.Typ="1" ParentFont="False" Wysiwyg="False" Text=""/>
|
|
<TfrxMemoView Name="Memo16" Left="45,35436" Top="0" Width="56,69295" Height="15,11812" ShowHint="False" DataField="Part No" DataSet="ReportData.PartDS" DataSetName="Parts" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="False" Wysiwyg="False" Text="[Parts."Part No"]"/>
|
|
<TfrxMemoView Name="Memo17" Left="109,60637" Top="0" Width="226,7718" Height="15,11812" ShowHint="False" DataField="Description" DataSet="ReportData.PartDS" DataSetName="Parts" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Wysiwyg="False" Text="[Parts."Description"]"/>
|
|
<TfrxMemoView Name="Memo18" Left="343,93723" Top="0" Width="79,37013" Height="15,11812" ShowHint="False" DataField="Cost" DataSet="ReportData.PartDS" DataSetName="Parts" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Wysiwyg="False" Text="[Parts."Cost"]"/>
|
|
<TfrxMemoView Name="Memo19" Left="430,86642" Top="0" Width="56,69295" Height="15,11812" ShowHint="False" DataField="Qty" DataSet="ReportData.ItemsDS" DataSetName="Items" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="False" Wysiwyg="False" Text="[Items."Qty"]"/>
|
|
<TfrxMemoView Name="Memo20" Left="495,11843" Top="0" Width="79,37013" Height="15,11812" ShowHint="False" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Wysiwyg="False" Text="[<Items."Qty">*<Parts."Cost">]"/>
|
|
<TfrxMemoView Name="Memo31" Left="574,48856" Top="0" Width="136,06308" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="12632256" Frame.Typ="2" ParentFont="False" Wysiwyg="False" Text=""/>
|
|
</TfrxSubdetailData>
|
|
<TfrxFooter Name="Band9" Height="22,67718" Left="0" Top="340,1577" Width="755,906">
|
|
<TfrxMemoView Name="Memo1" Left="3,77953" Top="0" Width="41,57483" Height="22,67718" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="12632256" Frame.Typ="1" ParentFont="False" Wysiwyg="False" Text=""/>
|
|
<TfrxMemoView Name="Memo21" Left="45,35436" Top="0" Width="529,1342" Height="18,89765" ShowHint="False" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="128" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" Frame.Typ="4" HAlign="haRight" ParentFont="False" Wysiwyg="False" Text="Total this order: [Sum(<Items."Qty">*<Parts."Cost">, Band8)]"/>
|
|
<TfrxMemoView Name="Memo32" Left="574,48856" Top="0" Width="136,06308" Height="22,67718" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="12632256" Frame.Typ="2" ParentFont="False" Wysiwyg="False" Text=""/>
|
|
</TfrxFooter>
|
|
</TfrxReportPage>
|
|
</TfrxReport>
|