<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.0" type="Flex" application="StiReport">
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <Databases count="1" isList="true">
      <mySQL Ref="2" type="Stimulsoft.Report.Dictionary.StiMySqlDatabase" isKey="true">
        <Alias>mySQL</Alias>
        <ConnectionString>Driver={MySQL ODBC 3.51 Driver};Server=localhost;Port=33307;Database=crm;User=gallery; Password=gall;</ConnectionString>
        <Name>mySQL</Name>
        <PromptUserNameAndPassword>True</PromptUserNameAndPassword>
      </mySQL>
    </Databases>
    <DataSources count="1" isList="true">
      <Visits Ref="3" type="Stimulsoft.Report.Dictionary.StiMySqlSource" isKey="true">
        <Alias>Visits</Alias>
        <Columns count="11" isList="true">
          <value>VisitID,System.Int32</value>
          <value>UserID,System.Int32</value>
          <value>CompanyID,System.Int32</value>
          <value>PersonID,System.Int32</value>
          <value>BranchCode,System.Int32</value>
          <value>DateOfVisit,System.DateTime</value>
          <value>TimeIn,System.DateTime</value>
          <value>TimeOut,System.DateTime</value>
          <value>Activity,System.String</value>
          <value>Remarks,System.String</value>
          <value>NextActionDate,System.DateTime</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1"/>
        <Name>Visits</Name>
        <NameInSource>mySQL</NameInSource>
        <Parameters count="2" isList="true">
          <value>DateBegin,FromDate,12,0</value>
          <value>DateEnd,ToDate,12,0</value>
        </Parameters>
        <SqlCommand>Select * from visit_master</SqlCommand>
      </Visits>
    </DataSources>
    <Relations count="0" isList="true"/>
    <Report isRef="0"/>
    <Variables count="2" isList="true">
      <value>,FromDate,FromDate,System.DateTime,_x0031__x002F_1_x002F_1970_x0020_0_x003A_00_x003A_00_x0020_AM,False,False</value>
      <value>,ToDate,ToDate,System.Nullable`1[System.DateTime],_x0031__x002F_1_x002F_1970_x0020_0_x003A_00_x003A_00_x0020_AM,False,False</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <MetaTags count="0" isList="true"/>
  <Pages count="1" isList="true">
    <Page1 Ref="4" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black;False</Border>
      <Brush>Transparent</Brush>
      <Components count="4" isList="true">
        <ReportTitleBand1 Ref="5" type="ReportTitleBand" isKey="true">
          <Brush>[218:231:241]</Brush>
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components count="2" isList="true">
            <Text36 Ref="6" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>2.4,0.2,1.6,0.6</ClientRectangle>
              <Conditions count="0" isList="true"/>
              <Font>Arial,10</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text36</Name>
              <Page isRef="4"/>
              <Parent isRef="5"/>
              <Text>{FromDate}</Text>
              <TextBrush>Black</TextBrush>
            </Text36>
            <Text37 Ref="7" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.8,0.2,1.6,0.6</ClientRectangle>
              <Conditions count="0" isList="true"/>
              <Font>Arial,10</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text37</Name>
              <Page isRef="4"/>
              <Parent isRef="5"/>
              <Text>{ToDate}</Text>
              <TextBrush>Black</TextBrush>
            </Text37>
          </Components>
          <Conditions count="0" isList="true"/>
          <Name>ReportTitleBand1</Name>
          <Page isRef="4"/>
          <Parent isRef="4"/>
        </ReportTitleBand1>
        <HeaderBand3 Ref="8" type="HeaderBand" isKey="true">
          <Border>All;Black;1;Solid;False;4;Black;False</Border>
          <Brush>[245:222:179]</Brush>
          <ClientRectangle>0,2,19,0.6</ClientRectangle>
          <Components count="5" isList="true">
            <Text26 Ref="9" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>5,0,2.8,0.6</ClientRectangle>
              <Conditions count="0" isList="true"/>
              <Font>Arial,10,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text26</Name>
              <Page isRef="4"/>
              <Parent isRef="8"/>
              <Text>Time In</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text26>
            <Text28 Ref="10" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>8.6,0,2.8,0.6</ClientRectangle>
              <Conditions count="0" isList="true"/>
              <Font>Arial,10,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text28</Name>
              <Page isRef="4"/>
              <Parent isRef="8"/>
              <Text>Time Out</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text28>
            <Text32 Ref="11" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>12,0,2.8,0.6</ClientRectangle>
              <Conditions count="0" isList="true"/>
              <Font>Arial,10,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text32</Name>
              <Page isRef="4"/>
              <Parent isRef="8"/>
              <Text>Activity</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text32>
            <Text34 Ref="12" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>15,0,1.6,0.6</ClientRectangle>
              <Conditions count="0" isList="true"/>
              <Font>Arial,10,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text34</Name>
              <Page isRef="4"/>
              <Parent isRef="8"/>
              <Text>Remarks</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text34>
            <Text39 Ref="13" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>1.6,0,1.6,0.6</ClientRectangle>
              <Conditions count="0" isList="true"/>
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text39</Name>
              <Page isRef="4"/>
              <Parent isRef="8"/>
              <Text>DateOfVisit</Text>
              <TextBrush>Black</TextBrush>
            </Text39>
          </Components>
          <Conditions count="0" isList="true"/>
          <Name>HeaderBand3</Name>
          <Page isRef="4"/>
          <Parent isRef="4"/>
        </HeaderBand3>
        <DataBand4 Ref="14" type="DataBand" isKey="true">
          <Border>All;Black;1;Solid;False;4;Black;False</Border>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,3.4,19,0.6</ClientRectangle>
          <Components count="5" isList="true">
            <Text25 Ref="15" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>5.6,0,1.6,0.6</ClientRectangle>
              <Conditions count="0" isList="true"/>
              <Font>Arial,10</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text25</Name>
              <Page isRef="4"/>
              <Parent isRef="14"/>
              <Text>{Visits.TimeIn}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text25>
            <Text27 Ref="16" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>9.2,0,1.6,0.6</ClientRectangle>
              <Conditions count="0" isList="true"/>
              <Font>Arial,10</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text27</Name>
              <Page isRef="4"/>
              <Parent isRef="14"/>
              <Text>{Visits.TimeOut}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text27>
            <Text31 Ref="17" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>12.6,0,1.6,0.6</ClientRectangle>
              <Conditions count="0" isList="true"/>
              <Font>Arial,10</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text31</Name>
              <Page isRef="4"/>
              <Parent isRef="14"/>
              <Text>{Visits.Activity}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text31>
            <Text33 Ref="18" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>14.8,0,1.6,0.6</ClientRectangle>
              <Conditions count="0" isList="true"/>
              <Font>Arial,10</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text33</Name>
              <Page isRef="4"/>
              <Parent isRef="14"/>
              <Text>{Visits.Remarks}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text33>
            <Text38 Ref="19" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>1.6,0,1.6,0.6</ClientRectangle>
              <Conditions count="0" isList="true"/>
              <Font>Arial,10</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text38</Name>
              <Page isRef="4"/>
              <Parent isRef="14"/>
              <Text>{Visits.DateOfVisit}</Text>
              <TextBrush>Black</TextBrush>
            </Text38>
          </Components>
          <Conditions count="0" isList="true"/>
          <DataSourceName>Visits</DataSourceName>
          <Filters count="0" isList="true"/>
          <Name>DataBand4</Name>
          <Page isRef="4"/>
          <Parent isRef="4"/>
          <Sort count="0" isList="true"/>
        </DataBand4>
        <FooterBand3 Ref="20" type="FooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,4.8,19,0.2</ClientRectangle>
          <Components count="0" isList="true"/>
          <Conditions count="0" isList="true"/>
          <Name>FooterBand3</Name>
          <Page isRef="4"/>
          <Parent isRef="4"/>
        </FooterBand3>
      </Components>
      <Conditions count="0" isList="true"/>
      <Guid>2aeae2f07329213b05b4fd56bec7459f</Guid>
      <Margins>1,1,0.5,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0"/>
      <Watermark Ref="21" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="22" type="Stimulsoft.Report.Print.StiPrinterSettings" isKey="true"/>
  <ReportAlias>Report</ReportAlias>
  <ReportChanged>5/18/2011 7:17:40 PM</ReportChanged>
  <ReportCreated>5/17/2011 3:13:31 PM</ReportCreated>
  <ReportFile>Report.mrt</ReportFile>
  <ReportGuid>067dc186d880111116d2035ca1830d65</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2011.1.1000</ReportVersion>
  <ScriptLanguage>CSharp</ScriptLanguage>
  <Styles count="0" isList="true"/>
</StiSerializer>