Interactive Report, 2-in-1.frx 5.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Report ScriptLanguage="CSharp" ReportInfo.Description="This report acts in the same way as the &quot;Interactive Report.frx&quot; report, but contains the detail report inside - it is placed on a separate page. To create such a report:&#13;&#10;- setup the &quot;Hyperlink&quot; property of the clickable object:&#13;&#10;- set the &quot;Kind&quot; property to &quot;DetailPage&quot;;&#13;&#10;- set the &quot;DetailPageName&quot; property to the name of the report page that contains the detail report;&#13;&#10;- set the detail page visibility to false. This is done automatically when you use the &quot;DetailPageName&quot; property editor.&#13;&#10;&#13;&#10;Learn how to build this report on the Fast Reports Academy channel http://fast.report/a8b52" ReportInfo.Created="01/17/2008 03:55:42" ReportInfo.Modified="04/07/2023 02:25:13" ReportInfo.CreatorVersion="1.0.0.0">
  3. <Styles>
  4. <Style Name="EvenRows" 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" BindableControl="CheckBox"/>
  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. <Parameter Name="CategoryName" DataType="System.String" AsString=""/>
  28. </Dictionary>
  29. <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
  30. <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="66.15" CanGrow="true">
  31. <TextObject Name="Text3" Width="718.2" Height="37.8" Text="CATEGORIES" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold"/>
  32. <TextObject Name="Text1" Top="37.8" Width="236.25" Height="18.9" Text="Click the category to see its products." Font="Segoe UI, 9pt"/>
  33. </ReportTitleBand>
  34. <DataBand Name="Data1" Top="68.15" Width="340.2" Height="94.5" DataSource="Categories" Columns.Count="2" Columns.Width="340.2" KeepDetail="true">
  35. <TextObject Name="Text2" Left="141.75" Width="189" Height="28.35" Cursor="Hand" Hyperlink.Kind="DetailPage" Hyperlink.Expression="[Categories.CategoryName]" Hyperlink.DetailPageName="Page2" Hyperlink.ReportParameter="CategoryName" Text="[Categories.CategoryName]" Font="Segoe UI, 9pt, style=Underline" TextFill.Color="Blue"/>
  36. <PictureObject Name="Picture1" Width="132.3" Height="85.05" Border.Lines="All" Border.Color="Gainsboro" Border.Width="2" Cursor="Hand" Hyperlink.Kind="DetailPage" Hyperlink.Expression="[Categories.CategoryName]" Hyperlink.DetailPageName="Page2" Hyperlink.ReportParameter="CategoryName" DataColumn="Categories.Picture" SizeMode="StretchImage"/>
  37. </DataBand>
  38. <PageFooterBand Name="PageFooter1" Top="164.65" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
  39. <TextObject Name="Text13" 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"/>
  40. </PageFooterBand>
  41. </ReportPage>
  42. <ReportPage Name="Page2" Visible="false" Watermark.Font="Arial, 60pt">
  43. <ReportTitleBand Name="ReportTitle2" Width="718.2" Height="47.25">
  44. <TextObject Name="Text8" Width="718.2" Height="37.8" Dock="Top" Text="Product category: [CategoryName]" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold"/>
  45. </ReportTitleBand>
  46. <PageHeaderBand Name="PageHeader1" Top="49.25" Width="718.2" Height="28.35">
  47. <TextObject Name="Text9" Width="226.8" Height="18.9" Text="Product Name" Font="Segoe UI, 9pt, style=Bold"/>
  48. <TextObject Name="Text4" Left="236.25" Width="94.5" Height="18.9" Text="Unit Price" HorzAlign="Right" Font="Segoe UI, 9pt, style=Bold"/>
  49. <TextObject Name="Text6" Left="340.2" Width="94.5" Height="18.9" Text="Units In Stock" HorzAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
  50. <TextObject Name="Text7" Left="453.6" Width="94.5" Height="18.9" Text="Discontinued" Font="Segoe UI, 9pt, style=Bold"/>
  51. </PageHeaderBand>
  52. <DataBand Name="Data2" Top="79.6" Width="718.2" Height="18.9" DataSource="Products" Filter="[Products.Categories.CategoryName] == [CategoryName]">
  53. <TextObject Name="Text10" Width="226.8" Height="18.9" Text="[Products.ProductName]" VertAlign="Center" Font="Segoe UI, 9pt"/>
  54. <TextObject Name="Text11" Left="236.25" Width="94.5" Height="18.9" Text="[Products.UnitPrice]" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
  55. <TextObject Name="Text5" Left="340.2" Width="94.5" Height="18.9" Text="[Products.UnitsInStock]" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt"/>
  56. <CheckBoxObject Name="CheckBox1" Left="491.4" Width="18.9" Height="18.9" DataColumn="Products.Discontinued"/>
  57. </DataBand>
  58. </ReportPage>
  59. </Report>