📄 04.preview outline.fr3
字号:
<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Name="" Version="3.20" DotMatrixReport="False" EngineOptions.UseFileCache="True" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.OutlineVisible="True" PreviewOptions.OutlineWidth="180" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" ReportOptions.ConnectionName="FR Demo Base" ReportOptions.CreateDate="37871,9959574884" ReportOptions.Description.Text="This report shows how to put items in the preview outline control. Some bands (all data bands and group headers) have OutlineText property. You can put a value into this property and FR will automatically build a report outline. You can use it for navigation in the preview." ReportOptions.LastChange="38803,7653023727" ScriptLanguage="PascalScript" ScriptText.Text="begin end." OnStartReport="frxReport1OnStartReport" PropData="08446174617365747301010C2400000020446174615365743D2253616C65732220446174615365744E616D653D2253616C6573220000095661726961626C657301010C11000000204E616D653D222044617461626173652200010C2C000000204E616D653D2250617468546F4461746162617365222056616C75653D22272E2E5C64656D6F2E6D646227220000055374796C650100">
<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="">
<TfrxADOQuery Name="Sales" RangeEnd="reCount" RangeEndCount="100" UserName="Sales" CloseDataSource="True" FieldAliases.Text="a.CustNo=a.CustNo Company=Company Addr1=Addr1 Addr2=Addr2 City=City State=State Zip=Zip Country=Country Phone=Phone FAX=FAX a.TaxRate=TaxRate Contact=Contact LastInvoiceDate=LastInvoiceDate b.OrderNo=OrderNo b.CustNo=CustNo SaleDate=SaleDate ShipDate=ShipDate EmpNo=EmpNo ShipToContact=ShipToContact ShipToAddr1=ShipToAddr1 ShipToAddr2=ShipToAddr2 ShipToCity=ShipToCity ShipToState=ShipToState ShipToZip=ShipToZip ShipToCountry=ShipToCountry ShipToPhone=ShipToPhone ShipVIA=ShipVIA PO=PO Terms=Terms PaymentMethod=PaymentMethod ItemsTotal=ItemsTotal b.TaxRate=b.TaxRate Freight=Freight AmountPaid=AmountPaid c.OrderNo=c.OrderNo ItemNo=ItemNo c.PartNo=PartNo Qty=Qty Discount=Discount d.PartNo=d.PartNo VendorNo=VendorNo Description=Description OnHand=OnHand OnOrder=OnOrder Cost=Cost ListPrice=ListPrice" SQL.Text="select * from customer a, orders b, items c, parts d where a.custno = b.custno and b.orderno = c.orderno and c.partno = d.partno order by a.company, b.orderno" CommandTimeout="30" PropData="0A506172616D65746572730100"/>
<TfrxPageFooter Name="Band1" Height="26,45671" Left="0" Top="453,5436" Width="755,906">
<TfrxMemoView Name="Memo5" Left="3,77953" Top="3,77953000000002" Width="710,55164" 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#]"/>
</TfrxPageFooter>
<TfrxReportTitle Name="Band2" Height="26,45671" Left="0" Top="18,89765" Width="755,906">
<TfrxMemoView Name="Memo6" Left="3,77953" Top="3,77953" Width="710,55164" Height="18,89765" Color="8421376" Font.Charset="1" Font.Color="16777215" Font.Height="-16" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" VAlign="vaBottom" Text="Customers"/>
</TfrxReportTitle>
<TfrxPageHeader Name="Band3" Height="22,67718" Left="0" Top="68,03154" Width="755,906" PrintOnFirstPage="False">
<TfrxMemoView Name="Memo16" Left="3,77953" Top="3,77952999999999" Width="710,55164" Height="15,11812" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="4" Frame.Width="2" ParentFont="False" Text=""/>
</TfrxPageHeader>
<TfrxGroupHeader Name="Band4" Height="45,35436" Left="0" Top="151,1812" Width="755,906" Condition="Sales."CustNo"" OutlineText="<Sales."Company">">
<TfrxMemoView Name="Memo17" Left="3,77953" Top="0" Width="298,58287" Height="18,89765" Color="8388608" Font.Charset="1" Font.Color="16777215" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="5" ParentFont="False" VAlign="vaCenter" Text="Company"/>
<TfrxMemoView Name="Memo18" Left="3,77953" Top="18,89765" Width="298,58287" Height="26,45671" Color="8388608" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="2" Frame.Typ="1" ParentFont="False" VAlign="vaCenter" Text="[Sales."Company"]"/>
<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" ParentFont="False" VAlign="vaCenter" Text="Phone"/>
<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" ParentFont="False" VAlign="vaCenter" Text="Fax"/>
<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" ParentFont="False" VAlign="vaCenter" Text="[Sales."Phone"]"/>
<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" ParentFont="False" VAlign="vaCenter" Text="[Sales."FAX"]"/>
</TfrxGroupHeader>
<TfrxGroupHeader Name="Band5" Height="37,7953" Left="0" Top="219,21274" Width="755,906" Condition="Sales."OrderNo"" OutlineText="Sales."OrderNo"">
<TfrxMemoView Name="Memo3" Left="3,77953" Top="18,89765" Width="41,57483" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="1" ParentFont="False" Text=""/>
<TfrxMemoView Name="Memo8" Left="3,77953" Top="0" Width="120,94496" Height="18,89765" Color="12632256" Frame.Typ="1" Text="Order No [Sales."OrderNo"]"/>
<TfrxMemoView Name="Memo9" Left="124,72449" Top="0" Width="589,60668" Height="18,89765" Color="12632256" Frame.Typ="2" Text="Date [Sales."SaleDate"]"/>
<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" 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" 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" 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" 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" HAlign="haCenter" ParentFont="False" Text="Total"/>
<TfrxMemoView Name="Memo7" Left="672,75634" Top="18,89765" Width="41,57483" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="2" ParentFont="False" Text=""/>
</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="3,77953" Top="0" Width="41,57483" Height="15,11812" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="1" ParentFont="False" Text=""/>
<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" ParentFont="False" Text="[Sales."PartNo"]"/>
<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" ParentFont="False" Text="[Sales."Description"]"/>
<TfrxMemoView Name="Memo25" Left="355,27582" Top="0" Width="79,37013" Height="15,11812" DataField="ListPrice" DataSet="Sales" DataSetName="Sales" 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" Text="[Sales."ListPrice"]"/>
<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" 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" HAlign="haRight" ParentFont="False" Text="[<Sales."Qty">*<Sales."ListPrice">]"/>
<TfrxMemoView Name="Memo29" Left="672,75634" Top="0" Width="41,57483" Height="15,11812" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="2" ParentFont="False" Text=""/>
</TfrxMasterData>
<TfrxGroupFooter Name="Band7" Height="30,23624" Left="0" Top="362,83488" Width="755,906">
<TfrxMemoView Name="Memo28" Left="3,77953" Top="0" Width="710,55164" Height="18,89765" Color="12632256" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Frame.Typ="11" Text="Total sales this customer: [Sum(<Sales."Qty">*<Sales."ListPrice">)]"/>
</TfrxGroupFooter>
<TfrxGroupFooter Name="Band8" Height="22,67718" Left="0" Top="317,48052" Width="755,906">
<TfrxMemoView Name="Memo1" Left="3,77953" Top="0" Width="41,57483" Height="22,67718" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" 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.Typ="4" HAlign="haRight" ParentFont="False" Text="Total this order: [Sum(<Sales."Qty">*<Sales."ListPrice">)]"/>
<TfrxMemoView Name="Memo30" Left="672,75634" Top="0" Width="41,57483" Height="22,67718" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="2" ParentFont="False" Text=""/>
</TfrxGroupFooter>
</TfrxReportPage>
</TfrxReport>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -