Complex (Hyperlinks, Outline, TOC).frx 8.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Report ScriptLanguage="CSharp" DoublePass="true" ReportInfo.Description="Demonstrates the complex use of &quot;Hyperlinks&quot;, &quot;Bookmarks&quot; and &quot;Outline&quot; features. New in this report:&#13;&#10;- to create the Table of Contents, use bookmarks. To print the page's number for a given bookmark, use the &quot;Engine.GetBookmarkPage&quot; function. This function will work properly if your report is set to double-pass.&#13;&#10;&#13;&#10;Learn how to build this report on the Fast Reports Academy channel http://fast.report/88bd7" ReportInfo.Created="01/17/2008 03:55:42" ReportInfo.Modified="04/07/2023 12:11:29" ReportInfo.CreatorVersion="1.0.0.0">
  3. <Styles>
  4. <Style Name="EvenRows" Fill.Color="OldLace" Font="Arial, 10pt"/>
  5. </Styles>
  6. <Dictionary>
  7. <TableDataSource Name="Categories" ReferenceName="NorthWind.Categories" DataType="System.Int32" Enabled="true">
  8. <Column Name="CategoryID" DataType="System.Int32"/>
  9. <Column Name="CategoryName" DataType="System.String"/>
  10. <Column Name="Description" DataType="System.String"/>
  11. <Column Name="Picture" DataType="System.Byte[]" BindableControl="Picture"/>
  12. </TableDataSource>
  13. <TableDataSource Name="Products" ReferenceName="NorthWind.Products" DataType="System.Int32" Enabled="true">
  14. <Column Name="ProductID" DataType="System.Int32"/>
  15. <Column Name="ProductName" DataType="System.String"/>
  16. <Column Name="SupplierID" DataType="System.Int32"/>
  17. <Column Name="CategoryID" DataType="System.Int32"/>
  18. <Column Name="QuantityPerUnit" DataType="System.String"/>
  19. <Column Name="UnitPrice" DataType="System.Decimal"/>
  20. <Column Name="UnitsInStock" DataType="System.Int16"/>
  21. <Column Name="UnitsOnOrder" DataType="System.Int16"/>
  22. <Column Name="ReorderLevel" DataType="System.Int16"/>
  23. <Column Name="Discontinued" DataType="System.Boolean"/>
  24. <Column Name="EAN13" DataType="System.String"/>
  25. </TableDataSource>
  26. <Relation Name="CategoriesProducts" ReferenceName="NorthWind.CategoriesProducts" ParentDataSource="Categories" ChildDataSource="Products" ParentColumns="CategoryID" ChildColumns="CategoryID" Enabled="true"/>
  27. </Dictionary>
  28. <ReportPage Name="TitlePage" Watermark.Font="Arial, 60pt">
  29. <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="642.6" CanGrow="true">
  30. <TextObject Name="Text3" Top="368.55" Width="718.2" Height="85.05" Text="PRODUCT CATALOG" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 20pt, style=Bold"/>
  31. </ReportTitleBand>
  32. <PageFooterBand Name="PageFooter2" Top="644.6" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
  33. <TextObject Name="Text20" 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"/>
  34. </PageFooterBand>
  35. </ReportPage>
  36. <ReportPage Name="ContentsPage" Watermark.Font="Arial, 60pt" OutlineExpression="&quot;Table of Contents&quot;">
  37. <ReportTitleBand Name="ReportTitle2" Width="718.2" Height="66.15">
  38. <TextObject Name="Text4" Top="28.35" Width="302.4" Height="28.35" Text="Table of contents" Font="Segoe UI, 14pt"/>
  39. </ReportTitleBand>
  40. <DataBand Name="Data3" Top="68.15" Width="718.2" Height="28.35" DataSource="Categories">
  41. <LineObject Name="Line2" Top="12.9" Width="718.2" Border.Style="Dot"/>
  42. <TextObject Name="Text14" Width="302.4" Height="18.9" Fill.Color="White" Cursor="Hand" Hyperlink.Kind="Bookmark" Hyperlink.Expression="[Categories.CategoryName]" Text="[Categories.CategoryName]" AutoWidth="true" VertAlign="Center" WordWrap="false" Font="Segoe UI, 10pt"/>
  43. <TextObject Name="Text18" Left="689.85" Width="28.35" Height="18.9" Fill.Color="White" Cursor="Hand" Hyperlink.Kind="Bookmark" Hyperlink.Expression="[Categories.CategoryName]" Text="[Engine.GetBookmarkPage([Categories.CategoryName])]" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 10pt" TextFill.Color="Blue"/>
  44. </DataBand>
  45. <PageFooterBand Name="PageFooter3" Top="98.5" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
  46. <TextObject Name="Text21" 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"/>
  47. </PageFooterBand>
  48. </ReportPage>
  49. <ReportPage Name="CatalogPage" Watermark.Font="Arial, 60pt">
  50. <DataBand Name="Data1" Width="718.2" Height="103.95" Fill.Color="Orange" Bookmark="[Categories.CategoryName]" OutlineExpression="[Categories.CategoryName]" DataSource="Categories" KeepDetail="true">
  51. <TextObject Name="Text1" Left="160.65" Top="9.45" Width="302.4" Height="28.35" Bookmark="[Categories.CategoryName]" Text="[Categories.CategoryName]" Font="Segoe UI, 14pt"/>
  52. <PictureObject Name="Picture1" Left="9.45" Top="9.45" Width="141.75" Height="85.05" DataColumn="Categories.Picture"/>
  53. <TextObject Name="Text2" Left="160.65" Top="47.25" Width="302.4" Height="47.25" Text="[Categories.Description]" Font="Segoe UI, 9pt"/>
  54. <TextObject Name="Text15" Left="614.25" Top="9.45" Width="94.5" Height="18.9" Cursor="Hand" Hyperlink.Kind="PageNumber" Hyperlink.Value="1" Text="back to top" HorzAlign="Right" Font="Segoe UI, 9pt, style=Underline" TextFill.Color="Blue"/>
  55. <DataBand Name="Data2" Top="136.3" Width="718.2" Height="18.9" EvenStyle="EvenRows" OutlineExpression="[Products.ProductName]" DataSource="Products">
  56. <TextObject Name="Text5" Width="245.7" Height="18.9" Text="[Products.ProductName]" VertAlign="Center" Font="Segoe UI, 9pt"/>
  57. <TextObject Name="Text7" Left="245.7" Width="122.85" Height="18.9" Text="[Products.UnitPrice]" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  58. <TextObject Name="Text9" Left="368.55" Width="122.85" Height="18.9" Text="[Products.UnitsInStock]" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt"/>
  59. <CheckBoxObject Name="CheckBox1" Left="529.2" Width="18.9" Height="18.9" Checked="false" DataColumn="Products.Discontinued"/>
  60. <TextObject Name="Text13" Left="595.35" Width="122.85" Height="18.9" Fill.Color="Orange" VertAlign="Center" Font="Segoe UI, 9pt"/>
  61. <DataHeaderBand Name="DataHeader1" Top="105.95" Width="718.2" Height="28.35" Fill.Color="OldLace">
  62. <TextObject Name="Text6" Width="245.7" Height="28.35" Text="Product name" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  63. <TextObject Name="Text8" Left="245.7" Width="122.85" Height="28.35" Text="Unit price" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  64. <TextObject Name="Text10" Left="368.55" Width="122.85" Height="28.35" Text="Units in stock" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  65. <TextObject Name="Text12" Left="491.4" Width="94.5" Height="28.35" Text="Discontinued" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  66. <TextObject Name="Text11" Left="595.35" Width="122.85" Height="28.35" Fill.Color="Orange" VertAlign="Center" Font="Segoe UI, 9pt"/>
  67. </DataHeaderBand>
  68. <DataFooterBand Name="DataFooter1" Top="157.2" Width="718.2" Height="37.8"/>
  69. <Sort>
  70. <Sort Expression="[Products.ProductName]"/>
  71. </Sort>
  72. </DataBand>
  73. </DataBand>
  74. <PageFooterBand Name="PageFooter1" Top="197" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
  75. <TextObject Name="Text17" Left="623.7" Width="94.5" Height="28.35" Text="[PageN]" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  76. <TextObject Name="Text22" 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"/>
  77. </PageFooterBand>
  78. </ReportPage>
  79. </Report>