﻿<?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>5XiVSOdoWd1vS/Hc5yCkZ9Vg1YliTNK84l+cCGNMpPvfyLMrZlF7reEl1aj7GG3njTp/69ddo8jDRIT0Y0nki8JWaaHvXLr1bERl+E1sYo+LKMHCzlYx8UNJnIRhCGIX3sSbw0gDk+3tS8mEw2ytF95aZepJA3tgYlrV9GEAJS/VKNULxWhZhWwT1b3WHPYq1cRlSclMQ4FsW1zo5dhiE+94aaM=</ConnectionStringEncrypted>
        <Name>MySQL</Name>
      </MySQL>
    </Databases>
    <DataSources isList="true" count="2">
      <brands Ref="3" type="Stimulsoft.Report.Dictionary.StiMySqlSource" isKey="true">
        <Alias>brands</Alias>
        <Columns isList="true" count="3">
          <value>id,System.Int32</value>
          <value>name,System.String</value>
          <value>active,System.Int32</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>brands</Name>
        <NameInSource>MySQL</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from brands</SqlCommand>
      </brands>
      <medicine Ref="4" type="Stimulsoft.Report.Dictionary.StiMySqlSource" isKey="true">
        <Alias>medicine</Alias>
        <Columns isList="true" count="10">
          <value>id,System.Int32</value>
          <value>med_id,System.Int32</value>
          <value>med_type,System.String</value>
          <value>med_name,System.String</value>
          <value>med_catid,System.Int32</value>
          <value>med_agencyid,System.Int32</value>
          <value>availability,System.Int32</value>
          <value>med_adddate,System.DateTime</value>
          <value>med_mfgid,System.Int32</value>
          <value>med_vacc,System.Int32</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>medicine</Name>
        <NameInSource>MySQL</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from medicine</SqlCommand>
      </medicine>
    </DataSources>
    <Relations isList="true" count="1">
      <Name Ref="5" type="DataRelation" isKey="true">
        <Alias>Name</Alias>
        <ChildColumns isList="true" count="1">
          <value>id</value>
        </ChildColumns>
        <ChildSource isRef="3" />
        <Dictionary isRef="1" />
        <Name>Name</Name>
        <NameInSource>Relation</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>med_mfgid</value>
        </ParentColumns>
        <ParentSource isRef="4" />
      </Name>
    </Relations>
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="1">
      <value>,pid,pid,,System.Int32,_x0031_,False,False,False,False,,,True</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>59c0c7392b67452481d006dd2bfac5f0</Key>
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="6" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="3">
        <Headerbrands Ref="7" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="1">
            <Headerbrands_name Ref="8" type="Text" isKey="true">
              <Brush>[217:150:148]</Brush>
              <ClientRectangle>0,0,7.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Headerbrands_name</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Text>Brand Name</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Headerbrands_name>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>Headerbrands</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
        </Headerbrands>
        <Databrands Ref="9" type="DataBand" isKey="true">
          <BeforePrintEvent>Databrands.NewPageAfter = (Line % 10 == 0);</BeforePrintEvent>
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,2,19,0.8</ClientRectangle>
          <Components isList="true" count="2">
            <Databrands_name Ref="10" type="Text" isKey="true">
              <Brush>[198:217:240]</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>2.2,0,5.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Databrands_name</Name>
              <Page isRef="6" />
              <Parent isRef="9" />
              <Text>{brands.name}</Text>
              <TextBrush>[217:150:148]</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Databrands_name>
            <Text1 Ref="11" type="Text" isKey="true">
              <Border>None;[141:179:226];1;Solid;False;4;Black</Border>
              <Brush>[198:217:240]</Brush>
              <ClientRectangle>0,0,2.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="6" />
              <Parent isRef="9" />
              <Text>{Line}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text1>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>brands</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>Databrands</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
          <Sort isList="true" count="0" />
        </Databrands>
        <FooterBand1 Ref="12" type="FooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,3.6,19,1.6</ClientRectangle>
          <Components isList="true" count="1">
            <Text2 Ref="13" type="Text" isKey="true">
              <Brush>[198:217:240]</Brush>
              <ClientRectangle>13.4,0.2,4.8,1.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="6" />
              <Parent isRef="12" />
              <Text>{IIF(IsLastPage,"LastPage","Continue")}</Text>
              <TextBrush>[217:150:148]</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text2>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>FooterBand1</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
          <PrintOnAllPages>True</PrintOnAllPages>
        </FooterBand1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>eb306589e60f489693385ec31504af12</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <PaperSize>A4</PaperSize>
      <Report isRef="0" />
    </Page1>
  </Pages>
  <PrinterSettings Ref="14" 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>1/9/2019 6:29:36 PM</ReportChanged>
  <ReportCreated>1/8/2019 6:33:35 PM</ReportCreated>
  <ReportFile>C:\wamp64\www\Ayushph\Stimulsoft\reports\Purchase\Brand.mrt</ReportFile>
  <ReportGuid>2871c6296c8246759542bdac70be88cd</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2019.1.1.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>