﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="1">
      <MySQL Ref="2" type="Stimulsoft.Report.Dictionary.StiMySqlDatabase" isKey="true">
        <Alias>MySQL</Alias>
        <ConnectionStringEncrypted>41z3a8ZXMelsE9XAYpykP4twm6jGS6OkyxX9+Gc9pHveIGmvTUrz8eJf+czDBHd71HD1iUhU+w==</ConnectionStringEncrypted>
        <Name>MySQL</Name>
      </MySQL>
    </Databases>
    <DataSources isList="true" count="2">
      <order_details Ref="3" type="Stimulsoft.Report.Dictionary.StiMySqlSource" isKey="true">
        <Alias>order_details</Alias>
        <Columns isList="true" count="10">
          <value>id,System.Int32</value>
          <value>order_id,System.Int32</value>
          <value>product_id,System.Int32</value>
          <value>quantity,System.Decimal</value>
          <value>unit_price,System.Decimal</value>
          <value>discount,System.Double</value>
          <value>status_id,System.Int32</value>
          <value>date_allocated,System.DateTime</value>
          <value>purchase_order_id,System.Int32</value>
          <value>inventory_id,System.Int32</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>order_details</Name>
        <NameInSource>MySQL</NameInSource>
        <Parameters isList="true" count="1">
          <value>_x0040_param1,,3,0</value>
        </Parameters>
        <ReconnectOnEachRow>True</ReconnectOnEachRow>
        <SqlCommand>select * from order_details where order_id = @param1</SqlCommand>
      </order_details>
      <orders Ref="4" type="Stimulsoft.Report.Dictionary.StiMySqlSource" isKey="true">
        <Alias>orders</Alias>
        <Columns isList="true" count="20">
          <value>id,System.Int32</value>
          <value>employee_id,System.Int32</value>
          <value>customer_id,System.Int32</value>
          <value>order_date,System.DateTime</value>
          <value>shipped_date,System.DateTime</value>
          <value>shipper_id,System.Int32</value>
          <value>ship_name,System.String</value>
          <value>ship_address,System.String</value>
          <value>ship_city,System.String</value>
          <value>ship_state_province,System.String</value>
          <value>ship_zip_postal_code,System.String</value>
          <value>ship_country_region,System.String</value>
          <value>shipping_fee,System.Decimal</value>
          <value>taxes,System.Decimal</value>
          <value>payment_type,System.String</value>
          <value>paid_date,System.DateTime</value>
          <value>notes,System.String</value>
          <value>tax_rate,System.Double</value>
          <value>tax_status_id,System.SByte</value>
          <value>status_id,System.SByte</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>orders</Name>
        <NameInSource>MySQL</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from orders</SqlCommand>
      </orders>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>c5165e6da47a4b04a295ad644b842435</Key>
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="5" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <Dataorders Ref="6" type="DataBand" isKey="true">
          <Border>All;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.2,7.72,0.3</ClientRectangle>
          <Components isList="true" count="2">
            <Dataorders_id Ref="7" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,3.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Dataorders_id</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>{order_details.Parameters["@param1"].ParameterValue = orders.id}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Dataorders_id>
            <Dataorders_order_date Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>3.9,0,3.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Dataorders_order_date</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>{orders.order_date}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Dataorders_order_date>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>orders</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>Dataorders</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <PrintIfDetailEmpty>True</PrintIfDetailEmpty>
          <Sort isList="true" count="0" />
        </Dataorders>
        <Dataorder_details Ref="9" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.9,7.72,0.3</ClientRectangle>
          <Components isList="true" count="2">
            <Dataorder_details_id Ref="10" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>2.2,0,1.7,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Dataorder_details_id</Name>
              <Page isRef="5" />
              <Parent isRef="9" />
              <Text>{order_details.id}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Dataorder_details_id>
            <Dataorder_details_order_id Ref="11" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>3.9,0,3.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Dataorder_details_order_id</Name>
              <Page isRef="5" />
              <Parent isRef="9" />
              <Text>{order_details.order_id}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Dataorder_details_order_id>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>order_details</DataSourceName>
          <Filters isList="true" count="0" />
          <MasterComponent isRef="6" />
          <Name>Dataorder_details</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <Sort isList="true" count="0" />
        </Dataorder_details>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>3bd71fc8f9df4ef5b34aff9846a26a00</Guid>
      <Margins>0.39,0.39,0.39,0.39</Margins>
      <Name>Page1</Name>
      <PageHeight>11</PageHeight>
      <PageWidth>8.5</PageWidth>
      <PaperSize>Letter</PaperSize>
      <Report isRef="0" />
      <Watermark Ref="12" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="13" type="Stimulsoft.Report.Print.StiPrinterSettings" isKey="true" />
  <ReferencedAssemblies isList="true" count="8">
    <value>System.Dll</value>
    <value>System.Drawing.Dll</value>
    <value>System.Windows.Forms.Dll</value>
    <value>System.Data.Dll</value>
    <value>System.Xml.Dll</value>
    <value>Stimulsoft.Controls.Dll</value>
    <value>Stimulsoft.Base.Dll</value>
    <value>Stimulsoft.Report.Dll</value>
  </ReferencedAssemblies>
  <ReportAlias>Report</ReportAlias>
  <ReportChanged>12/8/2018 9:49:13 AM</ReportChanged>
  <ReportCreated>12/8/2018 9:24:05 AM</ReportCreated>
  <ReportGuid>56f01c72c0994f5e9594101e87293f4b</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2018.3.5.0</ReportVersion>
  <Script>using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.Dialogs;
using Stimulsoft.Report.Components;

namespace Reports
{
    public class Report : Stimulsoft.Report.StiReport
    {
        public Report()        {
            this.InitializeComponent();
        }

        #region StiReport Designer generated code - do not modify
		#endregion StiReport Designer generated code - do not modify
    }
}
</Script>
  <ScriptLanguage>CSharp</ScriptLanguage>
  <Styles isList="true" count="0" />
</StiSerializer>