﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.0" application="StiReport">
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <Databases isList="true" count="1">
      <javi Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>javi</Alias>
        <ConnectionString>Password=lectura;Persist Security Info=True;Data Source=192.100.100.66;Integrated Security=False;Initial Catalog=JorgeSL;User ID=lectura</ConnectionString>
        <Name>javi</Name>
        <PromptUserNameAndPassword>False</PromptUserNameAndPassword>
      </javi>
    </Databases>
    <DataSources isList="true" count="1">
      <od Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>od</Alias>
        <Columns isList="true" count="11">
          <value>EtqA_EmpID,System.Int32</value>
          <value>EtqA_SedID,System.Int32</value>
          <value>EtqA_ArtID,System.Int32</value>
          <value>EtqA_ArtDescripcion,System.String</value>
          <value>EtqA_PesoNeto,System.Decimal</value>
          <value>EtqA_FechaAlta,System.DateTime</value>
          <value>EtqA_ProcesoAltaID,System.Int32</value>
          <value>ArtI_GrupoProduccionID,System.Int32</value>
          <value>GrpPro_Nombre,System.String</value>
          <value>Agr_ID,System.Int32</value>
          <value>ArtD_Descripcion,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>od</Name>
        <NameInSource>javi</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>SELECT tbl_EtiquetasAlmacen.EtqA_EmpID, tbl_EtiquetasAlmacen.EtqA_SedID,
  tbl_EtiquetasAlmacen.EtqA_ArtID, tbl_EtiquetasAlmacen.EtqA_ArtDescripcion,
  tbl_EtiquetasAlmacen.EtqA_PesoNeto, tbl_EtiquetasAlmacen.EtqA_FechaAlta,
  tbl_EtiquetasAlmacen.EtqA_ProcesoAltaID,
  tbl_Articulos_Ind.ArtI_GrupoProduccionID, tbl_GruposProduccion.GrpPro_Nombre,
  tbl_AgrupacionesTransporte.Agr_ID, tbl_Articulos_Des.ArtD_Descripcion
FROM tbl_EtiquetasAlmacen INNER JOIN
  tbl_Articulos_Ind ON tbl_Articulos_Ind.ArtI_ID =
    tbl_EtiquetasAlmacen.EtqA_ArtID INNER JOIN
  tbl_GruposProduccion ON tbl_Articulos_Ind.ArtI_GrupoProduccionID =
    tbl_GruposProduccion.GrpPro_ID INNER JOIN
  tbl_Familias ON tbl_Familias.Fam_ID = tbl_Articulos_Ind.ArtI_FamID INNER JOIN
  tbl_AgrupacionesTransporte ON tbl_AgrupacionesTransporte.Agr_ID =
    tbl_Familias.Fam_AgrID INNER JOIN
  tbl_Articulos_Des ON tbl_Articulos_Ind.ArtI_ID = tbl_Articulos_Des.ArtD_ID
WHERE tbl_EtiquetasAlmacen.EtqA_EmpID = 3 AND tbl_EtiquetasAlmacen.EtqA_SedID =
  8 AND tbl_EtiquetasAlmacen.EtqA_FechaAlta = '26/03/2009' AND
  tbl_EtiquetasAlmacen.EtqA_ProcesoAltaID = 20 AND
  tbl_AgrupacionesTransporte.Agr_ID = 1 AND tbl_Articulos_Des.ArtD_Idioma = 'SP'</SqlCommand>
      </od>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Pages isList="true" count="1">
    <Página1 Ref="4" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="8">
        <ReportTitle Ref="5" type="ReportTitleBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,0.6</ClientRectangle>
          <Components isList="true" count="1">
            <ReportTitleText Ref="6" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,19,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,20,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>ReportTitleText</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>Escandallo 26/03/2009 Vic</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </ReportTitleText>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>ReportTitle</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </ReportTitle>
        <Header Ref="7" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,1.8,19,0.4</ClientRectangle>
          <Components isList="true" count="2">
            <Text5 Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>9.8,0,2.4,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11</Font>
              <Guid>94d2c1f1f8ab43f7ba83fb50fb9b6fdb</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text5</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>Total General </Text>
              <TextBrush>[237:28:36]</TextBrush>
              <Type>Expression</Type>
            </Text5>
            <Text7 Ref="9" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>12.6,0,2.4,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11</Font>
              <Guid>006cf2ddf9154ed3ae1d6dccc842ae81</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text7</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>% sobre total</Text>
              <TextBrush>[237:28:36]</TextBrush>
              <Type>Expression</Type>
            </Text7>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>Header</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <PrintOnAllPages>False</PrintOnAllPages>
        </Header>
        <GroupHeader0 Ref="10" type="GroupHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,3,19,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Condition>{od.GrpPro_Nombre}</Condition>
          <Conditions isList="true" count="0" />
          <Name>GroupHeader0</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupHeader0>
        <EncabezadoGrupo1 Ref="11" type="GroupHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,3.8,19,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Condition>{od.ArtD_Descripcion}</Condition>
          <Conditions isList="true" count="0" />
          <Name>EncabezadoGrupo1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </EncabezadoGrupo1>
        <Datos1 Ref="12" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <CalcInvisible>True</CalcInvisible>
          <CanGrow>False</CanGrow>
          <ClientRectangle>0,4.6,19,0.6</ClientRectangle>
          <Components isList="true" count="1">
            <Text8 Ref="13" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>9.4,0,4,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text8</Name>
              <Page isRef="4" />
              <Parent isRef="12" />
              <Text>{od.EtqA_PesoNeto}</Text>
              <TextBrush>[237:28:36]</TextBrush>
              <TextFormat Ref="14" type="NumberFormat" isKey="true">
                <DecimalDigits>1</DecimalDigits>
                <GroupSeparator>,</GroupSeparator>
                <NegativePattern>1</NegativePattern>
                <UseLocalSetting>False</UseLocalSetting>
              </TextFormat>
            </Text8>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>od</DataSourceName>
          <Enabled>False</Enabled>
          <Filters isList="true" count="0" />
          <Name>Datos1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <SkipFirst>False</SkipFirst>
          <Sort isList="true" count="0" />
        </Datos1>
        <GroupFooter1 Ref="15" type="GroupFooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,6,19,0.4</ClientRectangle>
          <Components isList="true" count="5">
            <Text2 Ref="16" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>8.4,0,2,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>213a93db7b5d417e99e1807e17619adb</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="4" />
              <Parent isRef="15" />
              <Text>{Sum(od.EtqA_PesoNeto)}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="17" type="NumberFormat" isKey="true">
                <DecimalDigits>1</DecimalDigits>
                <DecimalSeparator>,</DecimalSeparator>
                <GroupSeparator>.</GroupSeparator>
                <NegativePattern>1</NegativePattern>
                <UseLocalSetting>False</UseLocalSetting>
              </TextFormat>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <Type>Totals</Type>
              <VertAlignment>Center</VertAlignment>
            </Text2>
            <DataText2 Ref="18" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>1.6,0,6.8,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataText2</Name>
              <Page isRef="4" />
              <Parent isRef="15" />
              <Text>{od.ArtD_Descripcion}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <Type>DataColumn</Type>
              <VertAlignment>Center</VertAlignment>
            </DataText2>
            <Text4 Ref="19" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>11.6,0,1.8,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold| Underline</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text4</Name>
              <Page isRef="4" />
              <Parent isRef="15" />
              <Text>{cSum(od.EtqA_PesoNeto)}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="20" type="NumberFormat" isKey="true">
                <DecimalDigits>0</DecimalDigits>
                <DecimalSeparator>,</DecimalSeparator>
                <GroupSeparator>.</GroupSeparator>
                <NegativePattern>1</NegativePattern>
                <UseLocalSetting>False</UseLocalSetting>
              </TextFormat>
              <Type>Expression</Type>
            </Text4>
            <DataText1 Ref="21" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0.2,0,1.2,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataText1</Name>
              <Page isRef="4" />
              <Parent isRef="15" />
              <Text>{od.EtqA_ArtID}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataText1>
            <Text6 Ref="22" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>13.6,0,2.2,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold| Underline</Font>
              <Guid>2d67ad925a294ba39e60393dc57628a3</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text6</Name>
              <Page isRef="4" />
              <Parent isRef="15" />
              <Text>{Sum(od.EtqA_PesoNeto)/cSum(od.EtqA_PesoNeto)}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="23" type="PercentageFormat" isKey="true">
                <GroupSeparator>,</GroupSeparator>
                <NegativePattern>0</NegativePattern>
                <PositivePattern>0</PositivePattern>
                <Symbol>%</Symbol>
              </TextFormat>
              <Type>Expression</Type>
            </Text6>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>GroupFooter1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupFooter1>
        <GroupFooter2 Ref="24" type="GroupFooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,7.2,19,0.4</ClientRectangle>
          <Components isList="true" count="2">
            <GroupHeaderText0 Ref="25" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>2.6,0,6.8,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>GroupHeaderText0</Name>
              <Page isRef="4" />
              <Parent isRef="24" />
              <Text>{"total "+ToLowerCase(od.GrpPro_Nombre)}</Text>
              <TextBrush>[23:54:93]</TextBrush>
              <TextQuality>Wysiwyg</TextQuality>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </GroupHeaderText0>
            <Text1 Ref="26" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>9.4,0,2,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>68a8fb20a77c4c918fc633d9bd32c630</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="4" />
              <Parent isRef="24" />
              <Text>{Sum(od.EtqA_PesoNeto)}</Text>
              <TextBrush>[237:28:36]</TextBrush>
              <TextFormat Ref="27" type="NumberFormat" isKey="true">
                <DecimalDigits>1</DecimalDigits>
                <DecimalSeparator>,</DecimalSeparator>
                <GroupSeparator>.</GroupSeparator>
                <NegativePattern>1</NegativePattern>
                <UseLocalSetting>False</UseLocalSetting>
              </TextFormat>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text1>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>GroupFooter2</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupFooter2>
        <Footer Ref="28" type="FooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,8.4,19,1</ClientRectangle>
          <Components isList="true" count="2">
            <totalgeneral Ref="29" type="Text" isKey="true">
              <Alias>totalgeneral</Alias>
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>9,0.6,2,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11,Bold| Underline</Font>
              <Guid>b91539e2c46a44189858e1b55392797e</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>totalgeneral</Name>
              <Page isRef="4" />
              <Parent isRef="28" />
              <Text>{Sum(od.EtqA_PesoNeto)}</Text>
              <TextBrush>[237:28:36]</TextBrush>
              <TextFormat Ref="30" type="NumberFormat" isKey="true">
                <DecimalDigits>1</DecimalDigits>
                <DecimalSeparator>,</DecimalSeparator>
                <GroupSeparator>.</GroupSeparator>
                <NegativePattern>1</NegativePattern>
                <UseLocalSetting>False</UseLocalSetting>
              </TextFormat>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </totalgeneral>
            <Text3 Ref="31" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>5.2,0.6,3.4,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="4" />
              <Parent isRef="28" />
              <Text>Total General </Text>
              <TextBrush>[237:28:36]</TextBrush>
              <Type>Expression</Type>
            </Text3>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>Footer</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </Footer>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>77dffd2627244544aef6d37e0a27d250</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Página1</Name>
      <Page isRef="4" />
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="32" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Enabled>False</Enabled>
        <Font>Arial,100</Font>
        <ShowImageBehind>False</ShowImageBehind>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Página1>
  </Pages>
  <PrinterSettings Ref="33" 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>Informe</ReportAlias>
  <ReportChanged>4/3/2009 1:04:48 PM</ReportChanged>
  <ReportCreated>3/31/2009 11:57:19 AM</ReportCreated>
  <ReportGuid>e4f6a1a1aa024684866ffb85b6029e07</ReportGuid>
  <ReportName>Informe</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2009.1.349</ReportVersion>
  <Script>Imports System
Imports System.Drawing
Imports System.Windows.Forms
Imports System.Data
Imports Stimulsoft.Controls
Imports Stimulsoft.Base.Drawing
Imports Stimulsoft.Report
Imports Stimulsoft.Report.Dialogs
Imports Stimulsoft.Report.Components

Namespace Reports
    
    Public Class Informe
        Inherits Stimulsoft.Report.StiReport
        
        Public Sub New()
            MyBase.New
            Me.InitializeComponent
        End Sub
        #Region "StiReport Designer generated code - do not modify"#End Region 'StiReport Designer generated code - do not modify
    End Class
End Namespace
</Script>
  <ScriptLanguage>VB</ScriptLanguage>
  <Styles isList="true" count="0" />
</StiSerializer>