📄 05.urls, anchors.fr3

📁 打印软件
💻 FR3
字号:
<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Name="" DotMatrixReport="False" EngineOptions.DoublePass="True" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="2047" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" ReportOptions.CreateDate="37871,9959574884" ReportOptions.Description.Text="This report demonstrates how to use URLs and anchors.&#13;&#10;&#13;&#10;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="38447,5919770255" ScriptLanguage="PascalScript" ScriptText.Text="procedure frxReport1OnStartReport(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  ADODataBase1.DatabaseName := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' + &#60;PathToDatabase&#62;;&#13;&#10;  ADODataBase1.Connected := True;&#13;&#10;end;&#13;&#10;&#13;&#10;procedure Band4OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  Engine.AddAnchor(&#60;Sales.&#34;Company&#34;&#62;);&#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;&#13;&#10;end." OnStartReport="frxReport1OnStartReport" PropData="08446174617365747301010C2400000020446174615365743D2253616C65732220446174615365744E616D653D2253616C6573220000095661726961626C657301010C11000000204E616D653D222044617461626173652200010C2C000000204E616D653D2250617468546F4461746162617365222056616C75653D22272E2E5C64656D6F2E6D646227220000055374796C650100">
  <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="151,1812" Width="718,1107" Condition="Sales.&#34;Cust No&#34;">
      <TfrxMemoView Name="Memo29" URL="#[Sales.&#34;Company&#34;]" Left="0" Top="0" Width="238,11039" Height="18,89765" DataSetName="Sales" Font.Charset="1" Font.Color="16711680" Font.Height="-13" Font.Name="Arial" Font.Style="5" Memo.Text="[Sales.&#34;Company&#34;]&#13;&#10;" ParentFont="False"/>
      <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" Memo.Text="[Engine.GetAnchorPage(&#60;Sales.&#34;Company&#34;&#62;)]" ParentFont="False"/>
    </TfrxGroupHeader>
    <TfrxMasterData Name="MasterData1" Height="0" Left="0" Top="196,53556" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="Sales" 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" Memo.Text="Table of contents" ParentFont="False"/>
      <TfrxMemoView Name="Memo32" Left="453,5436" Top="0" Width="245,66945" Height="18,89765" HAlign="haRight" Memo.Text="This report is created in the FastReport"/>
      <TfrxMemoView Name="Memo33" URL="http://www.fast-report.com" Left="453,5436" Top="18,89765" Width="245,66945" Height="18,89765" Font.Charset="1" Font.Color="16711680" Font.Height="-13" Font.Name="Arial" Font.Style="4" HAlign="haRight" Memo.Text="http://www.fast-report.com" ParentFont="False"/>
    </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="453,5436" 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" Memo.Text="[Page#]" ParentFont="False"/>
      <TfrxMemoView Name="Memo34" URL="@1" Left="0" Top="3,77953000000002" Width="109,60637" Height="15,11812" Font.Charset="1" Font.Color="16711680" Font.Height="-11" Font.Name="Arial" Font.Style="4" Frame.Typ="4" Frame.Width="2" Memo.Text="&#60;&#60; back to first page" ParentFont="False"/>
    </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="8421376" Font.Charset="1" Font.Color="16777215" Font.Height="-16" Font.Name="Arial" Font.Style="1" HAlign="haCenter" Memo.Text="Customers" ParentFont="False" VAlign="vaCenter"/>
    </TfrxReportTitle>
    <TfrxPageHeader Name="Band3" Height="22,67718" Left="0" Top="68,03154" Width="755,906" PrintOnFirstPage="False">
      <TfrxMemoView Name="Memo16" Left="0" Top="3,77952999999999" Width="714,33117" Height="15,11812" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="4" Frame.Width="2" Memo.Text="" ParentFont="False"/>
    </TfrxPageHeader>
    <TfrxGroupHeader Name="Band4" Height="45,35436" Left="0" Top="151,1812" Width="755,906" OnBeforePrint="Band4OnBeforePrint" Condition="Sales.&#34;Cust No&#34;">
      <TfrxMemoView Name="Memo17" Left="0" Top="0" Width="302,3624" Height="18,89765" Color="8388608" Font.Charset="1" Font.Color="16777215" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="4" Memo.Text="Company" ParentFont="False" VAlign="vaCenter"/>
      <TfrxMemoView Name="Memo18" Left="0" Top="18,89765" Width="306,14193" Height="26,45671" Color="8388608" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="2" Memo.Text="[Sales.&#34;Company&#34;]" ParentFont="False" VAlign="vaCenter"/>
      <TfrxMemoView Name="Memo19" Left="302,3624" Top="0" Width="162,51979" Height="18,89765" Color="8388608" Font.Charset="1" Font.Color="16777215" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="4" Memo.Text="Phone" ParentFont="False" VAlign="vaCenter"/>
      <TfrxMemoView Name="Memo20" Left="464,88219" Top="0" Width="249,44898" Height="18,89765" Color="8388608" Font.Charset="1" Font.Color="16777215" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="6" Memo.Text="Fax" ParentFont="False" VAlign="vaCenter"/>
      <TfrxMemoView Name="Memo21" Left="302,3624" Top="18,89765" Width="162,51979" Height="26,45671" Color="8388608" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="2" Memo.Text="[Sales.&#34;Phone&#34;]" ParentFont="False" VAlign="vaCenter"/>
      <TfrxMemoView Name="Memo22" Left="464,88219" Top="18,89765" Width="249,44898" Height="26,45671" Color="8388608" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="2" Frame.Typ="2" Memo.Text="[Sales.&#34;FAX&#34;]" ParentFont="False" VAlign="vaCenter"/>
    </TfrxGroupHeader>
    <TfrxGroupHeader Name="Band5" Height="37,7953" Left="0" Top="219,21274" Width="755,906" Condition="Sales.&#34;Order No&#34;">
      <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.Typ="1" Memo.Text="" ParentFont="False"/>
      <TfrxMemoView Name="Memo8" Left="0" Top="0" Width="124,72449" Height="18,89765" Color="12632256" Frame.Typ="1" Memo.Text="Order No [Sales.&#34;Order No&#34;]"/>
      <TfrxMemoView Name="Memo9" Left="124,72449" Top="0" Width="589,60668" Height="18,89765" Color="12632256" Frame.Typ="2" Memo.Text="Date [Sales.&#34;Sale Date&#34;]"/>
      <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" HAlign="haCenter" Memo.Text="Part" ParentFont="False"/>
      <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" HAlign="haCenter" Memo.Text="Description" ParentFont="False"/>
      <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" HAlign="haCenter" Memo.Text="Price" ParentFont="False"/>
      <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" HAlign="haCenter" Memo.Text="Qty" ParentFont="False"/>
      <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" HAlign="haCenter" Memo.Text="Total" ParentFont="False"/>
      <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.Typ="2" Memo.Text="" ParentFont="False"/>
    </TfrxGroupHeader>
    <TfrxMasterData Name="Band6" Height="15,11812" Left="0" Top="279,68522" Width="755,906" Columns="1" ColumnWidth="200" ColumnGap="20" DataSet="Sales" 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.Typ="1" Memo.Text="" ParentFont="False"/>
      <TfrxMemoView Name="Memo23" Left="45,35436" Top="0" Width="60,47248" Height="15,11812" DataField="PartNo" DataSet="Sales" DataSetName="Sales" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haCenter" Memo.Text="[Sales.&#34;PartNo&#34;]" ParentFont="False"/>
      <TfrxMemoView Name="Memo24" Left="113,3859" Top="0" Width="230,55133" Height="15,11812" DataField="Description" DataSet="Sales" DataSetName="Sales" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Memo.Text="[Sales.&#34;Description&#34;]" ParentFont="False"/>
      <TfrxMemoView Name="Memo25" Left="355,27582" Top="0" Width="79,37013" Height="15,11812" DataField="List Price" DataSet="Sales" DataSetName="Sales" DisplayFormat.FormatStr="%2.2m" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" Memo.Text="[Sales.&#34;List Price&#34;]" ParentFont="False"/>
      <TfrxMemoView Name="Memo26" Left="442,20501" Top="0" Width="60,47248" Height="15,11812" DataField="Qty" DataSet="Sales" DataSetName="Sales" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haCenter" Memo.Text="[Sales.&#34;Qty&#34;]" ParentFont="False"/>
      <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" HAlign="haRight" Memo.Text="[&#60;Sales.&#34;Qty&#34;&#62;*&#60;Sales.&#34;List Price&#34;&#62;]" ParentFont="False"/>
      <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.Typ="2" Memo.Text="" ParentFont="False"/>
    </TfrxMasterData>
    <TfrxGroupFooter Name="Band7" Height="30,23624" Left="0" Top="362,83488" 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.Typ="11" Memo.Text="Total sales this customer: [Sum(&#60;Sales.&#34;Qty&#34;&#62;*&#60;Sales.&#34;List Price&#34;&#62;)]"/>
    </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.Typ="1" Memo.Text="" ParentFont="False"/>
      <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.Typ="4" HAlign="haRight" Memo.Text="Total this order: [Sum(&#60;Sales.&#34;Qty&#34;&#62;*&#60;Sales.&#34;List Price&#34;&#62;)]" ParentFont="False"/>
      <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.Typ="2" Memo.Text="" ParentFont="False"/>
    </TfrxGroupFooter>
  </TfrxReportPage>
  <TfrxDialogPage Name="DialogPage1" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" Height="200" Left="265" Top="150" Width="300">
    <TfrxADODatabase Name="ADODatabase1" LoginPrompt="False" PropData="05704C65667402240470546F700264"/>
    <TfrxADOQuery Name="Sales" UserName="Sales" CloseDataSource="True" FieldAliases.Text="a.CustNo=a.CustNo&#13;&#10;Company=Company&#13;&#10;Addr1=Addr1&#13;&#10;Addr2=Addr2&#13;&#10;City=City&#13;&#10;State=State&#13;&#10;Zip=Zip&#13;&#10;Country=Country&#13;&#10;Phone=Phone&#13;&#10;FAX=FAX&#13;&#10;a.TaxRate=TaxRate&#13;&#10;Contact=Contact&#13;&#10;LastInvoiceDate=LastInvoiceDate&#13;&#10;b.OrderNo=Order No&#13;&#10;b.CustNo=Cust No&#13;&#10;SaleDate=Sale Date&#13;&#10;ShipDate=ShipDate&#13;&#10;EmpNo=EmpNo&#13;&#10;ShipToContact=ShipToContact&#13;&#10;ShipToAddr1=ShipToAddr1&#13;&#10;ShipToAddr2=ShipToAddr2&#13;&#10;ShipToCity=ShipToCity&#13;&#10;ShipToState=ShipToState&#13;&#10;ShipToZip=ShipToZip&#13;&#10;ShipToCountry=ShipToCountry&#13;&#10;ShipToPhone=ShipToPhone&#13;&#10;ShipVIA=ShipVIA&#13;&#10;PO=PO&#13;&#10;Terms=Terms&#13;&#10;PaymentMethod=PaymentMethod&#13;&#10;ItemsTotal=ItemsTotal&#13;&#10;b.TaxRate=b.TaxRate&#13;&#10;Freight=Freight&#13;&#10;AmountPaid=AmountPaid&#13;&#10;c.OrderNo=c.OrderNo&#13;&#10;ItemNo=ItemNo&#13;&#10;c.PartNo=PartNo&#13;&#10;Qty=Qty&#13;&#10;Discount=Discount&#13;&#10;d.PartNo=d.PartNo&#13;&#10;VendorNo=VendorNo&#13;&#10;Description=Description&#13;&#10;OnHand=OnHand&#13;&#10;OnOrder=OnOrder&#13;&#10;Cost=Cost&#13;&#10;ListPrice=List Price" SQL.Text="select * from customer a, orders b, items c, parts d&#13;&#10;where a.custno = b.custno&#13;&#10;  and b.orderno = c.orderno&#13;&#10;  and c.partno = d.partno&#13;&#10;order by a.company, b.orderno" Database="ADODatabase1" PropData="05704C65667402240470546F7002100A506172616D65746572730100"/>
  </TfrxDialogPage>
</TfrxReport>
💿 文件大小 2957 K
👤 上传用户 arnoldzhw
📂 所属分类多国语言处理
🏷️ 相关标签

#打印 #软件
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -