3rdpartylibs/fastreports.wpf/Demos/Reports.New/Interactive Reports/Interactive Matrix.frx

<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates how to create an interactive report using the Matrix object. Its cells are clickable and can be used to display the detailed report about the cell's value. To create such a report:&#13;&#10;- select the matrix cell, go to &quot;Properties&quot; window and setup the &quot;Hyperlink&quot; property:&#13;&#10;- set the &quot;Kind&quot; to &quot;DetailReport&quot;;&#13;&#10;- set the &quot;DetailReportName&quot; to detail report's file;&#13;&#10;- set the &quot;ReportParameter&quot; to the detailed report's parameter name.&#13;&#10;&#13;&#10;When you click a cell in the preview window, the detailed report will be loaded and opened with a parameter that describes the cell's address. The address contains all column and row values separated by semicolon. In the detailed report, you have to use the parameter to filter the data. See how to do it in the &quot;Interactive Matrix - Details.frx&quot; report.&#13;&#10;&#13;&#10;Learn how to build this report on the Fast Reports Academy channel http://fast.report/f1e6d" ReportInfo.Created="05/15/2008 00:47:48" ReportInfo.Modified="04/07/2023 02:27:37" ReportInfo.CreatorVersion="1.0.0.0">
  <ScriptText>using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Windows.Forms;
using System.Drawing;
using System.Data;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;

namespace FastReport
{
  public class ReportScript
  {
      
    private void Cell4_MouseEnter(object sender, EventArgs e)
    {
      TableCell cell = sender as TableCell;
      cell.Fill = new GlassFill(Color.DarkOrange, 0.2f, false);
      cell.Page.Refresh();      
    }

    private void Cell4_MouseLeave(object sender, EventArgs e)
    {
      TableCell cell = sender as TableCell;
      cell.Fill = new SolidFill(Color.FromArgb(77,77,77));
      cell.Page.Refresh();      
    }
  }
}
</ScriptText>
  <Dictionary>
    <TableDataSource Name="Categories" ReferenceName="NorthWind.Categories" DataType="System.Int32" Enabled="true">
      <Column Name="CategoryID" DataType="System.Int32"/>
      <Column Name="CategoryName" DataType="System.String"/>
      <Column Name="Description" DataType="System.String"/>
      <Column Name="Picture" DataType="System.Byte[]" BindableControl="Picture"/>
    </TableDataSource>
    <TableDataSource Name="Customers" ReferenceName="NorthWind.Customers" DataType="System.Int32" Enabled="true">
      <Column Name="CustomerID" DataType="System.String"/>
      <Column Name="CompanyName" DataType="System.String"/>
      <Column Name="ContactName" DataType="System.String"/>
      <Column Name="ContactTitle" DataType="System.String"/>
      <Column Name="Address" DataType="System.String"/>
      <Column Name="City" DataType="System.String"/>
      <Column Name="Region" DataType="System.String"/>
      <Column Name="PostalCode" DataType="System.String"/>
      <Column Name="Country" DataType="System.String"/>
      <Column Name="Phone" DataType="System.String"/>
      <Column Name="Fax" DataType="System.String"/>
    </TableDataSource>
    <TableDataSource Name="Employees" ReferenceName="NorthWind.Employees" DataType="System.Int32" Enabled="true">
      <Column Name="EmployeeID" DataType="System.Int32"/>
      <Column Name="LastName" DataType="System.String"/>
      <Column Name="FirstName" DataType="System.String"/>
      <Column Name="Title" DataType="System.String"/>
      <Column Name="TitleOfCourtesy" DataType="System.String"/>
      <Column Name="BirthDate" DataType="System.DateTime"/>
      <Column Name="HireDate" DataType="System.DateTime"/>
      <Column Name="Address" DataType="System.String"/>
      <Column Name="City" DataType="System.String"/>
      <Column Name="Region" DataType="System.String"/>
      <Column Name="PostalCode" DataType="System.String"/>
      <Column Name="Country" DataType="System.String"/>
      <Column Name="HomePhone" DataType="System.String"/>
      <Column Name="Extension" DataType="System.String"/>
      <Column Name="Photo" DataType="System.Byte[]" BindableControl="Picture"/>
      <Column Name="Notes" DataType="System.String"/>
      <Column Name="ReportsTo" DataType="System.Int32"/>
    </TableDataSource>
    <TableDataSource Name="Order Details" ReferenceName="NorthWind.Order Details" DataType="System.Int32" Enabled="true">
      <Column Name="OrderID" DataType="System.Int32"/>
      <Column Name="ProductID" DataType="System.Int32"/>
      <Column Name="UnitPrice" DataType="System.Decimal"/>
      <Column Name="Quantity" DataType="System.Int16"/>
      <Column Name="Discount" DataType="System.Single"/>
    </TableDataSource>
    <TableDataSource Name="Orders" ReferenceName="NorthWind.Orders" DataType="System.Int32" Enabled="true">
      <Column Name="OrderID" DataType="System.Int32"/>
      <Column Name="CustomerID" DataType="System.String"/>
      <Column Name="EmployeeID" DataType="System.Int32"/>
      <Column Name="OrderDate" DataType="System.DateTime"/>
      <Column Name="RequiredDate" DataType="System.DateTime"/>
      <Column Name="ShippedDate" DataType="System.DateTime"/>
      <Column Name="ShipVia" DataType="System.Int32"/>
      <Column Name="Freight" DataType="System.Decimal"/>
      <Column Name="ShipName" DataType="System.String"/>
      <Column Name="ShipAddress" DataType="System.String"/>
      <Column Name="ShipCity" DataType="System.String"/>
      <Column Name="ShipRegion" DataType="System.String"/>
      <Column Name="ShipPostalCode" DataType="System.String"/>
      <Column Name="ShipCountry" DataType="System.String"/>
      <Column Name="Latitude" DataType="System.Double"/>
      <Column Name="Longitude" DataType="System.Double"/>
    </TableDataSource>
    <TableDataSource Name="Products" ReferenceName="NorthWind.Products" DataType="System.Int32" Enabled="true">
      <Column Name="ProductID" DataType="System.Int32"/>
      <Column Name="ProductName" DataType="System.String"/>
      <Column Name="SupplierID" DataType="System.Int32"/>
      <Column Name="CategoryID" DataType="System.Int32"/>
      <Column Name="QuantityPerUnit" DataType="System.String"/>
      <Column Name="UnitPrice" DataType="System.Decimal"/>
      <Column Name="UnitsInStock" DataType="System.Int16"/>
      <Column Name="UnitsOnOrder" DataType="System.Int16"/>
      <Column Name="ReorderLevel" DataType="System.Int16"/>
      <Column Name="Discontinued" DataType="System.Boolean" BindableControl="CheckBox"/>
      <Column Name="EAN13" DataType="System.String"/>
    </TableDataSource>
    <TableDataSource Name="Shippers" ReferenceName="NorthWind.Shippers" DataType="System.Int32" Enabled="true">
      <Column Name="ShipperID" DataType="System.Int32"/>
      <Column Name="CompanyName" DataType="System.String"/>
      <Column Name="Phone" DataType="System.String"/>
    </TableDataSource>
    <TableDataSource Name="Suppliers" ReferenceName="NorthWind.Suppliers" DataType="System.Int32" Enabled="true">
      <Column Name="SupplierID" DataType="System.Int32"/>
      <Column Name="CompanyName" DataType="System.String"/>
      <Column Name="ContactName" DataType="System.String"/>
      <Column Name="ContactTitle" DataType="System.String"/>
      <Column Name="Address" DataType="System.String"/>
      <Column Name="City" DataType="System.String"/>
      <Column Name="Region" DataType="System.String"/>
      <Column Name="PostalCode" DataType="System.String"/>
      <Column Name="Country" DataType="System.String"/>
      <Column Name="Phone" DataType="System.String"/>
      <Column Name="Fax" DataType="System.String"/>
      <Column Name="HomePage" DataType="System.String"/>
    </TableDataSource>
    <Relation Name="SuppliersProducts" ReferenceName="NorthWind.SuppliersProducts" ParentDataSource="Suppliers" ChildDataSource="Products" ParentColumns="SupplierID" ChildColumns="SupplierID" Enabled="true"/>
    <Relation Name="CategoriesProducts" ReferenceName="NorthWind.CategoriesProducts" ParentDataSource="Categories" ChildDataSource="Products" ParentColumns="CategoryID" ChildColumns="CategoryID" Enabled="true"/>
    <Relation Name="EmployeesOrders" ReferenceName="NorthWind.EmployeesOrders" ParentDataSource="Employees" ChildDataSource="Orders" ParentColumns="EmployeeID" ChildColumns="EmployeeID" Enabled="true"/>
    <Relation Name="ShippersOrders" ReferenceName="NorthWind.ShippersOrders" ParentDataSource="Shippers" ChildDataSource="Orders" ParentColumns="ShipperID" ChildColumns="ShipVia" Enabled="true"/>
    <Relation Name="CustomersOrders" ReferenceName="NorthWind.CustomersOrders" ParentDataSource="Customers" ChildDataSource="Orders" ParentColumns="CustomerID" ChildColumns="CustomerID" Enabled="true"/>
    <Relation Name="OrdersOrderDetails" ReferenceName="NorthWind.OrdersOrderDetails" ParentDataSource="Orders" ChildDataSource="Order Details" ParentColumns="OrderID" ChildColumns="OrderID" Enabled="true"/>
    <Relation Name="ProductsOrderDetails" ReferenceName="NorthWind.ProductsOrderDetails" ParentDataSource="Products" ChildDataSource="Order Details" ParentColumns="ProductID" ChildColumns="ProductID" Enabled="true"/>
  </Dictionary>
  <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="37.8" CanGrow="true">
      <TextObject Name="Text1" Width="718.2" Height="37.8" Text="Products by Employees (click the value to view order details)" VertAlign="Center" Font="Segoe UI, 12pt, style=Bold"/>
    </ReportTitleBand>
    <DataBand Name="Data1" Top="39.8" Width="718.2" Height="434.7">
      <MatrixObject Name="Matrix1" Left="18.9" Top="9.45" Width="396.9" Height="415.8" FixedRows="1" FixedColumns="1" AutoSize="false" DataSource="Order Details" Style="Green">
        <MatrixColumns>
          <Header Expression="[Order Details.Orders.Employees.FirstName] + &quot; &quot; + [Order Details.Orders.Employees.LastName]"/>
        </MatrixColumns>
        <MatrixRows>
          <Header Expression="[Order Details.Products.Categories.CategoryName]"/>
        </MatrixRows>
        <MatrixCells>
          <Cell Expression="[Order Details.UnitPrice] * [Order Details.Quantity] * (decimal)(1 - [Order Details.Discount])"/>
        </MatrixCells>
        <TableColumn Name="Column1" MaxWidth="151.2" Width="151.2"/>
        <TableColumn Name="Column2" MaxWidth="189" Width="122.85"/>
        <TableColumn Name="Column3" Width="122.85"/>
        <TableRow Name="Row1" Height="170.1">
          <TableCell Name="Cell1" Border.Lines="All" Border.Color="DarkGray" Fill.Color="64, 64, 64" Text="Product" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
          <TableCell Name="Cell2" Border.Lines="Right, Top, Bottom" Border.Color="DarkGray" Fill.Color="64, 64, 64" Text="Steven Buchanan" Padding="2, 6, 2, 1" AllowExpressions="false" HorzAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White">
            <PictureObject Left="9.45" Top="28.35" Width="103.95" Height="132.3" DataColumn="Order Details.Orders.Employees.Photo" SizeMode="StretchImage"/>
          </TableCell>
          <TableCell Name="Cell7" Border.Lines="Right, Top, Bottom" Border.Color="DarkGray" Fill.Color="64, 64, 64" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
        </TableRow>
        <TableRow Name="Row2" Height="122.85">
          <TableCell Name="Cell3" Border.Lines="Left, Right, Bottom" Border.Color="DarkGray" Fill.Color="64, 64, 64" Text="Seafood" Padding="2, 6, 2, 1" AllowExpressions="false" HorzAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White">
            <PictureObject Left="9.45" Top="28.35" Width="132.3" Height="85.05" DataColumn="Order Details.Products.Categories.Picture" SizeMode="StretchImage"/>
          </TableCell>
          <TableCell Name="Cell4" Border.Lines="Right, Bottom" Border.Color="DarkGray" Fill.Color="77, 77, 77" Cursor="Hand" Hyperlink.Kind="DetailReport" Hyperlink.DetailReportName="Interactive Matrix - Details.frx" Hyperlink.ReportParameter="Cell Address" MouseEnterEvent="Cell4_MouseEnter" MouseLeaveEvent="Cell4_MouseLeave" Text="$5,744.25" AllowExpressions="false" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
          <TableCell Name="Cell8" Border.Lines="Right, Bottom" Border.Color="DarkGray" Fill.Color="77, 77, 77" Text="$131 261.74" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
        </TableRow>
        <TableRow Name="Row3" Height="122.85">
          <TableCell Name="Cell5" Border.Lines="Left, Right, Bottom" Border.Color="DarkGray" Fill.Color="64, 64, 64" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
          <TableCell Name="Cell6" Border.Lines="Right, Bottom" Border.Color="DarkGray" Fill.Color="77, 77, 77" Text="$68 624.28" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
          <TableCell Name="Cell9" Border.Lines="Right, Bottom" Border.Color="DarkGray" Fill.Color="77, 77, 77" Text="$1 265 793.04" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
        </TableRow>
      </MatrixObject>
    </DataBand>
    <PageFooterBand Name="PageFooter1" Top="476.5" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
      <TextObject Name="Text12" 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"/>
    </PageFooterBand>
  </ReportPage>
</Report>