<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer type="Flex" version="1.02" application="StiReport">
  <Dictionary type="Dictionary" Ref="1" isKey="true">
    <Databases isList="true" count="1">
      <Connection2 type="Stimulsoft.Report.Dictionary.StiMySqlDatabase" Ref="2" isKey="true">
        <Alias>Connection2</Alias>
        <ConnectionString>Server=localhost;database=exampledb;uid=root;pwd=;</ConnectionString>
        <Name>Connection2</Name>
        <PromptUserNameAndPassword>False</PromptUserNameAndPassword>
      </Connection2>
    </Databases>
    <DataSources isList="true" count="2">
      <swticketposts type="Stimulsoft.Report.Dictionary.StiMySqlSource" Ref="3" isKey="true">
        <Alias>swticketposts</Alias>
        <Columns isList="true" count="5">
          <value>ticketid,System.Int32</value>
          <value>ticketpostid,System.Int32</value>
          <value>fullname,System.String</value>
          <value>contents2,System.String</value>
          <value>datapost,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1"/>
        <Name>swticketposts</Name>
        <NameInSource>Connection2</NameInSource>
        <Parameters isList="true" count="0"/>
        <SqlCommand>select ticketid , ticketpostid, fullname, contents as contents2,
date_format(from_unixtime(dateline) , '%d-%m-%Y %H:%i:%s') as datapost from swticketposts where swticketposts.ticketid='10755' order by dateline ASC</SqlCommand>
      </swticketposts>
      <swtickets type="Stimulsoft.Report.Dictionary.StiMySqlSource" Ref="4" isKey="true">
        <Alias>swtickets</Alias>
        <Columns isList="true" count="50">
          <value>ticketid,System.Int32</value>
          <value>ticketmaskid,System.String</value>
          <value>departmentid,System.Int32</value>
          <value>ticketstatusid,System.Int32</value>
          <value>priorityid,System.Int32</value>
          <value>emailqueueid,System.Int32</value>
          <value>userid,System.Int32</value>
          <value>staffid,System.Int32</value>
          <value>ownerstaffid,System.Int32</value>
          <value>assignstatus,System.Int32</value>
          <value>fullname,System.String</value>
          <value>email,System.String</value>
          <value>lastreplier,System.String</value>
          <value>replyto,System.String</value>
          <value>subject,System.String</value>
          <value>dateline,System.Int32</value>
          <value>lastactivity,System.Int32</value>
          <value>laststaffreplytime,System.Int32</value>
          <value>slaplanid,System.Int32</value>
          <value>ticketslaplanid,System.Int32</value>
          <value>duetime,System.Int32</value>
          <value>totalreplies,System.Int32</value>
          <value>ipaddress,System.String</value>
          <value>flagtype,System.Int32</value>
          <value>hasnotes,System.Int32</value>
          <value>hasattachments,System.Int32</value>
          <value>isemailed,System.Int32</value>
          <value>edited,System.Int32</value>
          <value>editedbystaffid,System.Int32</value>
          <value>editeddateline,System.Int32</value>
          <value>creator,System.Int32</value>
          <value>charset,System.String</value>
          <value>transferencoding,System.String</value>
          <value>timeworked,System.Int32</value>
          <value>dateicon,System.Int32</value>
          <value>lastpostid,System.Int32</value>
          <value>firstpostid,System.Int32</value>
          <value>tgroupid,System.Int32</value>
          <value>messageid,System.String</value>
          <value>escalationruleid,System.Int32</value>
          <value>hasdraft,System.Int32</value>
          <value>hasbilling,System.Int32</value>
          <value>isphonecall,System.Int32</value>
          <value>isescalated,System.Int32</value>
          <value>phoneno,System.String</value>
          <value>autoclosetimeline,System.Int32</value>
          <value>islabeled,System.Int32</value>
          <value>lastuserreplytime,System.Int32</value>
          <value>escalatedtime,System.Int32</value>
          <value>followupcount,System.Int32</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1"/>
        <Name>swtickets</Name>
        <NameInSource>Connection2</NameInSource>
        <Parameters isList="true" count="1">
          <value>Para2,,254,10</value>
        </Parameters>
        <SqlCommand>select * from swtickets where swtickets.ticketid='10755'</SqlCommand>
      </swtickets>
    </DataSources>
    <Relations isList="true" count="1">
      <LISTA_POST type="DataRelation" Ref="5" isKey="true">
        <Alias>LISTA_POST</Alias>
        <ChildColumns isList="true" count="1">
          <value>ticketid</value>
        </ChildColumns>
        <ChildSource isRef="3"/>
        <Dictionary isRef="1"/>
        <Name>LISTA_POST</Name>
        <NameInSource>LISTA_POST</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>ticketid</value>
        </ParentColumns>
        <ParentSource isRef="4"/>
      </LISTA_POST>
    </Relations>
    <Report isRef="0"/>
    <Variables isList="true" count="0"/>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0"/>
  <MetaTags isList="true" count="0"/>
  <Pages isList="true" count="1">
    <Page1 type="Page" Ref="6" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="5">
        <PageHeaderBand1 type="PageHeaderBand" Ref="7" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19.98,0.25</ClientRectangle>
          <Components isList="true" count="0"/>
          <Conditions isList="true" count="0"/>
          <Name>PageHeaderBand1</Name>
          <Page isRef="6"/>
          <Parent isRef="6"/>
        </PageHeaderBand1>
        <Text17 type="Text" Ref="8" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>17.53,28.14,2.49,0.56</ClientRectangle>
          <Conditions isList="true" count="0"/>
          <Font>Arial,8</Font>
          <HorAlignment>Right</HorAlignment>
          <Margins>0,0,0,0</Margins>
          <Name>Text17</Name>
          <Page isRef="6"/>
          <Parent isRef="6"/>
          <Text>Pag {PageNumber} di {TotalPageCount}</Text>
          <TextBrush>Black</TextBrush>
        </Text17>
        <ReportTitleBand1 type="ReportTitleBand" Ref="9" isKey="true">
          <Border>All;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,1.45,19.98,18.44</ClientRectangle>
          <Components isList="true" count="1">
            <Panel1 type="Stimulsoft.Report.Components.StiPanel" Ref="10" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.2,0.15,19.6,17.8</ClientRectangle>
              <Components isList="true" count="1">
                <Text1 type="Text" Ref="11" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>9,8.6,1.6,0.6</ClientRectangle>
                  <Conditions isList="true" count="0"/>
                  <Font>Arial,10</Font>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text1</Name>
                  <Page isRef="6"/>
                  <Parent isRef="10"/>
                  <Text>TEST</Text>
                  <TextBrush>Black</TextBrush>
                </Text1>
              </Components>
              <Conditions isList="true" count="0"/>
              <Name>Panel1</Name>
              <Page isRef="6"/>
              <Parent isRef="9"/>
            </Panel1>
          </Components>
          <Conditions isList="true" count="0"/>
          <Name>ReportTitleBand1</Name>
          <Page isRef="6"/>
          <Parent isRef="6"/>
        </ReportTitleBand1>
        <DataBand1 type="DataBand" Ref="12" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,20.69,19.98,0.25</ClientRectangle>
          <Components isList="true" count="0"/>
          <Conditions isList="true" count="0"/>
          <DataSourceName>swtickets</DataSourceName>
          <Filters isList="true" count="0"/>
          <Name>DataBand1</Name>
          <Page isRef="6"/>
          <Parent isRef="6"/>
          <Sort isList="true" count="0"/>
        </DataBand1>
        <DataBand2 type="DataBand" Ref="13" isKey="true">
          <Border>All;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <CanBreak>True</CanBreak>
          <ClientRectangle>0,21.74,19.98,1.87</ClientRectangle>
          <Components isList="true" count="3">
            <Text15 type="Text" Ref="14" isKey="true">
              <AllowHtmlTags>True</AllowHtmlTags>
              <AutoWidth>True</AutoWidth>
              <Border>None;Black;1;None;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <CanBreak>True</CanBreak>
              <CanGrow>True</CanGrow>
              <CanShrink>True</CanShrink>
              <ClientRectangle>2.03,0.05,16.81,1.62</ClientRectangle>
              <Conditions isList="true" count="0"/>
              <Font>Calibri,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text15</Name>
              <Page isRef="6"/>
              <Parent isRef="13"/>
              <Text>{swticketposts.contents2}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
            </Text15>
            <Text14 type="Text" Ref="15" isKey="true">
              <Brush>Transparent</Brush>
              <CanBreak>True</CanBreak>
              <ClientRectangle>0,0.56,1.52,0.76</ClientRectangle>
              <Conditions isList="true" count="0"/>
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text14</Name>
              <Page isRef="6"/>
              <Parent isRef="13"/>
              <Text>{swticketposts.datapost}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
            </Text14>
            <Text16 type="Text" Ref="16" isKey="true">
              <Brush>Transparent</Brush>
              <CanBreak>True</CanBreak>
              <ClientRectangle>0,0,1.27,0.51</ClientRectangle>
              <Conditions isList="true" count="0"/>
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text16</Name>
              <Page isRef="6"/>
              <Parent isRef="13"/>
              <Text>{Line})</Text>
              <TextBrush>Black</TextBrush>
            </Text16>
          </Components>
          <Conditions isList="true" count="0"/>
          <DataRelationName>LISTA_POST</DataRelationName>
          <DataSourceName>swticketposts</DataSourceName>
          <Filters isList="true" count="0"/>
          <Name>DataBand2</Name>
          <Page isRef="6"/>
          <Parent isRef="6"/>
          <Sort isList="true" count="0"/>
        </DataBand2>
      </Components>
      <Conditions isList="true" count="0"/>
      <Guid>2bb7d110d1c25ededca1194e7d067917</Guid>
      <Margins>0.508,0.508,0.508,0.508</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0"/>
      <Watermark type="Stimulsoft.Report.Components.StiWatermark" Ref="17" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings type="Stimulsoft.Report.Print.StiPrinterSettings" Ref="18" isKey="true"/>
  <ReportAlias>Report</ReportAlias>
  <ReportChanged>04/03/2012 09:04:14 PM</ReportChanged>
  <ReportCreated>07/28/2010 08:01:30 PM</ReportCreated>
  <ReportFile>C:\Users\itfedlon\Desktop\Example_stimulsoft.mrt</ReportFile>
  <ReportGuid>ae371b6caf68890fc54b7997d286f198</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2012.1.1215</ReportVersion>
  <ScriptLanguage>VB</ScriptLanguage>
  <Styles isList="true" count="0"/>
</StiSerializer>