﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <CalculationMode>Interpretation</CalculationMode>
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="1">
      <vConnection Ref="2" type="Stimulsoft.Report.Dictionary.StiOracleDatabase" isKey="true">
        <Alias>vConnection</Alias>
        <ConnectionStringEncrypted>5ciziE13Q0V7EynMctxqr+PiQ89GCkoV8XxNGHHYZWbA0EFMYRCSCX98oe1yBKCT7zBDiNZbQnH8TiGF+m3zl+A6UwNZeTFp/Gt56frcoOONOP9rWGr6TflnTZhNEOi/4x6t72EFmexyWKkEw1xqbtk6i4BVA/IFfBWoGPHErK/jLGmgX30xRfFMzATr</ConnectionStringEncrypted>
        <Name>vConnection</Name>
      </vConnection>
    </Databases>
    <DataSources isList="true" count="4">
      <dsReportInformation Ref="3" type="Stimulsoft.Report.Dictionary.StiOracleSource" isKey="true">
        <Alias>dsReportInformation</Alias>
        <Columns isList="true" count="2">
          <value>report_title,System.String</value>
          <value>report_logo,System.Byte[]</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>dsReportInformation</Name>
        <NameInSource>vConnection</NameInSource>
        <Parameters isList="true" count="3">
          <value>p_lan_code,p_lan_code,126,0</value>
          <value>p_program_code,ReportName,126,0</value>
          <value>p_option_code,p_option_code,126,0</value>
        </Parameters>
        <SqlCommand>SELECT UPPER(report_title) report_title
      ,report_logo
FROM   (WITH query_parameter
        AS   (SELECT :p_lan_code      p_lan_code
                    ,:p_program_code  p_program_code
                    ,:p_option_code   p_option_code
              FROM   dual
             )
        SELECT ips.adm_res_capi.get_resource_language
                      (pro_res_code_titre
                      ,UPPER(p_lan_code)
                      )                             AS report_title
              ,(SELECT img_image
                FROM   ips.ips_image
                WHERE  img_code = 'LOGO_REPORT'
               )                                    AS report_logo
        FROM   ips.adm_programme
          INNER JOIN ips.adm_programme_option ON pro_prg_code = prg_code
          CROSS JOIN query_parameter
        WHERE  UPPER(prg_code)        = UPPER(p_program_code)
        AND    UPPER(pro_code_option) = UPPER(p_option_code)
       )</SqlCommand>
      </dsReportInformation>
      <dsOnStartup Ref="4" type="Stimulsoft.Report.Dictionary.StiOracleSource" isKey="true">
        <Alias>dsOnStartup</Alias>
        <Columns isList="true" count="0" />
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>dsOnStartup</Name>
        <NameInSource>vConnection</NameInSource>
        <Parameters isList="true" count="1">
          <value>p_lan_code,p_lan_code,126,0</value>
        </Parameters>
        <SqlCommand>ips.adf_stimulsoft_api.on_startup</SqlCommand>
        <Type>StoredProcedure</Type>
      </dsOnStartup>
      <dsInventaire Ref="5" type="Stimulsoft.Report.Dictionary.StiOracleSource" isKey="true">
        <Alias>dsInventaire</Alias>
        <Columns isList="true" count="16">
          <value>pet_noseq,System.String</value>
          <value>job_code,System.String</value>
          <value>job_nom,System.String</value>
          <value>type_produit,System.String</value>
          <value>quantite_total,System.Decimal</value>
          <value>quantite_consomme,System.Decimal</value>
          <value>quantite_discard,System.Decimal</value>
          <value>quantite_projete,System.Decimal</value>
          <value>quantite_balance,quantite_balance,System.Nullable`1[System.Decimal],dsInventaire.quantite_total_x0020_-_x0020_dsInventaire.quantite_consomme_x0020_-_x0020_dsInventaire.quantite_discard</value>
          <value>quantite_variance,quantite_variance,System.Nullable`1[System.Decimal],dsInventaire.quantite_consomme_x0020_-_x0020_dsInventaire.quantite_projete</value>
          <value>usn_code,System.String</value>
          <value>display_unit,System.String</value>
          <value>calc_total_quantite_utilise,calc_total_quantite_utilise,System.Decimal,Sum_x0028_dbaDetailCalcul_x002C_dsInventaireDetail.quantite_utilise_x0029_</value>
          <value>calc_total_quantite_discard,calc_total_quantite_discard,System.Decimal,Sum_x0028_dbaDetailCalcul_x002C_dsInventaireDetail.quantite_discard_x0029_</value>
          <value>calc_total_quantite_projete,calc_total_quantite_projete,System.Decimal,Sum_x0028_dbaDetailCalcul_x002C_dsInventaireDetail.quantite_projete_x0029_</value>
          <value>calc_total_quantite_variance,calc_total_quantite_variance,System.Decimal,Sum_x0028_dbaDetailCalcul_x002C_dsInventaireDetail.quantite_variance_x0029_</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>dsInventaire</Name>
        <NameInSource>vConnection</NameInSource>
        <Parameters isList="true" count="4">
          <value>p_unit,p_measurement_unit,119,0</value>
          <value>p_pet_noseq,p_pet_noseq,119,0</value>
          <value>p_usn_code,p_usn_code,126,0</value>
          <value>p_lan_code,p_lan_code,126,0</value>
        </Parameters>
        <SqlCommand>SELECT pet_noseq
      ,job_code
      ,job_nom
      ,usn_code
      ,type_produit
      ,display_unit
      ,quantite_total_part1 + quantite_total_part2                              quantite_total
      ,quantite_consomme
      ,quantite_discard
      ,quantite_projete
FROM   (WITH query_parameter
        AS   (SELECT :p_unit      p_unit
                    ,:p_pet_noseq p_pet_noseq
                    ,:p_usn_code  p_usn_code
                    ,:p_lan_code  p_lan_code
              FROM   dual
             )
        SELECT pet_noseq
              ,job_code
              ,job_nom
              ,type_produit
              ,usn_code
              ,ips.adm_gre_capi.get_description('peiCoatingDashboard-Unit', p_unit || type_produit, p_lan_code)     display_unit
              -- Produit encore dans le projet --
              ,(SELECT NVL(SUM(ips.rfr_umc_capi.convert
                                     (udm_code   -- p_code_from
                                     ,DECODE(type_produit, 'L', DECODE(p_unit, 'I', 'GA', 'L')
                                                              , DECODE(p_unit, 'I', 'LB', 'KG')
                                            )   -- p_code_to
                                     ,ivt_format -- p_value
                                     )
                              )
                          , 0
                          )
                FROM   ips.pei_inventaire
                  INNER JOIN ips.rfr_unite_mesure ON udm_code = ivt_udm_code
                WHERE  udm_format_peinture = type_produit
                AND    ivt_pet_noseq       = pet_noseq
                AND    NVL(ivt_ent_code, CHR(0))        = NVL(usn_code, CHR(0))
                AND    ivt_rpe_noseq IS NOT NULL
                AND    EXISTS (SELECT 'X'
                               FROM   ips.pei_produit_composante
                                 INNER JOIN ips.pei_produit ON pdt_noseq = pdc_pdt_noseq
                               WHERE  pdc_prd_noseq    = ivt_prd_noseq
                               AND    pdt_est_dilluant = 'N'
                              )
               ) quantite_total_part1     
              -- Le produit n'est plus dans le projet mais a une consommation dans le projet -- 
              ,(SELECT NVL(SUM(ips.rfr_umc_capi.convert
                                     (udm_code   -- p_code_from
                                     ,DECODE(type_produit, 'L', DECODE(p_unit, 'I', 'GA', 'L')
                                                              , DECODE(p_unit, 'I', 'LB', 'KG')
                                             )   -- p_code_to
                                     ,ico_quantite -- p_value
                                     )
                              )
                          , 0
                          )
                FROM   ips.pei_inventaire_consommation
                  LEFT  JOIN ips.pei_lot_production_couche ON lpc_noseq = ico_lpc_noseq
                  LEFT  JOIN ips.pei_lot_production        ON lpr_noseq = lpc_lpr_noseq
                  INNER JOIN ips.pei_inventaire            ON ivt_noseq = ico_ivt_noseq
                  INNER JOIN ips.rfr_unite_mesure          ON udm_code  = ivt_udm_code
                WHERE  ico_pet_noseq       = pet_noseq
                AND    udm_format_peinture = type_produit
                AND    COALESCE(lpr_usn_code, ivt_ent_code, CHR(0)) = NVL(usn_code, CHR(0))
                AND    ico_pet_noseq      != ivt_pet_noseq
                AND    EXISTS (SELECT 'X'
                               FROM   ips.pei_produit_composante
                                 INNER JOIN ips.pei_produit ON pdt_noseq = pdc_pdt_noseq
                               WHERE  pdc_prd_noseq    = ivt_prd_noseq
                               AND    pdt_est_dilluant = 'N'
                              )
               ) quantite_total_part2  
              ,(SELECT NVL(SUM(ips.rfr_umc_capi.convert
                                     (udm_code   -- p_code_from
                                     ,DECODE(type_produit, 'L', DECODE(p_unit, 'I', 'GA', 'L')
                                                              , DECODE(p_unit, 'I', 'LB', 'KG')
                                             )   -- p_code_to
                                     ,ico_quantite -- p_value
                                     )
                              )
                          , 0
                          )
                FROM   ips.pei_inventaire_consommation
                  LEFT  JOIN ips.pei_lot_production_couche ON lpc_noseq = ico_lpc_noseq
                  LEFT  JOIN ips.pei_lot_production        ON lpr_noseq = lpc_lpr_noseq
                  INNER JOIN ips.pei_inventaire            ON ivt_noseq = ico_ivt_noseq
                  INNER JOIN ips.rfr_unite_mesure          ON udm_code  = ivt_udm_code
                WHERE  ico_ivt_noseq       = ivt_noseq
                AND    ico_pet_noseq       = pet_noseq
                AND    ivt_udm_code        = udm_code
                AND    udm_format_peinture = type_produit
                AND    NVL(lpr_usn_code, CHR(0)) = NVL(usn_code, CHR(0))
                AND    ico_lpc_noseq IS NOT NULL
               ) quantite_consomme
              ,(SELECT NVL(SUM(ips.rfr_umc_capi.convert
                                     (udm_code   -- p_code_from
                                     ,DECODE(type_produit, 'L', DECODE(p_unit, 'I', 'GA', 'L')
                                                              , DECODE(p_unit, 'I', 'LB', 'KG')
                                             )     -- p_code_to
                                     ,ico_quantite -- p_value
                                     )
                              )
                          , 0
                          )
                FROM   ips.pei_inventaire_consommation
                  INNER JOIN ips.pei_inventaire   ON ivt_noseq = ico_ivt_noseq
                  INNER JOIN ips.rfr_unite_mesure ON udm_code  = ivt_udm_code
                WHERE  ico_pet_noseq       = pet_noseq
                AND    udm_format_peinture = type_produit
                AND    NVL(ivt_ent_code, CHR(0)) = NVL(usn_code, CHR(0))
                AND    ico_lpc_noseq IS NULL
                AND    EXISTS (SELECT 'X'
                               FROM   ips.pei_produit_composante
                                 INNER JOIN ips.pei_produit ON pdt_noseq = pdc_pdt_noseq
                               WHERE  pdc_prd_noseq    = ivt_prd_noseq
                               AND    pdt_est_dilluant = 'N'
                              )
               ) quantite_discard
              ,ips.pei_pet_capi.get_planned_quantity
                    (pet_noseq
                    ,p_unit
                    ,type_produit
                    ,usn_code
                    ) quantite_projete
        FROM   ips.pei_projet_v
          INNER JOIN (SELECT DISTINCT ivt_pet_noseq
                            ,ivt_ent_code                  usn_code
                      FROM   ips.pei_inventaire
                     ) ON   ivt_pet_noseq = pet_noseq
          CROSS JOIN query_parameter
          CROSS JOIN (SELECT 'L' type_produit
                      FROM   dual
                      UNION ALL
                      SELECT 'S'
                      FROM   dual
                     ) product_type
        WHERE  pet_noseq LIKE p_pet_noseq
        AND    job_code != '0000-000'
       )
WHERE  (  quantite_total_part1 
        + quantite_total_part2 
        + quantite_consomme 
        + quantite_discard 
        + quantite_projete
       ) &gt; 0 </SqlCommand>
      </dsInventaire>
      <dsInventaireDetail Ref="6" type="Stimulsoft.Report.Dictionary.StiOracleSource" isKey="true">
        <Alias>dsInventaireDetail</Alias>
        <Columns isList="true" count="13">
          <value>ico_pet_noseq,System.String</value>
          <value>type_produit,System.String</value>
          <value>ico_date,System.DateTime</value>
          <value>pdt_code,System.String</value>
          <value>prd_code,System.String</value>
          <value>lpr_code,System.String</value>
          <value>lpc_nom,System.String</value>
          <value>ico_note,System.String</value>
          <value>quantite_utilise,System.Decimal</value>
          <value>quantite_discard,System.Decimal</value>
          <value>quantite_projete,System.Decimal</value>
          <value>quantite_variance,quantite_variance,System.Nullable`1[System.Decimal],dsInventaireDetail.quantite_utilise_x0020_-_x0020_dsInventaireDetail.quantite_projete</value>
          <value>lpr_usn_code,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>dsInventaireDetail</Name>
        <NameInSource>vConnection</NameInSource>
        <Parameters isList="true" count="4">
          <value>p_unit,p_measurement_unit,119,0</value>
          <value>p_lpr_noseq,p_lpr_noseq,119,0</value>
          <value>p_date_debut,p_date_debut,106,0</value>
          <value>p_date_fin,p_date_fin,106,0</value>
        </Parameters>
        <SqlCommand>SELECT ico_pet_noseq
      ,lpr_usn_code
      ,type_produit
      ,ico_date
      ,pdt_code
      ,prd_code
      ,lpr_code
      ,lpc_nom
      ,ico_note
      ,quantite_utilise
      ,quantite_discard
      ,CASE WHEN (row_id = 1) THEN
         CASE WHEN (NVL(composante_quantite_total, 0) = 0) THEN
           0
         ELSE
           CAST((lot_quantite_projete / composante_quantite_total) * composante_quantite AS DECIMAL(20,7))
         END
       ELSE
         0
       END quantite_projete
FROM   (WITH query_parameter
        AS   (SELECT :p_unit                                                p_unit
                    ,:p_lpr_noseq                                           p_lpr_noseq
                    ,TRUNC(NVL(:p_date_debut, ips.adf_date_api.min_date))   p_date_debut
                    ,TRUNC(NVL(:p_date_fin, ips.adf_date_api.max_date))     p_date_fin
              FROM   dual
             )
        --
        -- Section pour les consommations avec un lot
        --        
        SELECT ico_pet_noseq
              ,ico_date
              ,lpr_usn_code
              ,pdt_code
              ,prd_code
              ,lpr_code
              ,lpc_nom
              ,ico_note
              ,CASE WHEN (ico_lpc_noseq IS NOT NULL) THEN
                 quantite_utilise
               ELSE
                 0
               END quantite_utilise
              ,CASE WHEN (ico_lpc_noseq IS NULL) THEN
                 quantite_utilise
               ELSE
                 0
               END quantite_discard
              ,CASE WHEN (pdc_quantite_solide_i IS NULL) THEN
                 DECODE(p_unit, 'I', pdc_quantite_liquide_i, pdc_quantite_liquide_m)
               ELSE
                 DECODE(p_unit, 'I', pdc_quantite_solide_i, pdc_quantite_solide_m)
               END composante_quantite 
              ,(SELECT SUM(DECODE(p_unit, 'I', t.pdc_quantite_liquide_i, t.pdc_quantite_liquide_m))
                FROM   ips.pei_produit_composante t
                WHERE  t.pdc_pdt_noseq = lpc_pdt_noseq
               ) composante_quantite_total
              ,CAST(ips.pei_lpc_capi.get_planned_quantity
                          (DECODE(p_unit, 'I', lpc_surface_couverte_i, lpc_surface_couverte_m)
                          ,DECODE(p_unit, 'I', lpr_surface_i         , lpr_surface_m)
                          ) AS DECIMAL(20,7)) lot_quantite_projete
              ,CASE WHEN (pdc_quantite_solide_i IS NULL) THEN
                 'L'
               ELSE
                 'S'
               END type_produit
              ,ROW_NUMBER() OVER(PARTITION BY lpc_noseq, prd_code ORDER BY lpc_noseq, prd_code)  AS row_id
        FROM   (SELECT ico_pet_noseq
                      ,ivt_prd_noseq
                      ,ico_lpc_noseq
                      ,TRUNC(ico_date)            ico_date
                      ,ico_note
                      ,NVL(SUM(CAST(ips.rfr_umc_capi.convert
                                          (udm_code    -- p_code_from
                                          ,DECODE(udm_format_peinture, 'L', DECODE(p_unit, 'I', 'GA', 'L')
                                                                          , DECODE(p_unit, 'I', 'LB', 'KG')
                                                 )     -- p_code_to
                                          ,ico_quantite -- p_value
                                          ) AS DECIMAL(20,7))
                              )
                          , 0
                          )  quantite_utilise
                FROM   ips.pei_inventaire_consommation
                  INNER JOIN ips.pei_inventaire   ON ivt_noseq = ico_ivt_noseq
                  INNER JOIN ips.rfr_unite_mesure ON udm_code  = ivt_udm_code
                  CROSS JOIN query_parameter
                WHERE  ico_lpc_noseq IS NOT NULL
                AND    TRUNC(ico_date) BETWEEN p_date_debut AND p_date_fin
                GROUP BY ico_pet_noseq
                        ,ivt_prd_noseq
                        ,ico_lpc_noseq
                        ,TRUNC(ico_date)
                        ,ico_note
               )
         INNER JOIN ips.pei_lot_production_couche ON lpc_noseq = ico_lpc_noseq
         INNER JOIN ips.pei_lot_production        ON lpr_noseq = lpc_lpr_noseq
         INNER JOIN ips.pei_produit               ON pdt_noseq = lpc_pdt_noseq
         INNER JOIN ips.rfr_produit               ON prd_noseq = ivt_prd_noseq
         INNER JOIN ips.pei_produit_composante    ON pdc_prd_noseq = prd_noseq
         CROSS JOIN query_parameter
        WHERE  pdt_noseq = pdc_pdt_noseq
        AND    NVL(lpc_lpr_noseq, '%') LIKE p_lpr_noseq
        UNION ALL
        --
        -- Section pour les discard
        --
        SELECT ico_pet_noseq
              ,ico_date
              ,ivt_ent_code
              ,NULL                 pdt_code
              ,prd_code
              ,NULL                 lpr_code
              ,NULL                 lpc_nom
              ,ico_note
              ,0                    quantite_utilise
              ,quantite_utilise     quantite_discard
              ,0                    composante_quantite 
              ,0                    composante_quantite_total
              ,0                    lot_quantite_projete
              ,udm_format_peinture  type_produit
              ,0                    row_id
        FROM   (SELECT ico_pet_noseq
                      ,ivt_ent_code
                      ,ivt_prd_noseq
                      ,ico_lpc_noseq
                      ,TRUNC(ico_date)           ico_date
                      ,ico_note
                      ,NVL(SUM(CAST(ips.rfr_umc_capi.convert
                                          (udm_code    -- p_code_from
                                          ,DECODE(udm_format_peinture, 'L', DECODE(p_unit, 'I', 'GA', 'L')
                                                                          , DECODE(p_unit, 'I', 'LB', 'KG')
                                                 )     -- p_code_to
                                          ,ico_quantite -- p_value
                                          ) AS DECIMAL(20,7))
                              )
                          , 0
                          )  quantite_utilise
                      ,ivt_udm_code
                      ,udm_format_peinture
                FROM   ips.pei_inventaire_consommation
                  INNER JOIN ips.pei_inventaire   ON ivt_noseq = ico_ivt_noseq
                  INNER JOIN ips.rfr_unite_mesure ON udm_code  = ivt_udm_code
                  CROSS JOIN query_parameter
                WHERE  p_lpr_noseq = '%'
                AND    TRUNC(ico_date) BETWEEN p_date_debut AND p_date_fin
                AND    ico_lpc_noseq IS NULL
                AND    EXISTS (SELECT 'X'
                               FROM   ips.pei_produit_composante
                                 INNER JOIN ips.pei_produit ON pdt_noseq = pdc_pdt_noseq
                               WHERE  pdc_prd_noseq    = ivt_prd_noseq
                               AND    pdt_est_dilluant = 'N'
                              )
                GROUP BY ico_pet_noseq
                        ,ivt_ent_code
                        ,ivt_prd_noseq
                        ,ico_lpc_noseq
                        ,TRUNC(ico_date)
                        ,ico_note
                        ,ivt_udm_code
                        ,udm_format_peinture
               )
          INNER JOIN ips.rfr_produit ON prd_noseq = ivt_prd_noseq 
       )</SqlCommand>
      </dsInventaireDetail>
    </DataSources>
    <Relations isList="true" count="1">
      <dsInventaireToDetail Ref="7" type="DataRelation" isKey="true">
        <Alias>dsInventaireToDetail</Alias>
        <ChildColumns isList="true" count="3">
          <value>ico_pet_noseq</value>
          <value>type_produit</value>
          <value>lpr_usn_code</value>
        </ChildColumns>
        <ChildSource isRef="6" />
        <Dictionary isRef="1" />
        <Name>dsInventaireToDetail</Name>
        <NameInSource>dsInventaireToDetail</NameInSource>
        <ParentColumns isList="true" count="3">
          <value>pet_noseq</value>
          <value>type_produit</value>
          <value>usn_code</value>
        </ParentColumns>
        <ParentSource isRef="5" />
      </dsInventaireToDetail>
    </Relations>
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="25">
      <value>Parameter - Global</value>
      <value>Parameter - Local</value>
      <value>Variable</value>
      <value>Parameter_x0020_-_x0020_Global,p_option_code,p_option_code,,System.String,STANDARD,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Global,p_usg_code,p_usg_code,,System.String,,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Global,p_lan_code,p_lan_code,,System.String,FR,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Global,p_measurement_unit,p_measurement_unit,,System.String,I,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Global,p_show_parameter_section,p_show_parameter_section,,System.Boolean,false,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Global,p_excel_mode,p_excel_mode,,System.Boolean,false,False,False,True,False</value>
      <value>Parameter_x0020_-_x0020_Local,p_pet_noseq,p_pet_noseq,,System.String,_x0031_610207370903,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Local,p_date_debut,p_date_debut,,System.DateTime,_x0031__x002F_1_x002F_1999_x0020_12:00:00_x0020_AM,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Local,p_date_fin,p_date_fin,,System.DateTime,_x0031_2_x002F_31_x002F_2037_x0020_12:00:00_x0020_AM,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Local,p_lpr_noseq,p_lpr_noseq,,System.String,_x0025_,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Local,p_lot_code,p_lot_code,,System.String,,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Local,p_show_inventory,p_show_inventory,,System.String,O,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Local,p_show_inventory_detail,p_show_inventory_detail,,System.String,O,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Local,p_show_advancement,p_show_advancement,,System.String,N,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Local,p_show_advancement_lot,p_show_advancement_lot,,System.String,O,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Local,p_show_advancement_hour,p_show_advancement_hour,,System.String,O,False,False,False,False</value>
      <value>Variable,vRegexpReplaceExpression,vRegexpReplaceExpression,,System.String,_x0027__x0028__x005B_0-9_x005D__x007B_1_x002C__x007D__x0029__x0027__x002C__x0020__x0027_0000000000_x005C_1_x0027__x0029__x002C__x0020__x0027_0_x002A__x0028__x005B_0-9_x005D__x007B_10_x007D__x0029__x0027__x002C__x0027__x005C_1_x0027_,False,False,False,False</value>
      <value>Variable,vSommeHeure,vSommeHeure,,System.Decimal,,False,False,False,False</value>
      <value>Variable,vSommePoids,vSommePoids,,System.Decimal,,False,False,False,False</value>
      <value>Variable,vSommeSurface,vSommeSurface,,System.Decimal,,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Local,p_usn_code,p_usn_code,,System.String,_x0025_,False,False,False,False</value>
      <value>Parameter_x0020_-_x0020_Local,p_show_zero_project,p_show_zero_project,,System.String,O,False,False,False,False</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="2">
    <Item7 Ref="8" type="Stimulsoft.Report.StiGlobalizationContainer" isKey="true">
      <CultureName>fr</CultureName>
      <Items isList="true" count="6">
        <value>lblExcelDetailQuantiteConsomme.Text,Quantité_x000D__x000A_consommée</value>
        <value>lblExcelDetailVariance.Text,Variance_x000D__x000A_Consommée_x000D__x000A_vs_x000D__x000A_projeté</value>
        <value>lblExcelQuantiteConsomme.Text,Quantité_x000D__x000A_consommée</value>
        <value>lblExcelSommeQuantiteConsomme.Text,Quantité_x000D__x000A_consommée</value>
        <value>lblExcelSommeVariance.Text,Variance_x000D__x000A_Consommée_x000D__x000A_vs_x000D__x000A_projeté</value>
        <value>lblExcelVariance.Text,Variance_x000D__x000A_Consommée_x000D__x000A_vs_x000D__x000A_projeté</value>
      </Items>
    </Item7>
    <Item8 Ref="9" type="Stimulsoft.Report.StiGlobalizationContainer" isKey="true">
      <CultureName>en</CultureName>
      <Items isList="true" count="92">
        <value>lblAvDetailLotHeaderLot.Text,Weight_x0020_and_x0020_surface_x0020_completed_x0020_for_x0020_the_x0020_production_x0020_lot</value>
        <value>lblAvDetailLotHeaderPeriode.Text,Weight_x0020_and_x0020_surface_x0020_completed_x0020_for_x0020_the_x0020_period</value>
        <value>lblAvDetailLotPoids.Text,Completed_x000D__x000A_weight</value>
        <value>lblAvDetailLotSurface.Text,Completed_x000D__x000A_surface</value>
        <value>lblAvExcelLotPeriodeHeure.Text,Worked_x000D__x000A_hour</value>
        <value>lblAvExcelLotPeriodePoids.Text,Completed_x000D__x000A_weight</value>
        <value>lblAvExcelLotPeriodeRatio.Text,Ratio_x000D__x000A_Surface_x000D__x000A__x002F_hour</value>
        <value>lblAvExcelLotPeriodeSurface.Text,Completed_x000D__x000A_surface</value>
        <value>lblAvExcelPeriode.Text,Period_x0020_from_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_p_date_debut_x0029__x007D__x0020_to_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_p_date_fin_x0029__x007D_</value>
        <value>lblAvExcelProjet.Text,Project</value>
        <value>lblAvExcelProjetNom.Text,Name</value>
        <value>lblAvExcelTotal.Text,Total_x0020_to_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_Today_x0029__x007D_</value>
        <value>lblAvExcelTotalHeureEstime.Text,Estimated_x000D__x000A_hour</value>
        <value>lblAvExcelTotalHeurePourTermine.Text,Hour_x000D__x000A_to_x000D__x000A_complete</value>
        <value>lblAvExcelTotalHeureTravail.Text,Worked_x000D__x000A_hour</value>
        <value>lblAvExcelTotalPoidsEstime.Text,Estimated_x000D__x000A_weight</value>
        <value>lblAvExcelTotalPoidsPourTermine.Text,Weight_x000D__x000A_to_x000D__x000A_complete</value>
        <value>lblAvExcelTotalPoidsTravail.Text,Completed_x000D__x000A_weight</value>
        <value>lblAvExcelTotalRatio.Text,Ratio_x000D__x000A_Surface_x000D__x000A__x002F_hour</value>
        <value>lblAvExcelTotalRatioHeureTonne.Text,Ratio_x000D__x000A_Hour_x002F__x000D__x000A_ton</value>
        <value>lblAvExcelTotalSurfaceEstime.Text,Estimated_x000D__x000A_surface</value>
        <value>lblAvExcelTotalSurfacePourTermine.Text,Surface_x000D__x000A_to_x000D__x000A_complete</value>
        <value>lblAvExcelTotalSurfaceTravail.Text,Completed_x000D__x000A_surface</value>
        <value>lblAvHeureCategorie.Text,Category</value>
        <value>lblAvHeureEstimeTotal.Text,Estimated_x000D__x000A_hour_x000D__x000A__x0028_Total_x0029_</value>
        <value>lblAvHeureHeader.Text,Hour_x0020_worked_x0020_by_x0020_category</value>
        <value>lblAvHeureTravailPeriode.Text,Worked_x000D__x000A_hour_x000D__x000A__x0028_Period_x0029_</value>
        <value>lblAvHeureTravailTotal.Text,Worked_x000D__x000A_hour_x000D__x000A__x0028_Total_x0029_</value>
        <value>lblAvNom.Text,Name</value>
        <value>lblAvPeriode.Text,Period_x0020_from_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_p_date_debut_x0029__x007D__x0020_to_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_p_date_fin_x0029__x007D_</value>
        <value>lblAvPeriodeLotHeureTravail.Text,Worked_x000D__x000A_hour</value>
        <value>lblAvPeriodeLotPoidsComplete.Text,Completed_x000D__x000A_weight</value>
        <value>lblAvPeriodeLotRatio.Text,Ratio_x000D__x000A_Surface_x000D__x000A__x002F_hour</value>
        <value>lblAvPeriodeLotSurfaceComplete.Text,Completed_x000D__x000A_surface</value>
        <value>lblAvProjet.Text,Project</value>
        <value>lblAvTotal.Text,Total_x0020_to_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_Today_x0029__x007D_</value>
        <value>lblAvTotalHeureEstime.Text,Estimated_x000D__x000A_hour</value>
        <value>lblAvTotalHeurePourTermine.Text,Hour_x000D__x000A_to_x000D__x000A_complete</value>
        <value>lblAvTotalHeureTravail.Text,Worked_x000D__x000A_hour</value>
        <value>lblAvTotalPoidsComplete.Text,Completed_x000D__x000A_weight</value>
        <value>lblAvTotalPoidsEstime.Text,Estimated_x000D__x000A_weight</value>
        <value>lblAvTotalPoidsPourTermine.Text,Weight_x000D__x000A_to_x000D__x000A_complete</value>
        <value>lblAvTotalRatio.Text,Ratio_x000D__x000A_Surface_x000D__x000A__x002F_hour</value>
        <value>lblAvTotalRatioHeureTonne.Text,Ratio_x000D__x000A_Hour_x002F__x000D__x000A_ton</value>
        <value>lblAvTotalSurfaceComplete.Text,Completed_x000D__x000A_surface</value>
        <value>lblAvTotalSurfaceEstime.Text,Estimated_x000D__x000A_surface</value>
        <value>lblAvTotalSurfacePourTermine.Text,Surface_x000D__x000A_to_x000D__x000A_complete</value>
        <value>lblDetailCouche.Text,Coat</value>
        <value>lblDetailPart.Text,Part</value>
        <value>lblDetailProduit.Text,Product</value>
        <value>lblDetailQuantiteConsomme.Text,Consumed_x000D__x000A_quantity</value>
        <value>lblDetailQuantiteDiscard.Text,Discarded_x000D__x000A_quantity</value>
        <value>lblDetailQuantiteProjete.Text,Projected_x000D__x000A_quantity</value>
        <value>lblDetailTitreLot.Text,Detail_x0020_of_x0020_the_x0020_consumption_x0020_for_x0020_the_x0020_production_x0020_lot</value>
        <value>lblDetailTitrePeriode.Text,Detail_x0020_of_x0020_the_x0020_consumption_x0020_for_x0020_the_x0020_period</value>
        <value>lblDetailVariance.Text,Variance_x000D__x000A_Consumed_x000D__x000A_vs_x000D__x000A_projected</value>
        <value>lblExcelCodeProjet.Text,Project</value>
        <value>lblExcelDetailCouche.Text,Coat</value>
        <value>lblExcelDetailPartie.Text,Part</value>
        <value>lblExcelDetailPeriode.Text,Period_x0020_from_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_p_date_debut_x0029__x007D__x0020_to_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_p_date_fin_x0029__x007D_</value>
        <value>lblExcelDetailProduit.Text,Product</value>
        <value>lblExcelDetailQuantiteConsomme.Text,Consumed_x000D__x000A_quantity</value>
        <value>lblExcelDetailQuantiteJete.Text,Discard_x000D__x000A_quantity</value>
        <value>lblExcelDetailQuantiteProjete.Text,Projected_x000D__x000A_quantity</value>
        <value>lblExcelDetailVariance.Text,Variance_x000D__x000A_Consumed_x000D__x000A_vs_x000D__x000A_projected</value>
        <value>lblExcelNomProjet.Text,Name</value>
        <value>lblExcelQuantiteConsomme.Text,Consumed_x000D__x000A_quantity</value>
        <value>lblExcelQuantiteJete.Text,Discarded_x000D__x000A_quantity</value>
        <value>lblExcelQuantiteProjete.Text,Projected_x000D__x000A_quantity</value>
        <value>lblExcelSommeJete.Text,Discarded_x000D__x000A_quantity</value>
        <value>lblExcelSommePeriode.Text,Period_x0020_from_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_p_date_debut_x0029__x007D__x0020_to_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_p_date_fin_x0029__x007D_</value>
        <value>lblExcelSommeQuantiteConsomme.Text,Consumed_x000D__x000A_quantity</value>
        <value>lblExcelSommeQuantiteProjete.Text,Projected_x000D__x000A_quantity</value>
        <value>lblExcelSommeVariance.Text,Variance_x000D__x000A_Consumed_x000D__x000A_vs_x000D__x000A_projected</value>
        <value>lblExcelTotal.Text,Total_x000D__x000A_quantity</value>
        <value>lblExcelTotalAu.Text,Total_x0020_from_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_Today_x0029__x007D_</value>
        <value>lblExcelVariance.Text,Variance_x000D__x000A_Consumed_x000D__x000A_vs_x000D__x000A_projected</value>
        <value>lblNom.Text,Name</value>
        <value>lblPeriode.Text,Period_x0020_from_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_p_date_debut_x0029__x007D__x0020_to_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_p_date_fin_x0029__x007D_</value>
        <value>lblPeriodeQuantiteConsomme.Text,Consumed_x000D__x000A_quantity</value>
        <value>lblPeriodeQuantiteDiscard.Text,Discarded_x000D__x000A_quantity</value>
        <value>lblPeriodeQuantiteProjete.Text,Projected_x000D__x000A_quantity</value>
        <value>lblPeriodeVariance.Text,Variance_x000D__x000A_Consumed_x000D__x000A_vs_x000D__x000A_projected</value>
        <value>lblProjet.Text,Project</value>
        <value>lblQuantiteConsomme.Text,Consumed_x000D__x000A_quantity</value>
        <value>lblQuantiteDiscard.Text,Discarded_x000D__x000A_quantity</value>
        <value>lblQuantiteProjete.Text,Projected_x000D__x000A_quantity</value>
        <value>lblQuantiteTotal.Text,Total_x000D__x000A_quantity</value>
        <value>lblTotalAu.Text,Total_x0020_as_x0020__x007B_string.Format_x0028__x0022__x007B_0:dd_x002F_MM_x002F_yyyy_x007D__x0022__x002C__x0020_Today_x0029__x007D_</value>
        <value>lblVariance.Text,Variance_x000D__x000A_Consumed_x000D__x000A_vs_x000D__x000A_projected</value>
        <value>txtAvReportTitle.Text,_x007B_dsReportInformation.report_title_x007D__x0020_-_x0020_ADVANCEMENT_x0020_OF_x0020_PRODUCTION</value>
        <value>txtReportTitle.Text,_x007B_dsReportInformation.report_title_x007D__x0020_-_x0020_COATING_x0020_PRODUCT_x0020_INVENTORY</value>
      </Items>
    </Item8>
  </GlobalizationStrings>
  <Key>b106f593ecb74309831b36c49a5c1cc7</Key>
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <PageInventaireExcel Ref="10" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="3">
        <rtbExcelInventaire Ref="11" type="ReportTitleBand" isKey="true">
          <Brush>Transparent</Brush>
          <CanShrink>True</CanShrink>
          <ClientRectangle>0,0.15,29,0.95</ClientRectangle>
          <Components isList="true" count="3">
            <pnlExcelHeaderMain Ref="12" type="Panel" isKey="true">
              <Brush>EmptyBrush</Brush>
              <CanGrow>True</CanGrow>
              <CanShrink>True</CanShrink>
              <ClientRectangle>0,0,9.75,0.95</ClientRectangle>
              <Components isList="true" count="11">
                <lblExcelVariance Ref="13" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>8.95,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>657f714079e4439299512e4203869d47</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelVariance</Name>
                  <Page isRef="10" />
                  <Parent isRef="12" />
                  <Text>Variance
Consommé
vs
projeté</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelVariance>
                <lblExcelQuantiteProjete Ref="14" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>8.15,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>2b46f05704dc4d21a51274b81fc879fd</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelQuantiteProjete</Name>
                  <Page isRef="10" />
                  <Parent isRef="12" />
                  <Text>Quantité
projeté</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelQuantiteProjete>
                <lblExcelBalance Ref="15" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>7.35,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>574cce628dcb49a6ae181ad4a0f02f29</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelBalance</Name>
                  <Page isRef="10" />
                  <Parent isRef="12" />
                  <Text>Balance</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelBalance>
                <lblExcelQuantiteJete Ref="16" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>6.55,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>1e987f09451843839d08d59e05e98b5a</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelQuantiteJete</Name>
                  <Page isRef="10" />
                  <Parent isRef="12" />
                  <Text>Quantité
jeté</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelQuantiteJete>
                <lblExcelQuantiteConsomme Ref="17" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>5.75,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>76472c450cb048868fae91c491b62453</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelQuantiteConsomme</Name>
                  <Page isRef="10" />
                  <Parent isRef="12" />
                  <Text>Quantité
consommé</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelQuantiteConsomme>
                <lblExcelTotal Ref="18" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>4.95,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>02a0fb65894147a6b75d08cabbffb90a</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelTotal</Name>
                  <Page isRef="10" />
                  <Parent isRef="12" />
                  <Text>Quantité
total</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelTotal>
                <lblExcelTotalAu Ref="19" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>4.95,0,4.8,0.2</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>a2257cb8d83e48c0970a12a813348e42</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelTotalAu</Name>
                  <Page isRef="10" />
                  <Parent isRef="12" />
                  <Text>Total au {string.Format("{0:dd/MM/yyyy}", Today)}</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelTotalAu>
                <lblExcelType Ref="20" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>4.55,0.2,0.4,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>b9f11f54ee7d443e82b3db95b772dcbf</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelType</Name>
                  <Page isRef="10" />
                  <Parent isRef="12" />
                  <Text>Unité</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelType>
                <lblExcelCodeProjet Ref="21" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0.2,1,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>316e6ffa637e446f9832b9a83d9d5aa5</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelCodeProjet</Name>
                  <Page isRef="10" />
                  <Parent isRef="12" />
                  <Text>Projet</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelCodeProjet>
                <lblExcelNomProjet Ref="22" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>1,0.2,2.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>508f74c27f50425f976ddeb37f5e92ad</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelNomProjet</Name>
                  <Page isRef="10" />
                  <Parent isRef="12" />
                  <Text>Nom</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelNomProjet>
                <Text3 Ref="23" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>3.8,0.2,0.75,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>ec47a72dfc0c43d8ba83a6cc2185af5f</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text3</Name>
                  <Page isRef="10" />
                  <Parent isRef="12" />
                  <Text>Usine</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </Text3>
              </Components>
              <Conditions isList="true" count="0" />
              <DockStyle>Left</DockStyle>
              <Name>pnlExcelHeaderMain</Name>
              <Page isRef="10" />
              <Parent isRef="11" />
            </pnlExcelHeaderMain>
            <pnlExcelHeaderNoDetail Ref="24" type="Panel" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <CanShrink>True</CanShrink>
              <ClientRectangle>9.75,0,3.2,0.95</ClientRectangle>
              <Components isList="true" count="6">
                <lblExcelSommeQuantiteConsomme Ref="25" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>54366117aace416b8a915110c5e45062</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelSommeQuantiteConsomme</Name>
                  <Page isRef="10" />
                  <Parent isRef="24" />
                  <Text>Quantité
consommé</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelSommeQuantiteConsomme>
                <lblExcelSommeJete Ref="26" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0.8,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>162109b04165437f88c1c4980b33f3ab</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelSommeJete</Name>
                  <Page isRef="10" />
                  <Parent isRef="24" />
                  <Text>Quantité
jeté</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelSommeJete>
                <lblExcelSommeQuantiteProjete Ref="27" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>1.6,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>18226ff108c846eb86b6c92813973fd3</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelSommeQuantiteProjete</Name>
                  <Page isRef="10" />
                  <Parent isRef="24" />
                  <Text>Quantité
projeté</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelSommeQuantiteProjete>
                <lblExcelSommeVariance Ref="28" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>2.4,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>e8b1542b93234f8ba71e0863338e3f9d</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelSommeVariance</Name>
                  <Page isRef="10" />
                  <Parent isRef="24" />
                  <Text>Variance
Consommé
vs
projeté</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelSommeVariance>
                <lblExcelSommePeriode Ref="29" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0,3.2,0.2</ClientRectangle>
                  <Conditions isList="true" count="1">
                    <value>_x007B_p_lpr_noseq_x0020__x0021__x003D__x0020__x0022__x0025__x0022__x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None</value>
                  </Conditions>
                  <Font>Arial,8,Bold</Font>
                  <Guid>d0cd565cf75046d69d5a9cdadba9439c</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelSommePeriode</Name>
                  <Page isRef="10" />
                  <Parent isRef="24" />
                  <Text>Période du {string.Format("{0:dd/MM/yyyy}", p_date_debut)} au {string.Format("{0:dd/MM/yyyy}", p_date_fin)}</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelSommePeriode>
                <lblExcelSommeLot Ref="30" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0,3.2,0.2</ClientRectangle>
                  <Conditions isList="true" count="1">
                    <value>_x007B_p_lpr_noseq_x0020__x003D__x003D__x0020__x0022__x0025__x0022__x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None</value>
                  </Conditions>
                  <Font>Arial,8,Bold</Font>
                  <Guid>d6a9d347cd814a799e87740b2bb7eb0b</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelSommeLot</Name>
                  <Page isRef="10" />
                  <Parent isRef="24" />
                  <Text>Lot:  {p_lot_code}</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelSommeLot>
              </Components>
              <Conditions isList="true" count="1">
                <value>_x007B_p_show_inventory_detail_x0020__x003D__x003D__x0020__x0022_O_x0022__x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None</value>
              </Conditions>
              <DockStyle>Left</DockStyle>
              <Name>pnlExcelHeaderNoDetail</Name>
              <Page isRef="10" />
              <Parent isRef="11" />
            </pnlExcelHeaderNoDetail>
            <pnlExcelHeaderDetail Ref="31" type="Panel" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <CanShrink>True</CanShrink>
              <ClientRectangle>12.95,0,12.7,0.95</ClientRectangle>
              <Components isList="true" count="12">
                <lblExcelDetailQuantiteConsomme Ref="32" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>9.5,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>0e65ef3ffca4419aa810ba9a27545cd4</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelDetailQuantiteConsomme</Name>
                  <Page isRef="10" />
                  <Parent isRef="31" />
                  <Text>Quantité
consommé</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelDetailQuantiteConsomme>
                <lblExcelDetailQuantiteJete Ref="33" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>10.3,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>95acc2a162ef424781e0c5f7e8462b2f</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelDetailQuantiteJete</Name>
                  <Page isRef="10" />
                  <Parent isRef="31" />
                  <Text>Quantité
jeté</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelDetailQuantiteJete>
                <lblExcelDetailQuantiteProjete Ref="34" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>11.1,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>e4951e33b1e04c9d982c018ee8e6e321</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelDetailQuantiteProjete</Name>
                  <Page isRef="10" />
                  <Parent isRef="31" />
                  <Text>Quantité
projeté</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelDetailQuantiteProjete>
                <lblExcelDetailVariance Ref="35" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>11.9,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>2228eb57dde240e0ad5dd397edc605d0</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelDetailVariance</Name>
                  <Page isRef="10" />
                  <Parent isRef="31" />
                  <Text>Variance
Consommé
vs
projeté</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelDetailVariance>
                <lblExcelDetailDate Ref="36" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0.2,0.7,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>85c35dc4b7bc4afca76af7a9c31bb43c</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelDetailDate</Name>
                  <Page isRef="10" />
                  <Parent isRef="31" />
                  <Text>Date</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelDetailDate>
                <lblExcelDetailProduit Ref="37" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0.7,0.2,2.85,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>fb7098dc8ece4a16bf8d76a4f56b25fa</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelDetailProduit</Name>
                  <Page isRef="10" />
                  <Parent isRef="31" />
                  <Text>Produit</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelDetailProduit>
                <lblExcelDetailPartie Ref="38" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>3.55,0.2,2.85,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>d9b7f97e6f7f417bafabdc00fb3004f2</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelDetailPartie</Name>
                  <Page isRef="10" />
                  <Parent isRef="31" />
                  <Text>Partie</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelDetailPartie>
                <lblExcelDetailLot Ref="39" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>6.4,0.2,0.6,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>75020bfce40e46d6b3a27a3468554e14</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelDetailLot</Name>
                  <Page isRef="10" />
                  <Parent isRef="31" />
                  <Text>Lot</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelDetailLot>
                <lblExcelDetailCouche Ref="40" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>7,0.2,0.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>293f66b999494c30a3af4896a607c7cc</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelDetailCouche</Name>
                  <Page isRef="10" />
                  <Parent isRef="31" />
                  <Text>Couche</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelDetailCouche>
                <lblExcelDetailNote Ref="41" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>7.8,0.2,1.7,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8,Bold</Font>
                  <Guid>77849df53a334785ae83b07a007a8e5c</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelDetailNote</Name>
                  <Page isRef="10" />
                  <Parent isRef="31" />
                  <Text>Note</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelDetailNote>
                <lblExcelDetailTitreLot Ref="42" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0,12.7,0.2</ClientRectangle>
                  <Conditions isList="true" count="1">
                    <value>_x007B_p_lpr_noseq_x0020__x003D__x003D__x0020__x0022__x0025__x0022__x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None</value>
                  </Conditions>
                  <Font>Arial,8,Bold</Font>
                  <Guid>2cb2dbf4be29426dae5d805499999f7a</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelDetailTitreLot</Name>
                  <Page isRef="10" />
                  <Parent isRef="31" />
                  <Text>Lot:  {p_lot_code}</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelDetailTitreLot>
                <lblExcelDetailPeriode Ref="43" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0,12.7,0.2</ClientRectangle>
                  <Conditions isList="true" count="1">
                    <value>_x007B_p_lpr_noseq_x0020__x0021__x003D__x0020__x0022__x0025__x0022__x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None</value>
                  </Conditions>
                  <Font>Arial,8,Bold</Font>
                  <Guid>2c04211a86894bc2a42ff74b1b590e86</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>lblExcelDetailPeriode</Name>
                  <Page isRef="10" />
                  <Parent isRef="31" />
                  <Text>Période du {string.Format("{0:dd/MM/yyyy}", p_date_debut)} au {string.Format("{0:dd/MM/yyyy}", p_date_fin)}</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                  <VertAlignment>Center</VertAlignment>
                </lblExcelDetailPeriode>
              </Components>
              <Conditions isList="true" count="1">
                <value>_x007B_p_show_inventory_detail_x0020__x003D__x003D__x0020__x0022_N_x0022__x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None</value>
              </Conditions>
              <DockStyle>Left</DockStyle>
              <Name>pnlExcelHeaderDetail</Name>
              <Page isRef="10" />
              <Parent isRef="11" />
            </pnlExcelHeaderDetail>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>rtbExcelInventaire</Name>
          <Page isRef="10" />
          <Parent isRef="10" />
        </rtbExcelInventaire>
        <DataBand2 Ref="44" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <CanBreak>True</CanBreak>
          <CanShrink>True</CanShrink>
          <ClientRectangle>0,1.4,29,1.65</ClientRectangle>
          <Components isList="true" count="3">
            <Panel2 Ref="45" type="Panel" isKey="true">
              <Brush>[255:255:0]</Brush>
              <CanBreak>True</CanBreak>
              <CanGrow>True</CanGrow>
              <CanShrink>True</CanShrink>
              <ClientRectangle>0,0,9.75,1.65</ClientRectangle>
              <Components isList="true" count="10">
                <txtExcelCodeProjet Ref="46" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>0,0,1,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Left</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>a43b0cec056a47dfbf3ab059b5755ea1</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>txtExcelCodeProjet</Name>
                  <Page isRef="10" />
                  <Parent isRef="45" />
                  <Text>{dsInventaire.job_code}</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>DataColumn</Type>
                </txtExcelCodeProjet>
                <txtExcelNomProjet Ref="47" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>1,0,2.8,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Left</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>8c91bab93502404cbf09572517a54aa3</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>txtExcelNomProjet</Name>
                  <Page isRef="10" />
                  <Parent isRef="45" />
                  <Text>{dsInventaire.job_nom}</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>DataColumn</Type>
                </txtExcelNomProjet>
                <Text4 Ref="48" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>3.8,0,0.75,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Left</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>fe9a27d9d04e47ebb8ad6d316ee2dd87</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text4</Name>
                  <Page isRef="10" />
                  <Parent isRef="45" />
                  <Text>{dsInventaire.usn_code}</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>DataColumn</Type>
                </Text4>
                <txtExcelType Ref="49" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>4.55,0,0.4,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Left</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>1e76d46c940d4eeea080822bab403969</Guid>
                  <HorAlignment>Center</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>txtExcelType</Name>
                  <Page isRef="10" />
                  <Parent isRef="45" />
                  <Text>{dsInventaire.display_unit}</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>DataColumn</Type>
                </txtExcelType>
                <txtExcelTotal Ref="50" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>4.95,0,0.8,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Left</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>0d30ab6441d84392af54458e557bc80d</Guid>
                  <HorAlignment>Right</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>txtExcelTotal</Name>
                  <Page isRef="10" />
                  <Parent isRef="45" />
                  <Text>{dsInventaire.quantite_total}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="51" type="NumberFormat" isKey="true">
                    <DecimalDigits>2</DecimalDigits>
                    <GroupSeparator>,</GroupSeparator>
                    <NegativePattern>1</NegativePattern>
                  </TextFormat>
                  <Type>DataColumn</Type>
                </txtExcelTotal>
                <txtExcelQuantiteConsomme Ref="52" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>5.75,0,0.8,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Left</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>62a997cbcb2f48ebbb25378057af38ca</Guid>
                  <HorAlignment>Right</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>txtExcelQuantiteConsomme</Name>
                  <Page isRef="10" />
                  <Parent isRef="45" />
                  <Text>{dsInventaire.quantite_consomme}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="53" type="NumberFormat" isKey="true">
                    <DecimalDigits>2</DecimalDigits>
                    <GroupSeparator>,</GroupSeparator>
                    <NegativePattern>1</NegativePattern>
                  </TextFormat>
                  <Type>DataColumn</Type>
                </txtExcelQuantiteConsomme>
                <txtExcelQuantiteJete Ref="54" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>6.55,0,0.8,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Left</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>639543a7f19e448f9d68dbccd5d6279c</Guid>
                  <HorAlignment>Right</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>txtExcelQuantiteJete</Name>
                  <Page isRef="10" />
                  <Parent isRef="45" />
                  <Text>{dsInventaire.quantite_discard}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="55" type="NumberFormat" isKey="true">
                    <DecimalDigits>2</DecimalDigits>
                    <GroupSeparator>,</GroupSeparator>
                    <NegativePattern>1</NegativePattern>
                  </TextFormat>
                  <Type>DataColumn</Type>
                </txtExcelQuantiteJete>
                <txtExcelBalance Ref="56" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>7.35,0,0.8,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Left</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>e696b59bd48349a3a68e02f3b0f0adcc</Guid>
                  <HorAlignment>Right</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>txtExcelBalance</Name>
                  <Page isRef="10" />
                  <Parent isRef="45" />
                  <Text>{dsInventaire.quantite_balance}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="57" type="NumberFormat" isKey="true">
                    <DecimalDigits>2</DecimalDigits>
                    <GroupSeparator>,</GroupSeparator>
                    <NegativePattern>1</NegativePattern>
                  </TextFormat>
                  <Type>DataColumn</Type>
                </txtExcelBalance>
                <txtExcelQuantiteProjete Ref="58" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>8.15,0,0.8,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Left</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>44ceed7fd284477ba61229485eb88678</Guid>
                  <HorAlignment>Right</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>txtExcelQuantiteProjete</Name>
                  <Page isRef="10" />
                  <Parent isRef="45" />
                  <Text>{dsInventaire.quantite_projete}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="59" type="NumberFormat" isKey="true">
                    <DecimalDigits>2</DecimalDigits>
                    <GroupSeparator>,</GroupSeparator>
                    <NegativePattern>1</NegativePattern>
                  </TextFormat>
                  <Type>DataColumn</Type>
                </txtExcelQuantiteProjete>
                <txtExcelVariance Ref="60" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>8.95,0,0.8,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Fill</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>c870d5dfd4ad4961b9d7f4073f245395</Guid>
                  <HorAlignment>Right</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>txtExcelVariance</Name>
                  <Page isRef="10" />
                  <Parent isRef="45" />
                  <Text>{dsInventaire.quantite_variance}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="61" type="NumberFormat" isKey="true">
                    <DecimalDigits>2</DecimalDigits>
                    <GroupSeparator>,</GroupSeparator>
                    <NegativePattern>1</NegativePattern>
                  </TextFormat>
                  <Type>DataColumn</Type>
                </txtExcelVariance>
              </Components>
              <Conditions isList="true" count="0" />
              <DockStyle>Left</DockStyle>
              <GrowToHeight>True</GrowToHeight>
              <Name>Panel2</Name>
              <Page isRef="10" />
              <Parent isRef="44" />
            </Panel2>
            <pnlExcelDataNoDetail Ref="62" type="Panel" isKey="true">
              <Brush>Transparent</Brush>
              <CanBreak>True</CanBreak>
              <CanGrow>True</CanGrow>
              <CanShrink>True</CanShrink>
              <ClientRectangle>9.75,0,3.2,1.65</ClientRectangle>
              <Components isList="true" count="4">
                <txtExcelSommeQuantiteConsomme Ref="63" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>0,0,0.8,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Left</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>640adb14ac634c98a8b4405784e70e65</Guid>
                  <HorAlignment>Right</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>txtExcelSommeQuantiteConsomme</Name>
                  <Page isRef="10" />
                  <Parent isRef="62" />
                  <Text>{dsInventaire.calc_total_quantite_utilise}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="64" type="NumberFormat" isKey="true">
                    <DecimalDigits>2</DecimalDigits>
                    <GroupSeparator>,</GroupSeparator>
                    <NegativePattern>1</NegativePattern>
                  </TextFormat>
                  <Type>DataColumn</Type>
                </txtExcelSommeQuantiteConsomme>
                <txtExcelSommeJete Ref="65" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>0.8,0,0.8,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Left</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>878097887fbe41f4bc9647f3aeeca5d9</Guid>
                  <HorAlignment>Right</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>txtExcelSommeJete</Name>
                  <Page isRef="10" />
                  <Parent isRef="62" />
                  <Text>{dsInventaire.calc_total_quantite_discard}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="66" type="NumberFormat" isKey="true">
                    <DecimalDigits>2</DecimalDigits>
                    <GroupSeparator>,</GroupSeparator>
                    <NegativePattern>1</NegativePattern>
                  </TextFormat>
                  <Type>DataColumn</Type>
                </txtExcelSommeJete>
                <txtExcelSommeQuantiteProjete Ref="67" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>1.6,0,0.8,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Left</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>3b3ab55fd2704003a31317a288c9e0a3</Guid>
                  <HorAlignment>Right</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>txtExcelSommeQuantiteProjete</Name>
                  <Page isRef="10" />
                  <Parent isRef="62" />
                  <Text>{dsInventaire.calc_total_quantite_projete}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="68" type="NumberFormat" isKey="true">
                    <DecimalDigits>2</DecimalDigits>
                    <GroupSeparator>,</GroupSeparator>
                    <NegativePattern>1</NegativePattern>
                  </TextFormat>
                  <Type>DataColumn</Type>
                </txtExcelSommeQuantiteProjete>
                <txtExcelSommeVariance Ref="69" type="Text" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <CanBreak>True</CanBreak>
                  <CanGrow>True</CanGrow>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>2.4,0,0.8,1.65</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DockStyle>Fill</DockStyle>
                  <Font>Arial,8</Font>
                  <GrowToHeight>True</GrowToHeight>
                  <Guid>1da03e32a43b45349243abe1e1b4e940</Guid>
                  <HorAlignment>Right</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>txtExcelSommeVariance</Name>
                  <Page isRef="10" />
                  <Parent isRef="62" />
                  <Text>{dsInventaire.calc_total_quantite_variance}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="70" type="NumberFormat" isKey="true">
                    <DecimalDigits>2</DecimalDigits>
                    <GroupSeparator>,</GroupSeparator>
                    <NegativePattern>1</NegativePattern>
                  </TextFormat>
                  <Type>DataColumn</Type>
                </txtExcelSommeVariance>
              </Components>
              <Conditions isList="true" count="1">
                <value>_x007B_p_show_inventory_detail_x0020__x003D__x003D__x0020__x0022_O_x0022__x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None</value>
              </Conditions>
              <DockStyle>Left</DockStyle>
              <Name>pnlExcelDataNoDetail</Name>
              <Page isRef="10" />
              <Parent isRef="44" />
            </pnlExcelDataNoDetail>
            <Panel3 Ref="71" type="Panel" isKey="true">
              <Brush>Transparent</Brush>
              <CanBreak>True</CanBreak>
              <CanGrow>True</CanGrow>
              <CanShrink>True</CanShrink>
              <ClientRectangle>12.95,0,16.05,1.65</ClientRectangle>
              <Components isList="true" count="1">
                <DataBand1 Ref="72" type="DataBand" isKey="true">
                  <Brush>[195:214:155]</Brush>
                  <BusinessObjectGuid isNull="true" />
                  <CanBreak>True</CanBreak>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>0,0.15,16.05,0.3</ClientRectangle>
                  <Components isList="true" count="10">
                    <txtExcelDetailDate Ref="73" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <ClientRectangle>0,0,0.7,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <Guid>b2d9457295cd4438a4f888a2d2a784b1</Guid>
                      <Margins>0,0,0,0</Margins>
                      <Name>txtExcelDetailDate</Name>
                      <Page isRef="10" />
                      <Parent isRef="72" />
                      <Text>{dsInventaireDetail.ico_date}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="74" type="CustomFormat" isKey="true">
                        <StringFormat>dd/MM/yyyy</StringFormat>
                      </TextFormat>
                      <Type>DataColumn</Type>
                    </txtExcelDetailDate>
                    <txtExcelDetailProduit Ref="75" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <ClientRectangle>0.7,0,2.85,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <Guid>cd70927bee014275999e6cf749921c52</Guid>
                      <Margins>0,0,0,0</Margins>
                      <Name>txtExcelDetailProduit</Name>
                      <Page isRef="10" />
                      <Parent isRef="72" />
                      <ShrinkFontToFit>True</ShrinkFontToFit>
                      <Text>{dsInventaireDetail.pdt_code}</Text>
                      <TextBrush>Black</TextBrush>
                      <Type>DataColumn</Type>
                    </txtExcelDetailProduit>
                    <txtExcelDetailPartie Ref="76" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <ClientRectangle>3.55,0,2.85,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <Guid>bab18f0aef3e4d0a90d6edfa3c1783c3</Guid>
                      <Margins>0,0,0,0</Margins>
                      <Name>txtExcelDetailPartie</Name>
                      <Page isRef="10" />
                      <Parent isRef="72" />
                      <ShrinkFontToFit>True</ShrinkFontToFit>
                      <Text>{dsInventaireDetail.prd_code}</Text>
                      <TextBrush>Black</TextBrush>
                      <Type>DataColumn</Type>
                    </txtExcelDetailPartie>
                    <txtExcelDetailLot Ref="77" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <ClientRectangle>6.4,0,0.6,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <Guid>91f159323f904d969ffe78a87037b8b1</Guid>
                      <Margins>0,0,0,0</Margins>
                      <Name>txtExcelDetailLot</Name>
                      <Page isRef="10" />
                      <Parent isRef="72" />
                      <Text>{dsInventaireDetail.lpr_code}</Text>
                      <TextBrush>Black</TextBrush>
                      <Type>DataColumn</Type>
                    </txtExcelDetailLot>
                    <txtExcelDetailCouche Ref="78" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <ClientRectangle>7,0,0.8,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <Guid>f9efe32ddf964308bb1c1734bdbd230b</Guid>
                      <Margins>0,0,0,0</Margins>
                      <Name>txtExcelDetailCouche</Name>
                      <Page isRef="10" />
                      <Parent isRef="72" />
                      <Text>{dsInventaireDetail.lpc_nom}</Text>
                      <TextBrush>Black</TextBrush>
                      <Type>DataColumn</Type>
                    </txtExcelDetailCouche>
                    <txtExcelDetailNote Ref="79" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <ClientRectangle>7.8,0,1.7,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <Guid>93aee64c232a41f9a0cfc105d52bbefa</Guid>
                      <Margins>0,0,0,0</Margins>
                      <Name>txtExcelDetailNote</Name>
                      <Page isRef="10" />
                      <Parent isRef="72" />
                      <Text>{dsInventaireDetail.ico_note}</Text>
                      <TextBrush>Black</TextBrush>
                      <Type>DataColumn</Type>
                    </txtExcelDetailNote>
                    <txtExcelDetailQuantiteConsomme Ref="80" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <ClientRectangle>9.5,0,0.8,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <Guid>665d78974b484d97b3033bf975900f3a</Guid>
                      <HorAlignment>Right</HorAlignment>
                      <Margins>0,0,0,0</Margins>
                      <Name>txtExcelDetailQuantiteConsomme</Name>
                      <Page isRef="10" />
                      <Parent isRef="72" />
                      <Text>{dsInventaireDetail.quantite_utilise}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="81" type="NumberFormat" isKey="true">
                        <DecimalDigits>3</DecimalDigits>
                        <GroupSeparator>,</GroupSeparator>
                        <NegativePattern>1</NegativePattern>
                        <UseLocalSetting>False</UseLocalSetting>
                      </TextFormat>
                      <Type>DataColumn</Type>
                    </txtExcelDetailQuantiteConsomme>
                    <txtExcelDetailQuantiteJete Ref="82" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <ClientRectangle>10.3,0,0.8,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <Guid>74dcfe8eabc54ead9dd03091772cebac</Guid>
                      <HorAlignment>Right</HorAlignment>
                      <Margins>0,0,0,0</Margins>
                      <Name>txtExcelDetailQuantiteJete</Name>
                      <Page isRef="10" />
                      <Parent isRef="72" />
                      <Text>{dsInventaireDetail.quantite_discard}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="83" type="NumberFormat" isKey="true">
                        <DecimalDigits>3</DecimalDigits>
                        <GroupSeparator>,</GroupSeparator>
                        <NegativePattern>1</NegativePattern>
                        <UseLocalSetting>False</UseLocalSetting>
                      </TextFormat>
                      <Type>DataColumn</Type>
                    </txtExcelDetailQuantiteJete>
                    <txtExcelDetailQuantiteProjete Ref="84" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <ClientRectangle>11.1,0,0.8,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <Guid>493ffa89812549e6856662fd0b41eaa9</Guid>
                      <HorAlignment>Right</HorAlignment>
                      <Margins>0,0,0,0</Margins>
                      <Name>txtExcelDetailQuantiteProjete</Name>
                      <Page isRef="10" />
                      <Parent isRef="72" />
                      <Text>{dsInventaireDetail.quantite_projete}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="85" type="NumberFormat" isKey="true">
                        <DecimalDigits>3</DecimalDigits>
                        <GroupSeparator>,</GroupSeparator>
                        <NegativePattern>1</NegativePattern>
                        <UseLocalSetting>False</UseLocalSetting>
                      </TextFormat>
                      <Type>DataColumn</Type>
                    </txtExcelDetailQuantiteProjete>
                    <txtExcelDetailVariance Ref="86" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <ClientRectangle>11.9,0,0.8,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <Guid>098d6855ffb24ff89db09f52e91cc14a</Guid>
                      <HorAlignment>Right</HorAlignment>
                      <Margins>0,0,0,0</Margins>
                      <Name>txtExcelDetailVariance</Name>
                      <Page isRef="10" />
                      <Parent isRef="72" />
                      <Text>{dsInventaireDetail.quantite_variance}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="87" type="NumberFormat" isKey="true">
                        <DecimalDigits>3</DecimalDigits>
                        <GroupSeparator>,</GroupSeparator>
                        <NegativePattern>1</NegativePattern>
                        <UseLocalSetting>False</UseLocalSetting>
                      </TextFormat>
                      <Type>DataColumn</Type>
                    </txtExcelDetailVariance>
                  </Components>
                  <Conditions isList="true" count="0" />
                  <DataRelationName>dsInventaireToDetail</DataRelationName>
                  <DataSourceName>dsInventaireDetail</DataSourceName>
                  <Filters isList="true" count="0" />
                  <MasterComponent isRef="44" />
                  <Name>DataBand1</Name>
                  <Page isRef="10" />
                  <Parent isRef="71" />
                  <Sort isList="true" count="0" />
                </DataBand1>
              </Components>
              <Conditions isList="true" count="0" />
              <DockStyle>Fill</DockStyle>
              <GrowToHeight>True</GrowToHeight>
              <Name>Panel3</Name>
              <Page isRef="10" />
              <Parent isRef="44" />
            </Panel3>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>dsInventaire</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataBand2</Name>
          <Page isRef="10" />
          <Parent isRef="10" />
          <PrintIfDetailEmpty>True</PrintIfDetailEmpty>
          <Sort isList="true" count="0" />
        </DataBand2>
        <DataBandMaster Ref="88" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,3.35,29,1.65</ClientRectangle>
          <Components isList="true" count="1">
            <Panel1 Ref="89" type="Panel" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,29,1.65</ClientRectangle>
              <Components isList="true" count="1">
                <DataBandDetail Ref="90" type="DataBand" isKey="true">
                  <Brush>Transparent</Brush>
                  <BusinessObjectGuid isNull="true" />
                  <ClientRectangle>0,0.15,29,0.65</ClientRectangle>
                  <Components isList="true" count="13">
                    <Text5 Ref="91" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <CanBreak>True</CanBreak>
                      <CanGrow>True</CanGrow>
                      <CanShrink>True</CanShrink>
                      <ClientRectangle>0,0,1,0.65</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <GrowToHeight>True</GrowToHeight>
                      <Guid>2d397c21f6a14767bce3d4719f59fd59</Guid>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text5</Name>
                      <Page isRef="10" />
                      <Parent isRef="90" />
                      <Text>{dsInventaire.job_code}</Text>
                      <TextBrush>Black</TextBrush>
                      <Type>DataColumn</Type>
                    </Text5>
                    <Text6 Ref="92" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <CanBreak>True</CanBreak>
                      <CanGrow>True</CanGrow>
                      <CanShrink>True</CanShrink>
                      <ClientRectangle>1,0,2.8,0.65</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <GrowToHeight>True</GrowToHeight>
                      <Guid>8cf9ef4dcb7e4cccaf162e49190e8894</Guid>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text6</Name>
                      <Page isRef="10" />
                      <Parent isRef="90" />
                      <Text>{dsInventaire.job_nom}</Text>
                      <TextBrush>Black</TextBrush>
                      <Type>DataColumn</Type>
                    </Text6>
                    <Text7 Ref="93" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <CanBreak>True</CanBreak>
                      <CanGrow>True</CanGrow>
                      <CanShrink>True</CanShrink>
                      <ClientRectangle>3.8,0,0.75,0.65</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <GrowToHeight>True</GrowToHeight>
                      <Guid>afd6e8a25a624511bc7547d5182280fb</Guid>
                      <HorAlignment>Center</HorAlignment>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text7</Name>
                      <Page isRef="10" />
                      <Parent isRef="90" />
                      <Text>{dsInventaire.usn_code}</Text>
                      <TextBrush>Black</TextBrush>
                      <Type>DataColumn</Type>
                    </Text7>
                    <Text8 Ref="94" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <CanBreak>True</CanBreak>
                      <CanGrow>True</CanGrow>
                      <CanShrink>True</CanShrink>
                      <ClientRectangle>4.55,0,0.4,0.65</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <GrowToHeight>True</GrowToHeight>
                      <Guid>4a8265fe4e874f17b9d51b6377b6792d</Guid>
                      <HorAlignment>Center</HorAlignment>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text8</Name>
                      <Page isRef="10" />
                      <Parent isRef="90" />
                      <Text>{dsInventaire.display_unit}</Text>
                      <TextBrush>Black</TextBrush>
                      <Type>DataColumn</Type>
                    </Text8>
                    <Text9 Ref="95" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <CanBreak>True</CanBreak>
                      <CanGrow>True</CanGrow>
                      <CanShrink>True</CanShrink>
                      <ClientRectangle>4.95,0,0.8,0.65</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <GrowToHeight>True</GrowToHeight>
                      <Guid>0b0d3b95cc8c4cabbcd9a21c96c2158b</Guid>
                      <HorAlignment>Right</HorAlignment>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text9</Name>
                      <Page isRef="10" />
                      <Parent isRef="90" />
                      <Text>{dsInventaire.quantite_total}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="96" type="NumberFormat" isKey="true">
                        <DecimalDigits>2</DecimalDigits>
                        <GroupSeparator>,</GroupSeparator>
                        <NegativePattern>1</NegativePattern>
                      </TextFormat>
                      <Type>DataColumn</Type>
                    </Text9>
                    <Text10 Ref="97" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <CanBreak>True</CanBreak>
                      <CanGrow>True</CanGrow>
                      <CanShrink>True</CanShrink>
                      <ClientRectangle>5.75,0,0.8,0.65</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <GrowToHeight>True</GrowToHeight>
                      <Guid>616f5fb7327e411e8a2fc5c2bdf0755c</Guid>
                      <HorAlignment>Right</HorAlignment>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text10</Name>
                      <Page isRef="10" />
                      <Parent isRef="90" />
                      <Text>{dsInventaire.quantite_consomme}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="98" type="NumberFormat" isKey="true">
                        <DecimalDigits>2</DecimalDigits>
                        <GroupSeparator>,</GroupSeparator>
                        <NegativePattern>1</NegativePattern>
                      </TextFormat>
                      <Type>DataColumn</Type>
                    </Text10>
                    <Text11 Ref="99" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <CanBreak>True</CanBreak>
                      <CanGrow>True</CanGrow>
                      <CanShrink>True</CanShrink>
                      <ClientRectangle>6.55,0,0.8,0.65</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <GrowToHeight>True</GrowToHeight>
                      <Guid>bcc61d1659aa471ca76f3a3c1db23421</Guid>
                      <HorAlignment>Right</HorAlignment>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text11</Name>
                      <Page isRef="10" />
                      <Parent isRef="90" />
                      <Text>{dsInventaire.quantite_discard}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="100" type="NumberFormat" isKey="true">
                        <DecimalDigits>2</DecimalDigits>
                        <GroupSeparator>,</GroupSeparator>
                        <NegativePattern>1</NegativePattern>
                      </TextFormat>
                      <Type>DataColumn</Type>
                    </Text11>
                    <Text12 Ref="101" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <CanBreak>True</CanBreak>
                      <CanGrow>True</CanGrow>
                      <CanShrink>True</CanShrink>
                      <ClientRectangle>7.35,0,0.8,0.65</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <GrowToHeight>True</GrowToHeight>
                      <Guid>01c5b55c609841b1ba6f5f92949d6bf0</Guid>
                      <HorAlignment>Right</HorAlignment>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text12</Name>
                      <Page isRef="10" />
                      <Parent isRef="90" />
                      <Text>{dsInventaire.quantite_balance}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="102" type="NumberFormat" isKey="true">
                        <DecimalDigits>2</DecimalDigits>
                        <GroupSeparator>,</GroupSeparator>
                        <NegativePattern>1</NegativePattern>
                      </TextFormat>
                      <Type>DataColumn</Type>
                    </Text12>
                    <Text13 Ref="103" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <CanBreak>True</CanBreak>
                      <CanGrow>True</CanGrow>
                      <CanShrink>True</CanShrink>
                      <ClientRectangle>8.15,0,0.8,0.65</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <GrowToHeight>True</GrowToHeight>
                      <Guid>1b2a81d021e74b99a6591a32dd94df7f</Guid>
                      <HorAlignment>Right</HorAlignment>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text13</Name>
                      <Page isRef="10" />
                      <Parent isRef="90" />
                      <Text>{dsInventaire.quantite_projete}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="104" type="NumberFormat" isKey="true">
                        <DecimalDigits>2</DecimalDigits>
                        <GroupSeparator>,</GroupSeparator>
                        <NegativePattern>1</NegativePattern>
                      </TextFormat>
                      <Type>DataColumn</Type>
                    </Text13>
                    <Text14 Ref="105" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <CanBreak>True</CanBreak>
                      <CanGrow>True</CanGrow>
                      <CanShrink>True</CanShrink>
                      <ClientRectangle>8.95,0,20.05,0.65</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Fill</DockStyle>
                      <Font>Arial,8</Font>
                      <GrowToHeight>True</GrowToHeight>
                      <Guid>3724b12d5ee14ee79c27fe1f209ab195</Guid>
                      <HorAlignment>Right</HorAlignment>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text14</Name>
                      <Page isRef="10" />
                      <Parent isRef="90" />
                      <Text>{dsInventaire.quantite_variance}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="106" type="NumberFormat" isKey="true">
                        <DecimalDigits>2</DecimalDigits>
                        <GroupSeparator>,</GroupSeparator>
                        <NegativePattern>1</NegativePattern>
                      </TextFormat>
                      <Type>DataColumn</Type>
                    </Text14>
                    <Text15 Ref="107" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <ClientRectangle>8.95,0,0.7,0.65</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <Guid>a962a40063254b2e9ee1c73959589f1f</Guid>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text15</Name>
                      <Page isRef="10" />
                      <Parent isRef="90" />
                      <Text>{dsInventaireDetail.ico_date}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="108" type="CustomFormat" isKey="true">
                        <StringFormat>dd/MM/yyyy</StringFormat>
                      </TextFormat>
                      <Type>DataColumn</Type>
                    </Text15>
                    <Text16 Ref="109" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <ClientRectangle>9.65,0,2.85,0.65</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <Guid>7cd41e9dd02e450187b7e84a3304468e</Guid>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text16</Name>
                      <Page isRef="10" />
                      <Parent isRef="90" />
                      <ShrinkFontToFit>True</ShrinkFontToFit>
                      <Text>{dsInventaireDetail.pdt_code}</Text>
                      <TextBrush>Black</TextBrush>
                      <Type>DataColumn</Type>
                    </Text16>
                    <Text17 Ref="110" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <ClientRectangle>12.5,0,2.85,0.65</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <DockStyle>Left</DockStyle>
                      <Font>Arial,8</Font>
                      <Guid>cf472d39a04941c6a3c2475358ad0bdc</Guid>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text17</Name>
                      <Page isRef="10" />
                      <Parent isRef="90" />
                      <ShrinkFontToFit>True</ShrinkFontToFit>
                      <Text>{dsInventaireDetail.prd_code}</Text>
                      <TextBrush>Black</TextBrush>
                      <Type>DataColumn</Type>
                    </Text17>
                  </Components>
                  <Conditions isList="true" count="0" />
                  <DataRelationName>dsInventaireToDetail</DataRelationName>
                  <DataSourceName>dsInventaireDetail</DataSourceName>
                  <Filters isList="true" count="0" />
                  <MasterComponent isRef="88" />
                  <Name>DataBandDetail</Name>
                  <Page isRef="10" />
                  <Parent isRef="89" />
                  <Sort isList="true" count="0" />
                </DataBandDetail>
              </Components>
              <Conditions isList="true" count="0" />
              <DockStyle>Fill</DockStyle>
              <Name>Panel1</Name>
              <Page isRef="10" />
              <Parent isRef="88" />
            </Panel1>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>dsInventaire</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataBandMaster</Name>
          <Page isRef="10" />
          <Parent isRef="10" />
          <Sort isList="true" count="0" />
        </DataBandMaster>
      </Components>
      <Conditions isList="true" count="1">
        <value>_x007B__x0021__x0028_p_excel_mode_x0020__x003D__x003D__x0020_true_x0020__x0026__x0026__x0020_p_show_inventory_x0020__x003D__x003D__x0020__x0022_O_x0022__x0029__x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None</value>
      </Conditions>
      <ExcelSheet>Inventory</ExcelSheet>
      <Guid>66d648923bd342208882188987f6ba23</Guid>
      <Margins>0.5,0.5,0.5,0.5</Margins>
      <Name>PageInventaireExcel</Name>
      <PageHeight>100</PageHeight>
      <PageWidth>30</PageWidth>
      <Report isRef="0" />
      <ResetPageNumber>True</ResetPageNumber>
      <UnlimitedHeight>True</UnlimitedHeight>
    </PageInventaireExcel>
  </Pages>
  <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>peiCoatingDashboard</ReportAlias>
  <ReportAuthor>ADF Group Inc.</ReportAuthor>
  <ReportChanged>4/5/2019 7:58:32 AM</ReportChanged>
  <ReportCreated>3/16/2015 3:43:49 PM</ReportCreated>
  <ReportGuid>c8b774c5cd0447c283805f6576ea9990</ReportGuid>
  <ReportName>peiCoatingDashboard</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2019.2.2.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 peiCoatingDashboard : Stimulsoft.Report.StiReport
    {
        public peiCoatingDashboard()        {
            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>