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

<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Description="Demonstrates how to create an interactive report using the Matrix and Chart objects. When you click employee or category, you will see a chart report that also has clickable elements. &#13;&#10;&#13;&#10;This report uses the same technique as the &quot;Interactive Matrix&quot; report.&#13;&#10;&#13;&#10;Learn how to build this report on the Fast Reports Academy channel http://fast.report/021d2" ReportInfo.Created="05/15/2008 00:47:48" ReportInfo.Modified="03/11/2024 14:35:56" 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 Cell1_MouseEnter(object sender, EventArgs e)
    {
      TableCell cell = sender as TableCell;
      cell.Fill = new GlassFill(Color.DarkOrange, 0.2f, false);
      cell.Page.Refresh();
    }

    private void Cell1_MouseLeave(object sender, EventArgs e)
    {
      TableCell cell = sender as TableCell;
      cell.Fill = new SolidFill(Color.FromArgb(77,77,77));
      cell.Page.Refresh();
    }

    private void Cell2_MouseLeave(object sender, EventArgs e)
    {
      TableCell cell = sender as TableCell;
      cell.Fill = new GlassFill(Color.FromArgb(64,64,64), 0.15f, false);
      cell.Page.Refresh();
    }

    private void Cell3_MouseLeave(object sender, EventArgs e)
    {
      TableCell cell = sender as TableCell;
      cell.Fill = new SolidFill(Color.FromArgb(64,64,64));
      cell.Page.Refresh();
    }
  }
}
</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="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"/>
    <Parameter Name="SelectedCell" DataType="System.String" AsString="">
      <Parameter Name="Employee" DataType="System.String" AsString=""/>
      <Parameter Name="Category" DataType="System.String" AsString=""/>
    </Parameter>
    <Total Name="Total" Expression="[Order Details.UnitPrice] * [Order Details.Quantity] * (1 - (decimal)[Order Details.Discount])" Evaluator="Data3" PrintOn="DataFooter1"/>
  </Dictionary>
  <ReportPage Name="Page1" Landscape="true" PaperWidth="297" PaperHeight="210" Watermark.Font="Arial, 60pt" FirstPageSource="1">
    <ReportTitleBand Name="ReportTitle1" Width="1047.06" Height="264.59" CanGrow="true">
      <MatrixObject Name="Matrix1" Top="75.59" Width="283.5" Height="170.1" 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="103.95"/>
        <TableColumn Name="Column2" MaxWidth="189" Width="85.05"/>
        <TableColumn Name="Column3" Width="94.5"/>
        <TableRow Name="Row1" Height="56.7">
          <TableCell Name="Cell1" Border.Lines="All" Border.Color="DarkGray" Fill="Glass" Fill.Color="64, 64, 64" Fill.Blend="0.15" Fill.Hatch="false" Text="Product" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
          <TableCell Name="Cell2" Border.Lines="All" Border.Color="DarkGray" Fill="Glass" Fill.Color="64, 64, 64" Fill.Blend="0.15" Fill.Hatch="false" Cursor="Hand" Hyperlink.Kind="DetailPage" Hyperlink.Expression="[Order Details.Orders.Employees.FirstName] + &quot; &quot; + [Order Details.Orders.Employees.LastName]" Hyperlink.DetailPageName="Page2" Hyperlink.ReportParameter="SelectedCell.Employee" MouseEnterEvent="Cell1_MouseEnter" MouseLeaveEvent="Cell2_MouseLeave" Text="[Order Details.Orders.Employees.FirstName] + &quot; &quot; + [Order Details.Orders.Employees.LastName]" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
          <TableCell Name="Cell7" Border.Lines="All" Border.Color="DarkGray" Fill="Glass" Fill.Color="64, 64, 64" Fill.Blend="0.15" Fill.Hatch="false" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
        </TableRow>
        <TableRow Name="Row2" Height="56.7">
          <TableCell Name="Cell3" Border.Lines="All" Border.Color="DarkGray" Fill.Color="64, 64, 64" Cursor="Hand" Hyperlink.Kind="DetailPage" Hyperlink.Expression="[Order Details.Products.Categories.CategoryName]" Hyperlink.DetailPageName="Page3" Hyperlink.ReportParameter="SelectedCell.Category" MouseEnterEvent="Cell1_MouseEnter" MouseLeaveEvent="Cell3_MouseLeave" Text="[CategoryName]" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
          <TableCell Name="Cell4" Border.Lines="All" Border.Color="DarkGray" Fill.Color="77, 77, 77" Cursor="Hand" Hyperlink.Kind="DetailPage" Hyperlink.DetailReportName="Interactive Matrix - Details.frx" Hyperlink.DetailPageName="Page4" Hyperlink.ReportParameter="SelectedCell" MouseEnterEvent="Cell1_MouseEnter" MouseLeaveEvent="Cell1_MouseLeave" Text="[[Order Details.UnitPrice] * [Order Details.Quantity] * (decimal)(1 - [Order Details.Discount])]" AllowExpressions="false" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt" TextFill.Color="White"/>
          <TableCell Name="Cell8" Border.Lines="All" Border.Color="DarkGray" Fill.Color="77, 77, 77" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
        </TableRow>
        <TableRow Name="Row3" Height="56.7">
          <TableCell Name="Cell5" Border.Lines="All" 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="All" Border.Color="DarkGray" Fill.Color="77, 77, 77" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
          <TableCell Name="Cell9" Border.Lines="All" Border.Color="DarkGray" Fill.Color="77, 77, 77" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="White"/>
        </TableRow>
      </MatrixObject>
      <TextObject Name="Text1" Width="1039.5" Height="37.8" Text="Sales by employees" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt"/>
      <TextObject Name="Text6" Left="330.75" Top="37.8" Width="378" Height="18.9" Text="click employee, category or value to view details" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt"/>
    </ReportTitleBand>
    <PageFooterBand Name="PageFooter1" Top="266.59" Width="1047.06" Height="28.35" Fill.Color="WhiteSmoke">
      <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"/>
    </PageFooterBand>
  </ReportPage>
  <ReportPage Name="Page2" Visible="false" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle2" Width="718.2" Height="56.7">
      <TextObject Name="Text2" Width="718.2" Height="28.35" Text="[SelectedCell.Employee] sales" HorzAlign="Center" Font="Segoe UI, 14pt"/>
      <TextObject Name="Text5" Left="245.7" Top="28.35" Width="226.8" Height="18.9" Text="click value to view details" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt"/>
    </ReportTitleBand>
    <DataBand Name="Data1" Top="58.7" Width="718.2" Height="396.9">
      <MSChartObject Name="MSChart1" Top="18.9" Width="718.2" Height="368.55" Hyperlink.Kind="DetailPage" Hyperlink.DetailPageName="Page4" Hyperlink.ReportParameter="SelectedCell.Category" DataSource="Order Details" Filter="[Order Details.Orders.Employees.FirstName] + &quot; &quot; + [Order Details.Orders.Employees.LastName] == [SelectedCell.Employee]" ChartData="PENoYXJ0IFJpZ2h0VG9MZWZ0PSJObyIgQm9yZGVybGluZUNvbG9yPSJEYXJrR3JheSIgQm9yZGVybGluZVdpZHRoPSIyIiBCb3JkZXJsaW5lRGFzaFN0eWxlPSJTb2xpZCI+DQogIDxTZXJpZXM+DQogICAgPFNlcmllcyBOYW1lPSJTZXJpZXMxIiBMZWdlbmQ9IkRlZmF1bHQiIFhWYWx1ZVR5cGU9IlN0cmluZyIgWVZhbHVlVHlwZT0iRG91YmxlIiBDaGFydFR5cGU9IlBpZSIgQ2hhcnRBcmVhPSJEZWZhdWx0IiBMYWJlbD0iI1ZBTFg6ICNWQUxZe0N9IiBGb250PSJUYWhvbWEsIDguMjVwdCIgQ3VzdG9tUHJvcGVydGllcz0iUGllRHJhd2luZ1N0eWxlPUNvbmNhdmUsIFBpZUxhYmVsU3R5bGU9T3V0c2lkZSwgUGllTGluZUNvbG9yPVNpbHZlciI+DQogICAgICA8UG9pbnRzPg0KICAgICAgICA8RGF0YVBvaW50IFlWYWx1ZXM9IjEiIEF4aXNMYWJlbD0iQSIgLz4NCiAgICAgICAgPERhdGFQb2ludCBZVmFsdWVzPSIyIiBBeGlzTGFiZWw9IkIiIC8+DQogICAgICA8L1BvaW50cz4NCiAgICA8L1Nlcmllcz4NCiAgPC9TZXJpZXM+DQogIDxMZWdlbmRzPg0KICAgIDxMZWdlbmQgTmFtZT0iRGVmYXVsdCIgRW5hYmxlZD0iRmFsc2UiIElzVGV4dEF1dG9GaXQ9IkZhbHNlIiBGb250PSJUYWhvbWEsIDhwdCI+DQogICAgPC9MZWdlbmQ+DQogIDwvTGVnZW5kcz4NCiAgPFRpdGxlcz4NCiAgICA8VGl0bGUgTmFtZT0iVGl0bGUxIiBWaXNpYmxlPSJGYWxzZSIgRm9udD0iVGFob21hLCAxMHB0LCBzdHlsZT1Cb2xkIj4NCiAgICA8L1RpdGxlPg0KICA8L1RpdGxlcz4NCiAgPENoYXJ0QXJlYXM+DQogICAgPENoYXJ0QXJlYSBOYW1lPSJEZWZhdWx0Ij4NCiAgICAgIDxBeGlzWSBJc0xhYmVsQXV0b0ZpdD0iRmFsc2UiPg0KICAgICAgICA8TWFqb3JHcmlkIExpbmVDb2xvcj0iNjQsIDY0LCA2NCwgNjQiIC8+DQogICAgICAgIDxMYWJlbFN0eWxlIEZvbnQ9IlRhaG9tYSwgOHB0IiAvPg0KICAgICAgPC9BeGlzWT4NCiAgICAgIDxBeGlzWCBJc0xhYmVsQXV0b0ZpdD0iRmFsc2UiPg0KICAgICAgICA8TWFqb3JHcmlkIExpbmVDb2xvcj0iNjQsIDY0LCA2NCwgNjQiIC8+DQogICAgICAgIDxMYWJlbFN0eWxlIEZvbnQ9IlRhaG9tYSwgOHB0IiAvPg0KICAgICAgPC9BeGlzWD4NCiAgICAgIDxBeGlzWDIgSXNMYWJlbEF1dG9GaXQ9IkZhbHNlIj4NCiAgICAgICAgPE1ham9yR3JpZCBMaW5lQ29sb3I9IjY0LCA2NCwgNjQsIDY0IiAvPg0KICAgICAgICA8TGFiZWxTdHlsZSBGb250PSJUYWhvbWEsIDhwdCIgLz4NCiAgICAgIDwvQXhpc1gyPg0KICAgICAgPEF4aXNZMiBJc0xhYmVsQXV0b0ZpdD0iRmFsc2UiPg0KICAgICAgICA8TWFqb3JHcmlkIExpbmVDb2xvcj0iNjQsIDY0LCA2NCwgNjQiIC8+DQogICAgICAgIDxMYWJlbFN0eWxlIEZvbnQ9IlRhaG9tYSwgOHB0IiAvPg0KICAgICAgPC9BeGlzWTI+DQogICAgPC9DaGFydEFyZWE+DQogIDwvQ2hhcnRBcmVhcz4NCiAgPEJvcmRlclNraW4gU2tpblN0eWxlPSJFbWJvc3MiIC8+DQo8L0NoYXJ0Pg==">
        <MSChartSeries Name="Series2" GroupBy="XValue" XValue="[Order Details.Products.Categories.CategoryName]" YValue1="[Order Details.UnitPrice] * [Order Details.Quantity] * (1 - (decimal)[Order Details.Discount])"/>
      </MSChartObject>
    </DataBand>
  </ReportPage>
  <ReportPage Name="Page3" Visible="false" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle3" Width="718.2" Height="56.7">
      <TextObject Name="Text3" Width="718.2" Height="28.35" Text="Sales by employee in the &quot;[SelectedCell.Category]&quot; category" HorzAlign="Center" Font="Segoe UI, 14pt"/>
      <TextObject Name="Text4" Left="207.9" Top="28.35" Width="226.8" Height="18.9" Text="click value to view details" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt"/>
    </ReportTitleBand>
    <DataBand Name="Data2" Top="58.7" Width="718.2" Height="387.45">
      <MSChartObject Name="MSChart2" Top="18.9" Width="718.2" Height="368.55" Hyperlink.Kind="DetailPage" Hyperlink.DetailPageName="Page4" Hyperlink.ReportParameter="SelectedCell.Employee" DataSource="Order Details" Filter="[Order Details.Products.Categories.CategoryName] == [SelectedCell.Category]" ChartData="PENoYXJ0IFJpZ2h0VG9MZWZ0PSJObyIgQm9yZGVybGluZUNvbG9yPSJEYXJrR3JheSIgQm9yZGVybGluZVdpZHRoPSIyIiBCb3JkZXJsaW5lRGFzaFN0eWxlPSJTb2xpZCI+DQogIDxTZXJpZXM+DQogICAgPFNlcmllcyBOYW1lPSJTZXJpZXMxIiBMZWdlbmQ9IkRlZmF1bHQiIFhWYWx1ZVR5cGU9IlN0cmluZyIgWVZhbHVlVHlwZT0iRG91YmxlIiBDaGFydFR5cGU9IlBpZSIgQ2hhcnRBcmVhPSJEZWZhdWx0IiBMYWJlbD0iI1ZBTFg6ICNWQUxZe0N9IiBGb250PSJUYWhvbWEsIDguMjVwdCIgQ3VzdG9tUHJvcGVydGllcz0iUGllRHJhd2luZ1N0eWxlPUNvbmNhdmUsIFBpZUxhYmVsU3R5bGU9T3V0c2lkZSwgUGllTGluZUNvbG9yPVNpbHZlciI+DQogICAgICA8UG9pbnRzPg0KICAgICAgICA8RGF0YVBvaW50IFlWYWx1ZXM9IjEiIEF4aXNMYWJlbD0iQSIgLz4NCiAgICAgICAgPERhdGFQb2ludCBZVmFsdWVzPSIyIiBBeGlzTGFiZWw9IkIiIC8+DQogICAgICA8L1BvaW50cz4NCiAgICA8L1Nlcmllcz4NCiAgPC9TZXJpZXM+DQogIDxMZWdlbmRzPg0KICAgIDxMZWdlbmQgTmFtZT0iRGVmYXVsdCIgRW5hYmxlZD0iRmFsc2UiIElzVGV4dEF1dG9GaXQ9IkZhbHNlIiBGb250PSJUYWhvbWEsIDhwdCI+DQogICAgPC9MZWdlbmQ+DQogIDwvTGVnZW5kcz4NCiAgPFRpdGxlcz4NCiAgICA8VGl0bGUgTmFtZT0iVGl0bGUxIiBWaXNpYmxlPSJGYWxzZSIgRm9udD0iVGFob21hLCAxMHB0LCBzdHlsZT1Cb2xkIj4NCiAgICA8L1RpdGxlPg0KICA8L1RpdGxlcz4NCiAgPENoYXJ0QXJlYXM+DQogICAgPENoYXJ0QXJlYSBOYW1lPSJEZWZhdWx0Ij4NCiAgICAgIDxBeGlzWSBJc0xhYmVsQXV0b0ZpdD0iRmFsc2UiPg0KICAgICAgICA8TWFqb3JHcmlkIExpbmVDb2xvcj0iNjQsIDY0LCA2NCwgNjQiIC8+DQogICAgICAgIDxMYWJlbFN0eWxlIEZvbnQ9IlRhaG9tYSwgOHB0IiAvPg0KICAgICAgPC9BeGlzWT4NCiAgICAgIDxBeGlzWCBJc0xhYmVsQXV0b0ZpdD0iRmFsc2UiPg0KICAgICAgICA8TWFqb3JHcmlkIExpbmVDb2xvcj0iNjQsIDY0LCA2NCwgNjQiIC8+DQogICAgICAgIDxMYWJlbFN0eWxlIEZvbnQ9IlRhaG9tYSwgOHB0IiAvPg0KICAgICAgPC9BeGlzWD4NCiAgICAgIDxBeGlzWDIgSXNMYWJlbEF1dG9GaXQ9IkZhbHNlIj4NCiAgICAgICAgPE1ham9yR3JpZCBMaW5lQ29sb3I9IjY0LCA2NCwgNjQsIDY0IiAvPg0KICAgICAgICA8TGFiZWxTdHlsZSBGb250PSJUYWhvbWEsIDhwdCIgLz4NCiAgICAgIDwvQXhpc1gyPg0KICAgICAgPEF4aXNZMiBJc0xhYmVsQXV0b0ZpdD0iRmFsc2UiPg0KICAgICAgICA8TWFqb3JHcmlkIExpbmVDb2xvcj0iNjQsIDY0LCA2NCwgNjQiIC8+DQogICAgICAgIDxMYWJlbFN0eWxlIEZvbnQ9IlRhaG9tYSwgOHB0IiAvPg0KICAgICAgPC9BeGlzWTI+DQogICAgPC9DaGFydEFyZWE+DQogIDwvQ2hhcnRBcmVhcz4NCiAgPEJvcmRlclNraW4gU2tpblN0eWxlPSJFbWJvc3MiIC8+DQo8L0NoYXJ0Pg==">
        <MSChartSeries Name="Series3" GroupBy="XValue" XValue="[Order Details.Orders.Employees.FirstName] + &quot; &quot; + [Order Details.Orders.Employees.LastName]" YValue1="[Order Details.UnitPrice] * [Order Details.Quantity] * (1 - (decimal)[Order Details.Discount])"/>
      </MSChartObject>
    </DataBand>
  </ReportPage>
  <ReportPage Name="Page4" Visible="false" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle4" Width="718.2" Height="47.25">
      <TextObject Name="Text7" Width="718.2" Height="28.35" Text="Sales by [SelectedCell.Employee] in the &quot;[SelectedCell.Category]&quot; category" Font="Segoe UI, 14pt"/>
    </ReportTitleBand>
    <DataBand Name="Data3" Top="89.05" Width="718.2" Height="18.9" DataSource="Order Details" Filter="[Order Details.Orders.Employees.FirstName] + &quot; &quot; + [Order Details.Orders.Employees.LastName] == [SelectedCell.Employee] &amp;&amp; [Order Details.Products.Categories.CategoryName] == [SelectedCell.Category]">
      <TextObject Name="Text8" Left="94.5" Width="245.7" Height="18.9" EvenStyle="EvenStyle" Text="[Order Details.Products.ProductName]" VertAlign="Center" Font="Segoe UI, 9pt"/>
      <TextObject Name="Text10" Left="340.2" Width="75.6" Height="18.9" EvenStyle="EvenStyle" Text="[Order Details.UnitPrice]" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
      <TextObject Name="Text12" Left="415.8" Width="75.6" Height="18.9" EvenStyle="EvenStyle" Text="[Order Details.Quantity]" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt"/>
      <TextObject Name="Text14" Left="491.4" Width="75.6" Height="18.9" EvenStyle="EvenStyle" Text="[Order Details.Discount]" Format="Percent" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt"/>
      <TextObject Name="Text18" Width="94.5" Height="18.9" EvenStyle="EvenStyle" Text="[Order Details.Orders.OrderDate]" Format="Date" Format.Format="d" HorzAlign="Right" Font="Segoe UI, 9pt"/>
      <DataHeaderBand Name="DataHeader1" Top="49.25" Width="718.2" Height="37.8">
        <TextObject Name="Text9" Left="94.5" Width="245.7" Height="18.9" Text="Product" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
        <TextObject Name="Text11" Left="340.2" Width="75.6" Height="18.9" Text="Unit Price" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
        <TextObject Name="Text13" Left="415.8" Width="75.6" Height="18.9" Text="Quantity" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
        <TextObject Name="Text15" Left="491.4" Width="75.6" Height="18.9" Text="Discount" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
        <TextObject Name="Text19" Width="94.5" Height="18.9" Text="Order Date" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
        <LineObject Name="Line2" Top="28.35" Width="567" Border.Color="DarkGray"/>
      </DataHeaderBand>
      <DataFooterBand Name="DataFooter1" Top="109.95" Width="718.2" Height="37.8">
        <TextObject Name="Text16" Left="472.5" Top="18.9" Width="94.5" Height="18.9" Text="[Total]" Format="Currency" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
        <TextObject Name="Text17" Left="396.9" Top="18.9" Width="75.6" Height="18.9" Text="Total:" HorzAlign="Right" VertAlign="Center" Font="Segoe UI, 9pt, style=Bold"/>
        <LineObject Name="Line1" Top="9.45" Width="567" Border.Color="DarkGray"/>
      </DataFooterBand>
    </DataBand>
  </ReportPage>
</Report>