<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  <DataSources>
    <DataSource Name="samm_web">
      <rd:DataSourceID>27368cf2-831e-4b78-9d6e-8466a061582c</rd:DataSourceID>
      <DataSourceReference>samm_web</DataSourceReference>
    </DataSource>
  </DataSources>
  <InteractiveHeight>29.7cm</InteractiveHeight>
  <ReportParameters>
    <ReportParameter Name="req">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <DefaultValue>
        <Values>
          <Value>0</Value>
        </Values>
      </DefaultValue>
      <AllowBlank>true</AllowBlank>
      <Prompt>req</Prompt>
    </ReportParameter>
  </ReportParameters>
  <rd:DrawGrid>true</rd:DrawGrid>
  <InteractiveWidth>21cm</InteractiveWidth>
  <rd:GridSpacing>0.1cm</rd:GridSpacing>
  <rd:SnapToGrid>true</rd:SnapToGrid>
  <RightMargin>0.5cm</RightMargin>
  <LeftMargin>2cm</LeftMargin>
  <BottomMargin>0.5cm</BottomMargin>
  <rd:ReportID>247d0110-9088-4545-b98d-9712287e6553</rd:ReportID>
  <CodeModules>
    <CodeModule>System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</CodeModule>
  </CodeModules>
  <PageWidth>29.7cm</PageWidth>
  <DataSets>
    <DataSet Name="origen1">
      <Fields>
        <Field Name="catalogo">
          <DataField>catalogo</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="catalogo_codigo">
          <DataField>catalogo_codigo</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="tercero">
          <DataField>tercero</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="prefijo">
          <DataField>prefijo</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="documento_numero">
          <DataField>documento_numero</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="fecha_fh">
          <DataField>fecha_fh</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asunto">
          <DataField>asunto</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="solicitado">
          <DataField>solicitado</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="recibido">
          <DataField>recibido</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="estadoTipoDocumento">
          <DataField>estadoTipoDocumento</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>samm_web</DataSourceName>
        <CommandText />
      </Query>
    </DataSet>
    <DataSet Name="origen2">
      <Fields>
        <Field Name="tercero">
          <DataField>tercero</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="prefijo">
          <DataField>prefijo</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="documento_numero">
          <DataField>documento_numero</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="fecha_fh">
          <DataField>fecha_fh</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asunto">
          <DataField>asunto</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="estadoTipoDocumento">
          <DataField>estadoTipoDocumento</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>samm_web</DataSourceName>
        <CommandText />
      </Query>
    </DataSet>
  </DataSets>
  <Code> Public Shared Function opciones(ByVal p_str_opcion As String) As String
        Dim r As String = getReporteID()
        Dim t_ As String = System.Web.HttpContext.Current.Session("samm_opcionReporte_" &amp; r)
        If Not t_ Is Nothing Then
            If t_ = "" Then
            Else
                For Each t_str As String In t_.Split("|")
                    If p_str_opcion.ToString() = t_str.Split(".")(0) Then
                        Return t_str.Split(".")(1).ToString()
                    End If
                Next
            End If
        End If
        Return "-1"
    End Function

    Public Shared Function imagen(ByVal p As String) As String
        Return String.Concat("file:\\\\", System.Web.HttpContext.Current.Server.MapPath("~"), "\images\reportes\", p , ".jpg") 
    End Function

 Shared TextoCabecera As String = ""

    Public Shared Function tituloReporte() As String
       return System.Web.HttpContext.Current.Session("samm_tituloReporte")
    End Function

    Public Shared Function codigoReporte() As String
       return System.Web.HttpContext.Current.Session("samm_codigoReporte") 
    End Function
           
    Public Shared Function filtroReporte() As String
    return System.Web.HttpContext.Current.Session("samm_filtroReporte")
    End Function

      Public Shared Function agrupamiento() As String
            Dim t_ As String = System.Web.HttpContext.Current.Session("samm_agrupamiento")
            If t_ &lt;&gt; "" Then
                Return t_ &amp; ": "
            Else
                Return ""
            End If
        End Function

    Shared TextoOTCabecera As String = ""

    Public Shared Function getValorElemento(ByVal ReportItems As Object, ByVal item As String) As String
        If TextoOTCabecera = "" Then
            TextoOTCabecera = ReportItems(item).Value.ToString()
        End If
        Return TextoOTCabecera
    End Function

    public shared function getReporteID() as String
    Dim t_ As String = Web.HttpContext.Current.Request.QueryString("r")
    return t_
    End Function</Code>
  <Width>18.30001cm</Width>
  <Body>
    <ColumnSpacing>1cm</ColumnSpacing>
    <ReportItems>
      <Table Name="table2">
        <DataSetName>origen1</DataSetName>
        <Filters>
          <Filter>
            <FilterExpression>=Fields!prefijo.Value &amp; " - " &amp; Fields!documento_numero.Value</FilterExpression>
            <Operator>Equal</Operator>
            <FilterValues>
              <FilterValue>=Parameters!req.Value</FilterValue>
            </FilterValues>
          </Filter>
        </Filters>
        <Details>
          <TableRows>
            <TableRow>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox3">
                      <rd:DefaultName>textbox3</rd:DefaultName>
                      <Style>
                        <BorderColor>
                          <Right>Black</Right>
                        </BorderColor>
                        <BorderStyle>
                          <Default>Solid</Default>
                          <Right>Solid</Right>
                        </BorderStyle>
                        <BorderWidth>
                          <Default>0.5pt</Default>
                          <Right>0.5pt</Right>
                        </BorderWidth>
                        <FontSize>8pt</FontSize>
                        <TextAlign>Left</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                      <ZIndex>4</ZIndex>
                      <CanGrow>true</CanGrow>
                      <Value>=Fields!catalogo_codigo.Value</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox4">
                      <Style>
                        <BorderColor>
                          <Right>Black</Right>
                        </BorderColor>
                        <BorderStyle>
                          <Default>Solid</Default>
                          <Right>Solid</Right>
                        </BorderStyle>
                        <BorderWidth>
                          <Default>0.5pt</Default>
                          <Right>0.5pt</Right>
                        </BorderWidth>
                        <FontSize>8pt</FontSize>
                        <TextAlign>Left</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                      <ZIndex>3</ZIndex>
                      <CanGrow>true</CanGrow>
                      <Value>=Fields!catalogo.Value</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox10">
                      <rd:DefaultName>textbox10</rd:DefaultName>
                      <Style>
                        <BorderColor>
                          <Right>Black</Right>
                        </BorderColor>
                        <BorderStyle>
                          <Default>Solid</Default>
                          <Right>Solid</Right>
                        </BorderStyle>
                        <BorderWidth>
                          <Default>0.5pt</Default>
                          <Right>0.5pt</Right>
                        </BorderWidth>
                        <FontSize>8pt</FontSize>
                        <TextAlign>Left</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                      <ZIndex>2</ZIndex>
                      <CanGrow>true</CanGrow>
                      <Value>=Fields!solicitado.Value</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox5">
                      <Style>
                        <BorderColor>
                          <Right>Black</Right>
                        </BorderColor>
                        <BorderStyle>
                          <Default>Solid</Default>
                          <Right>Solid</Right>
                        </BorderStyle>
                        <BorderWidth>
                          <Default>0.5pt</Default>
                          <Right>0.5pt</Right>
                        </BorderWidth>
                        <FontSize>8pt</FontSize>
                        <TextAlign>Left</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                      <ZIndex>1</ZIndex>
                      <CanGrow>true</CanGrow>
                      <Value>=Fields!recibido.Value</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox8">
                      <rd:DefaultName>textbox8</rd:DefaultName>
                      <Style>
                        <BorderStyle>
                          <Default>Solid</Default>
                        </BorderStyle>
                        <BorderWidth>
                          <Default>0.5pt</Default>
                        </BorderWidth>
                        <FontSize>8pt</FontSize>
                        <TextAlign>Right</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                      <CanGrow>true</CanGrow>
                      <Value>=Fields!solicitado.Value-Fields!recibido.Value</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
              <Height>0.5cm</Height>
            </TableRow>
          </TableRows>
        </Details>
        <Style>
          <BorderStyle>
            <Bottom>Solid</Bottom>
          </BorderStyle>
          <BorderWidth>
            <Bottom>0.5pt</Bottom>
          </BorderWidth>
        </Style>
        <Header>
          <TableRows>
            <TableRow>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox13">
                      <Style>
                        <Color>White</Color>
                        <BackgroundColor>MidnightBlue</BackgroundColor>
                        <BorderColor>
                          <Bottom>Black</Bottom>
                        </BorderColor>
                        <BorderStyle>
                          <Top>Solid</Top>
                          <Bottom>Solid</Bottom>
                        </BorderStyle>
                        <BorderWidth>
                          <Default>0.3pt</Default>
                          <Bottom>1pt</Bottom>
                        </BorderWidth>
                        <FontSize>8pt</FontSize>
                        <FontWeight>700</FontWeight>
                        <TextAlign>Center</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                      <ZIndex>9</ZIndex>
                      <CanGrow>true</CanGrow>
                      <Value>Referencia</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox14">
                      <Style>
                        <Color>White</Color>
                        <BackgroundColor>MidnightBlue</BackgroundColor>
                        <BorderColor>
                          <Bottom>Black</Bottom>
                        </BorderColor>
                        <BorderStyle>
                          <Top>Solid</Top>
                          <Bottom>Solid</Bottom>
                        </BorderStyle>
                        <BorderWidth>
                          <Default>0.3pt</Default>
                          <Bottom>1pt</Bottom>
                        </BorderWidth>
                        <FontSize>8pt</FontSize>
                        <FontWeight>700</FontWeight>
                        <TextAlign>Center</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                      <ZIndex>8</ZIndex>
                      <CanGrow>true</CanGrow>
                      <Value>Desripcion</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox12">
                      <Style>
                        <Color>White</Color>
                        <BackgroundColor>MidnightBlue</BackgroundColor>
                        <BorderColor>
                          <Bottom>Black</Bottom>
                        </BorderColor>
                        <BorderStyle>
                          <Top>Solid</Top>
                          <Bottom>Solid</Bottom>
                        </BorderStyle>
                        <BorderWidth>
                          <Default>0.3pt</Default>
                          <Bottom>1pt</Bottom>
                        </BorderWidth>
                        <FontSize>8pt</FontSize>
                        <FontWeight>700</FontWeight>
                        <TextAlign>Center</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                      <ZIndex>7</ZIndex>
                      <CanGrow>true</CanGrow>
                      <Value>Solicitado</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox15">
                      <Style>
                        <Color>White</Color>
                        <BackgroundColor>MidnightBlue</BackgroundColor>
                        <BorderColor>
                          <Bottom>Black</Bottom>
                        </BorderColor>
                        <BorderStyle>
                          <Top>Solid</Top>
                          <Bottom>Solid</Bottom>
                        </BorderStyle>
                        <BorderWidth>
                          <Default>0.3pt</Default>
                          <Bottom>1pt</Bottom>
                        </BorderWidth>
                        <FontSize>8pt</FontSize>
                        <FontWeight>700</FontWeight>
                        <TextAlign>Center</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                      <ZIndex>6</ZIndex>
                      <CanGrow>true</CanGrow>
                      <Value>Recibido</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="textbox18">
                      <Style>
                        <Color>White</Color>
                        <BackgroundColor>MidnightBlue</BackgroundColor>
                        <BorderColor>
                          <Bottom>Black</Bottom>
                        </BorderColor>
                        <BorderStyle>
                          <Top>Solid</Top>
                          <Bottom>Solid</Bottom>
                        </BorderStyle>
                        <BorderWidth>
                          <Default>0.3pt</Default>
                          <Bottom>1pt</Bottom>
                        </BorderWidth>
                        <FontSize>8pt</FontSize>
                        <FontWeight>700</FontWeight>
                        <TextAlign>Center</TextAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                      <ZIndex>5</ZIndex>
                      <CanGrow>true</CanGrow>
                      <Value>Pendiente</Value>
                    </Textbox>
                  </ReportItems>
                </TableCell>
              </TableCells>
              <Height>0.5cm</Height>
            </TableRow>
          </TableRows>
        </Header>
        <TableColumns>
          <TableColumn>
            <Width>3cm</Width>
          </TableColumn>
          <TableColumn>
            <Width>7.8cm</Width>
          </TableColumn>
          <TableColumn>
            <Width>2.5cm</Width>
          </TableColumn>
          <TableColumn>
            <Width>2.5cm</Width>
          </TableColumn>
          <TableColumn>
            <Width>2.5cm</Width>
          </TableColumn>
        </TableColumns>
      </Table>
    </ReportItems>
    <Height>1cm</Height>
  </Body>
  <Language>es-CO</Language>
  <PageHeight>21cm</PageHeight>
</Report>