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

<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="06/08/2008 02:20:53" ReportInfo.Modified="04/07/2023 02:28:42" 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
  {
  }    
}
</ScriptText>
  <Styles>
    <Style Name="EvenStyle" Fill.Color="WhiteSmoke" Font="Arial, 10pt"/>
  </Styles>
  <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="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>
    <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="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"/>
    <Parameter Name="Cell Address" DataType="System.String" AsString="">
      <Parameter Name="Employee" DataType="System.String" AsString=""/>
      <Parameter Name="Category" DataType="System.String" AsString=""/>
    </Parameter>
    <Total Name="SumOfOrders" Expression="[Order Details.UnitPrice] * [Order Details.Quantity] * (decimal)(1 - [Order Details.Discount])" Evaluator="Data1" PrintOn="DataFooter1"/>
  </Dictionary>
  <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="37.8">
      <TextObject Name="Text1" Width="718.2" Height="28.35" Text="[Cell Address.Employee]'s orders" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="39.8" Width="718.2" Height="28.35">
      <TextObject Name="Text3" Left="415.8" Width="94.5" Height="18.9" Text="Unit Price" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
      <TextObject Name="Text5" Left="519.75" Width="94.5" Height="18.9" Text="Quantity" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
      <TextObject Name="Text7" Left="623.7" Width="94.5" Height="18.9" Text="Discount" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
      <TextObject Name="Text9" Left="141.75" Width="264.6" Height="18.9" Text="Product Name" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
      <TextObject Name="Text12" Width="132.3" Height="18.9" Text="Order Date" Font="Segoe UI, 9pt, style=Bold"/>
    </PageHeaderBand>
    <DataBand Name="Data1" Top="70.15" Width="718.2" Height="18.9" EvenStyle="EvenStyle" DataSource="Order Details" Filter="[Order Details.Orders.Employees.FirstName] + &quot; &quot; + [Order Details.Orders.Employees.LastName] == [Cell Address.Employee] &amp;&amp; [Order Details.Products.Categories.CategoryName] == [Cell Address.Category]">
      <TextObject Name="Text2" Left="415.8" Width="94.5" Height="18.9" Text="[Order Details.UnitPrice]" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
      <TextObject Name="Text4" Left="519.75" Width="94.5" Height="18.9" Text="[Order Details.Quantity]" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt"/>
      <TextObject Name="Text6" Left="623.7" Width="94.5" Height="18.9" Text="[Order Details.Discount]" Format="Percent" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
      <TextObject Name="Text8" Left="141.75" Width="264.6" Height="18.9" Text="[Order Details.Products.ProductName]" VertAlign="Center" Font="Segoe UI, 9pt"/>
      <TextObject Name="Text11" Width="132.3" Height="18.9" Text="[Order Details.Orders.OrderDate]" Format="Date" Format.Format="d" Font="Segoe UI, 9pt"/>
      <DataFooterBand Name="DataFooter1" Top="91.05" Width="718.2" Height="56.7">
        <LineObject Name="Line1" Top="9.45" Width="718.2"/>
        <TextObject Name="Text10" Left="519.75" Top="18.9" Width="198.45" Height="18.9" Text="Total: [SumOfOrders]" Format="Currency" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
      </DataFooterBand>
    </DataBand>
  </ReportPage>
</Report>