61 lines
12 KiB
Plaintext
61 lines
12 KiB
Plaintext
|
<?xml version="1.0" encoding="utf-8"?>
|
||
|
|
<TfrxReport Name="" Version="3.21" DotMatrixReport="False" EngineOptions.DoublePass="True" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" ReportOptions.CreateDate="37871,9959574884" ReportOptions.Description.Text="This report demonstrates how to use URLs and anchors. To assign an URL to an object, just fill in its URL property. If first symbol of this property is '#', this is an anchor (it should be added in the script by Engine.AddAnchor method). First '@' symbol means a page number. Otherwise it is treated as an URL (for example, http://www.someurl.com)." ReportOptions.LastChange="38842,9747479282" ScriptLanguage="PascalScript" ScriptText.Text="procedure Band4OnBeforePrint(Sender: TfrxComponent); begin Engine.AddAnchor(<Sales."Company">); end; begin end." PropData="044C65667403880003546F7003B00008446174617365747301010C3100000020446174615365743D225265706F7274446174612E517565727944532220446174615365744E616D653D2253616C6573220000095661726961626C65730100055374796C650100">
|
||
|
|
<TfrxReportPage Name="Page2" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
|
||
|
|
<TfrxGroupHeader Name="GroupHeader1" Height="22,67718" Left="0" Top="162,51979" Width="718,1107" Condition="Sales."Cust No"">
|
||
|
|
<TfrxMemoView Name="Memo29" Left="0" Top="0" Width="238,11039" Height="18,89765" URL="#[Sales."Company"]" DataField="Company" DataSet="ReportData.QueryDS" DataSetName="Sales" Font.Charset="1" Font.Color="16711680" Font.Height="-13" Font.Name="Arial" Font.Style="5" ParentFont="False" Text="[Sales."Company"]"/>
|
||
|
|
<TfrxMemoView Name="Memo31" Left="536,69326" Top="0" Width="162,51979" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[Engine.GetAnchorPage(<Sales."Company">)]"/>
|
||
|
|
</TfrxGroupHeader>
|
||
|
|
<TfrxMasterData Name="MasterData1" Height="0" Left="0" Top="219,21274" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="ReportData.QueryDS" DataSetName="Sales" RowCount="0"/>
|
||
|
|
<TfrxReportTitle Name="ReportTitle1" Height="71,81107" Left="0" Top="18,89765" Width="718,1107">
|
||
|
|
<TfrxMemoView Name="Memo30" Left="0" Top="37,7953" Width="699,21305" Height="26,45671" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Table of contents"/>
|
||
|
|
<TfrxMemoView Name="Memo32" Left="453,5436" Top="0" Width="245,66945" Height="18,89765" HAlign="haRight" Text="This report is created in the FastReport"/>
|
||
|
|
<TfrxMemoView Name="Memo33" Left="453,5436" Top="18,89765" Width="245,66945" Height="18,89765" URL="http://www.fast-report.com" Font.Charset="1" Font.Color="16711680" Font.Height="-13" Font.Name="Arial" Font.Style="4" HAlign="haRight" ParentFont="False" Text="http://www.fast-report.com"/>
|
||
|
|
</TfrxReportTitle>
|
||
|
|
</TfrxReportPage>
|
||
|
|
<TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="5" RightMargin="5" TopMargin="5" BottomMargin="5" Columns="1" ColumnWidth="210" ColumnPositions.Text="0" HGuides.Text="" VGuides.Text="">
|
||
|
|
<TfrxPageFooter Name="Band1" Height="22,67718" Left="0" Top="476,22078" Width="755,906">
|
||
|
|
<TfrxMemoView Name="Memo5" Left="109,60637" Top="3,77953000000002" Width="604,7248" Height="15,11812" 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#]"/>
|
||
|
|
<TfrxMemoView Name="Memo34" Left="0" Top="3,77953000000002" Width="109,60637" Height="15,11812" URL="@1" Font.Charset="1" Font.Color="16711680" Font.Height="-11" Font.Name="Arial" Font.Style="4" Frame.Typ="4" Frame.Width="2" ParentFont="False" Text="<< back to first page"/>
|
||
|
|
</TfrxPageFooter>
|
||
|
|
<TfrxReportTitle Name="Band2" Height="26,45671" Left="0" Top="18,89765" Width="755,906">
|
||
|
|
<TfrxMemoView Name="Memo6" Left="0" Top="3,77953" Width="714,33117" Height="18,89765" Color="8421504" Font.Charset="1" Font.Color="16777215" Font.Height="-16" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Customers"/>
|
||
|
|
</TfrxReportTitle>
|
||
|
|
<TfrxGroupHeader Name="Band4" Height="45,35436" Left="0" Top="117,16543" Width="755,906" OnBeforePrint="Band4OnBeforePrint" Condition="Sales."Cust No"">
|
||
|
|
<TfrxMemoView Name="Memo17" Left="0" Top="0" Width="302,3624" Height="18,89765" Color="128" Font.Charset="1" Font.Color="16777215" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" Frame.Typ="4" ParentFont="False" VAlign="vaCenter" Text="Company"/>
|
||
|
|
<TfrxMemoView Name="Memo18" Left="0" Top="18,89765" Width="306,14193" Height="26,45671" Color="128" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="2" Frame.Color="12632256" ParentFont="False" VAlign="vaCenter" Text="[Sales."Company"]"/>
|
||
|
|
<TfrxMemoView Name="Memo19" Left="302,3624" Top="0" Width="162,51979" Height="18,89765" Color="128" Font.Charset="1" Font.Color="16777215" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" Frame.Typ="4" ParentFont="False" VAlign="vaCenter" Text="Phone"/>
|
||
|
|
<TfrxMemoView Name="Memo20" Left="464,88219" Top="0" Width="249,44898" Height="18,89765" Color="128" Font.Charset="1" Font.Color="16777215" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" Frame.Typ="6" ParentFont="False" VAlign="vaCenter" Text="Fax"/>
|
||
|
|
<TfrxMemoView Name="Memo21" Left="302,3624" Top="18,89765" Width="162,51979" Height="26,45671" Color="128" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="2" Frame.Color="12632256" ParentFont="False" VAlign="vaCenter" Text="[Sales."Phone"]"/>
|
||
|
|
<TfrxMemoView Name="Memo22" Left="464,88219" Top="18,89765" Width="249,44898" Height="26,45671" Color="128" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="2" Frame.Color="12632256" Frame.Typ="2" ParentFont="False" VAlign="vaCenter" Text="[Sales."FAX"]"/>
|
||
|
|
</TfrxGroupHeader>
|
||
|
|
<TfrxGroupHeader Name="Band5" Height="37,7953" Left="0" Top="196,53556" Width="755,906" Condition="Sales."Order No"">
|
||
|
|
<TfrxMemoView Name="Memo3" Left="0" Top="18,89765" Width="45,35436" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="12632256" Frame.Typ="1" ParentFont="False" Text=""/>
|
||
|
|
<TfrxMemoView Name="Memo8" Left="0" Top="0" Width="124,72449" Height="18,89765" Color="12632256" Frame.Color="12632256" Frame.Typ="1" Text="Order No [Sales."Order No"]"/>
|
||
|
|
<TfrxMemoView Name="Memo9" Left="124,72449" Top="0" Width="589,60668" Height="18,89765" Color="12632256" Frame.Color="12632256" Frame.Typ="2" Text="Date [Sales."Sale Date"]"/>
|
||
|
|
<TfrxMemoView Name="Memo10" Left="45,35436" Top="18,89765" Width="60,47248" Height="15,11812" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" HAlign="haCenter" ParentFont="False" Text="Part"/>
|
||
|
|
<TfrxMemoView Name="Memo11" Left="113,3859" Top="18,89765" Width="230,55133" Height="15,11812" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" HAlign="haCenter" ParentFont="False" Text="Description"/>
|
||
|
|
<TfrxMemoView Name="Memo12" Left="355,27582" Top="18,89765" Width="79,37013" Height="15,11812" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" HAlign="haCenter" ParentFont="False" Text="Price"/>
|
||
|
|
<TfrxMemoView Name="Memo13" Left="442,20501" Top="18,89765" Width="60,47248" Height="15,11812" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" HAlign="haCenter" ParentFont="False" Text="Qty"/>
|
||
|
|
<TfrxMemoView Name="Memo14" Left="510,23655" Top="18,89765" Width="79,37013" Height="15,11812" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" HAlign="haCenter" ParentFont="False" Text="Total"/>
|
||
|
|
<TfrxMemoView Name="Memo4" Left="589,60668" Top="18,89765" Width="124,72449" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="12632256" Frame.Typ="2" ParentFont="False" Text=""/>
|
||
|
|
</TfrxGroupHeader>
|
||
|
|
<TfrxMasterData Name="Band6" Height="15,11812" Left="0" Top="268,34663" Width="755,906" Columns="1" ColumnWidth="200" ColumnGap="20" DataSet="ReportData.QueryDS" DataSetName="Sales" RowCount="0">
|
||
|
|
<TfrxMemoView Name="Memo2" Left="0" Top="0" Width="45,35436" Height="15,11812" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="12632256" Frame.Typ="1" ParentFont="False" Text=""/>
|
||
|
|
<TfrxMemoView Name="Memo23" Left="45,35436" Top="0" Width="60,47248" Height="15,11812" DataField="Part No" DataSet="ReportData.QueryDS" DataSetName="Sales" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" HAlign="haCenter" ParentFont="False" Text="[Sales."Part No"]"/>
|
||
|
|
<TfrxMemoView Name="Memo24" Left="113,3859" Top="0" Width="230,55133" Height="15,11812" DataField="Description" DataSet="ReportData.QueryDS" DataSetName="Sales" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" ParentFont="False" Text="[Sales."Description"]"/>
|
||
|
|
<TfrxMemoView Name="Memo25" Left="355,27582" Top="0" Width="79,37013" Height="15,11812" DataField="List Price" DataSet="ReportData.QueryDS" DataSetName="Sales" DisplayFormat.FormatStr="%2.2m" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" HAlign="haRight" ParentFont="False" Text="[Sales."List Price"]"/>
|
||
|
|
<TfrxMemoView Name="Memo26" Left="442,20501" Top="0" Width="60,47248" Height="15,11812" DataField="Qty" DataSet="ReportData.QueryDS" DataSetName="Sales" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" HAlign="haCenter" ParentFont="False" Text="[Sales."Qty"]"/>
|
||
|
|
<TfrxMemoView Name="Memo27" Left="510,23655" Top="0" Width="79,37013" Height="15,11812" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Color="12632256" HAlign="haRight" ParentFont="False" Text="[<Sales."Qty">*<Sales."List Price">]"/>
|
||
|
|
<TfrxMemoView Name="Memo7" Left="589,60668" Top="0" Width="124,72449" Height="15,11812" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="12632256" Frame.Typ="2" ParentFont="False" Text=""/>
|
||
|
|
</TfrxMasterData>
|
||
|
|
<TfrxGroupFooter Name="Band7" Height="30,23624" Left="0" Top="374,17347" Width="755,906">
|
||
|
|
<TfrxMemoView Name="Memo28" Left="0" Top="0" Width="714,33117" Height="18,89765" Color="12632256" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Frame.Color="12632256" Frame.Typ="11" Text="Total sales this customer: [Sum(<Sales."Qty">*<Sales."List Price">)]"/>
|
||
|
|
</TfrxGroupFooter>
|
||
|
|
<TfrxGroupFooter Name="Band8" Height="22,67718" Left="0" Top="317,48052" Width="755,906">
|
||
|
|
<TfrxMemoView Name="Memo1" Left="0" Top="0" Width="45,35436" Height="22,67718" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="12632256" Frame.Typ="1" ParentFont="False" Text=""/>
|
||
|
|
<TfrxMemoView Name="Memo15" Left="45,35436" Top="0" Width="544,25232" Height="18,89765" 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" Text="Total this order: [Sum(<Sales."Qty">*<Sales."List Price">)]"/>
|
||
|
|
<TfrxMemoView Name="Memo35" Left="589,60668" Top="0" Width="124,72449" Height="22,67718" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="12632256" Frame.Typ="2" ParentFont="False" Text=""/>
|
||
|
|
</TfrxGroupFooter>
|
||
|
|
</TfrxReportPage>
|
||
|
|
</TfrxReport>
|