Pas d'inquiétude, avec PBAdonf, c'est dans la poche ! ^^

Le forum (ô combien francophone) des utilisateurs de Powerbuilder.

Recherche rapide

Annonce

Certaines rubriques, dont des cours, sont uniquement visibles par les membres du forum ^^.
Dans la rubrique Liens & Références, vous avez accès à un sommaire de téléchargement, profitez-en !
Il existe maintenant un nouveau TOPIC "Votre CV en Ligne" accessible uniquement par demande.

Pages: 1

 

#1 03-12-2007 21:04:08

balzacdeabel  
Membre
Lieu: Visé
Date d'inscription: 20-09-2007
Messages: 7
Pépites: 28
Banque: 0

[RESOLU] Problème dans numérotation de page et pied de page

Bonjour,

Je suis débutant en powerbuilder et j'ai un problème dans une application d'édition de factures créée en version 5 et que j'ai migré en 6.5. La datawindow qui me permet de visualiser et d'imprimer les factures ne fonctionne plus comme prévu à savoir :

1) la numérotation des factures dans le header group s'affiche de la manière suivante :

   page 1  :  Page 1/1     (la première facture n'a qu'une page)               OK
   page 2  :  Page 2/1     (la deuxième facture n'a qu'une page)              au lieu de       Page 1/1
   page 3  :  Page 3/2     (première page de la troisième facture)            au lieu de       Page 1/2
   page 4  :  Page 4/2     (deuxième page de la troisième facture)           au lieu de       Page 2/2
   page 5  :  Page 5/2     (première page de la quatrième facture)           au lieu de       Page 1/2
   page 6  :  Page 6/2     (deuxième page de la quatrième facture)          au lieu de       Page 2/2
   et ainsi de suite
   le total des pages affiché reste à x/2             

2) dans le footer le total de le facture n'apparaît que sur la première facture et pas sur les suivantes

3) heureusement le detail des factures est correct

Quelqu'un pourrait-il m'aider ?


Bonjour à tous,

Mon problème est résolu car l'application a été migrée avec succès en version 9 et tout est OK.

Super

Merci à tous ceux qui se sont penchés sur la question.

Dernière modification par balzacdeabel (18-12-2007 09:04:59)

Hors ligne

 

#2 03-12-2007 21:15:47

pick ouic  
La bourse ou la vie ^^
Award: gearotter
Lieu: Massy-Verrières
Date d'inscription: 29-05-2006
Messages: 4659
Pépites: 945
Banque: 2,147,483,647
Site web

Re: [RESOLU] Problème dans numérotation de page et pied de page

fais un export de ta dw, et mets le nous.

sinon, dans la rupture ?

Connaitre son ignorance est une grande part de la connaissance.
http://animegifs.free.fr/anime/mazinger/mazinger.gif

Hors ligne

 

#3 03-12-2007 22:01:05

balzacdeabel  
Membre
Lieu: Visé
Date d'inscription: 20-09-2007
Messages: 7
Pépites: 28
Banque: 0

Re: [RESOLU] Problème dans numérotation de page et pied de page

Comme je suis un vrai débutant, explique moi comment je peut t'envoyer la DW que j'ai quand même su exporter

Hors ligne

 

#4 03-12-2007 22:16:57

JCZ  
Builder Power
Award: bf
Lieu: 75019 paris
Date d'inscription: 21-05-2007
Messages: 1724
Pépites: 496,453,703,213
Banque: 9,223,372,036,854,776,000

Re: [RESOLU] Problème dans numérotation de page et pied de page

tu fais un copier/coller du code de l'export dans le message en ajoutant [ code=pb ] avant
et [ / code ] après sans les espaces

Face à l'agression, la puissance de l'intelligence

Hors ligne

 

#5 03-12-2007 22:21:11

balzacdeabel  
Membre
Lieu: Visé
Date d'inscription: 20-09-2007
Messages: 7
Pépites: 28
Banque: 0

Re: [RESOLU] Problème dans numérotation de page et pied de page

Voici la DW exportée

Code: pb

$PBExportHeader$d_facture.srd
release 6;
datawindow(units=3 timer_interval=0 color=1090519039 processing=0 print.documentname="Facture" print.orientation = 2 print.margin.left = 0 print.margin.right = 0 print.margin.top = 0 print.margin.bottom = 0 print.paper.source = 0 print.paper.size = 9 print.prompt=no print.buttons=no print.preview.buttons=no )
summary(height=26 color="553648127" )
footer(height=5106 color="553648127" )
detail(height=476 color="553648127"  height.autosize=yes)
table(column=(type=char(100) updatewhereclause=yes name=art_description_francaise dbname="article.art_description_francaise" )
 column=(type=char(15) updatewhereclause=yes name=clt_code_postal dbname="client.clt_code_postal" )
 column=(type=char(3) updatewhereclause=yes name=clt_pays dbname="client.clt_pays" initial="B" )
 column=(type=char(50) updatewhereclause=yes name=clt_nom dbname="client.clt_nom" )
 column=(type=char(50) updatewhereclause=yes name=clt_adresse dbname="client.clt_adresse" )
 column=(type=char(50) updatewhereclause=yes name=clt_localite dbname="client.clt_localite" )
 column=(type=char(12) updatewhereclause=yes name=clt_num_tva dbname="client.clt_num_tva" )
 column=(type=char(1) updatewhereclause=yes name=client_clt_asj dbname="client.clt_asj" )
 column=(type=char(10) updatewhereclause=yes key=yes name=cde_num_bon dbname="commande.cde_num_bon" )
 column=(type=decimal(0) updatewhereclause=yes name=cde_num_client dbname="commande.cde_num_client" )
 column=(type=decimal(0) updatewhereclause=yes name=commande_cde_num_chantier dbname="commande.cde_num_chantier" )
 column=(type=char(20) updatewhereclause=yes name=commande_cde_reference_client dbname="commande.cde_reference_client" )
 column=(type=char(2000) updatewhereclause=yes name=cde_commentaire dbname="commande.cde_commentaire" )
 column=(type=decimal(0) updatewhereclause=yes name=cde_num_article dbname="commande.cde_num_article" )
 column=(type=decimal(3) updatewhereclause=yes name=commande_cde_quantite dbname="commande.cde_quantite" )
 column=(type=decimal(2) updatewhereclause=yes name=cde_prix_unitaire dbname="commande.cde_prix_unitaire" )
 column=(type=decimal(0) updatewhereclause=yes name=cde_code_tva dbname="commande.cde_code_tva" )
 column=(type=date updatewhereclause=yes name=cde_date_commande dbname="commande.cde_date_commande" )
 column=(type=char(2) updatewhereclause=yes name=commande_cde_unite_mesure dbname="commande.cde_unite_mesure" )
 column=(type=decimal(0) update=yes updatewhereclause=yes name=commande_cde_facture dbname="commande.cde_facture" )
 column=(type=char(100) updatewhereclause=yes name=article_art_description_neerlandaise dbname="article.art_description_neerlandaise" )
 column=(type=decimal(0) updatewhereclause=yes name=client_clt_code_langue dbname="client.clt_code_langue" initial="1" values="Français  1/Neerlandais  2/Allemand  3/" )
 column=(type=char(2) updatewhereclause=yes name=commande_cde_condition_paiement dbname="commande.cde_condition_paiement" )
 column=(type=char(200) update=yes updatewhereclause=yes name=commande_cde_resultat dbname="commande.cde_resultat" )
 column=(type=decimal(0) updatewhereclause=yes name=client_clt_code_formule dbname="client.clt_code_formule" initial="0" values="0  0/1  1/" )
 column=(type=date update=yes updatewhereclause=yes name=commande_cde_date_facture dbname="commande.cde_date_facture" )
 column=(type=date update=yes updatewhereclause=yes name=commande_cde_date_paiement dbname="commande.cde_date_paiement" )
 column=(type=char(1) updatewhereclause=yes name=commande_cde_type_document dbname="commande.cde_type_document" )
 column=(type=char(3) updatewhereclause=yes name=commande_cde_devise dbname="commande.cde_devise" values="BEF  BEF/EUR  EUR/" )
 column=(type=decimal(2) updatewhereclause=yes name=tva_tvaprc dbname="tva.tvaprc" )
 column=(type=char(80) updatewhereclause=yes name=chantier_ch_nom dbname="chantier.ch_nom" )
 column=(type=char(1) updatewhereclause=yes name=type_ligne dbname="type_ligne" )
 retrieve="  SELECT ~"article~".~"art_description_francaise~",   
         ~"client~".~"clt_code_postal~",   
         ~"client~".~"clt_pays~",   
         ~"client~".~"clt_nom~",   
         ~"client~".~"clt_adresse~",   
         ~"client~".~"clt_localite~",   
         ~"client~".~"clt_num_tva~",   
         ~"client~".~"clt_asj~",   
         ~"commande~".~"cde_num_bon~",   
         ~"commande~".~"cde_num_client~",   
         ~"commande~".~"cde_num_chantier~",   
         ~"commande~".~"cde_reference_client~",   
         ~"commande~".~"cde_commentaire~",   
         ~"commande~".~"cde_num_article~",   
         ~"commande~".~"cde_quantite~",   
         ~"commande~".~"cde_prix_unitaire~",   
         ~"commande~".~"cde_code_tva~",   
         ~"commande~".~"cde_date_commande~",   
         ~"commande~".~"cde_unite_mesure~",   
         ~"commande~".~"cde_facture~",   
         ~"article~".~"art_description_neerlandaise~",   
         ~"client~".~"clt_code_langue~",   
         ~"commande~".~"cde_condition_paiement~",   
         ~"commande~".~"cde_resultat~",   
         ~"client~".~"clt_code_formule~",   
         ~"commande~".~"cde_date_facture~",   
         ~"commande~".~"cde_date_paiement~",   
         ~"commande~".~"cde_type_document~",  
         ~"commande~".~"cde_devise~",
      ~"tva~".~"tvaprc~",
      ~"chantier~".~"ch_nom~",
      '2' type_ligne  
  FROM ~"article~",   
         ~"client~",
        {oj ~"commande~"  LEFT OUTER JOIN ~"chantier~"  ON ~"commande~".~"cde_num_client~" = ~"chantier~".~"ch_client~" AND ~"commande~".~"cde_num_chantier~" = ~"chantier~".~"ch_numero~"},
         ~"tva~"
   WHERE ( ~"commande~".~"cde_num_client~" = ~"client~".~"clt_num_client~" ) and  
         ( ~"commande~".~"cde_num_article~" = ~"article~".~"art_num_article~" ) and
         ( ~"commande~".~"cde_facture~" >= :ra_fct1) and   
         ( ~"commande~".~"cde_facture~" <= :ra_fct2) and
      ( ~"commande~".~"cde_type_document~" = :ra_type) and
      ( ~"commande~".~"cde_code_tva~" = ~"tva~".~"tvacod~")
  UNION
  SELECT '',   
         ~"client~".~"clt_code_postal~",   
         ~"client~".~"clt_pays~",   
         ~"client~".~"clt_nom~",   
         ~"client~".~"clt_adresse~",   
         ~"client~".~"clt_localite~",   
         ~"client~".~"clt_num_tva~",   
         ~"client~".~"clt_asj~",   
         ~"commande~".~"cde_num_bon~",   
         ~"commande~".~"cde_num_client~",   
         ~"commande~".~"cde_num_chantier~",   
         ~"commande~".~"cde_reference_client~",   
         ~"commande~".~"cde_commentaire~",   
         ~"commande~".~"cde_num_article~",   
         0,   
         0,   
         ~"commande~".~"cde_code_tva~",   
         ~"commande~".~"cde_date_commande~",   
         ~"commande~".~"cde_unite_mesure~",   
         ~"commande~".~"cde_facture~",   
         ~"article~".~"art_description_neerlandaise~",   
         ~"client~".~"clt_code_langue~",   
         ~"commande~".~"cde_condition_paiement~",   
         ~"commande~".~"cde_resultat~",   
         ~"client~".~"clt_code_formule~",   
         ~"commande~".~"cde_date_facture~",   
         ~"commande~".~"cde_date_paiement~",   
         ~"commande~".~"cde_type_document~",      
         ~"commande~".~"cde_devise~",
      ~"tva~".~"tvaprc~",
      ~"chantier~".~"ch_nom~",
      '1' type_ligne  
    FROM ~"article~",   
         ~"client~",   
        {oj ~"commande~"  LEFT OUTER JOIN ~"chantier~"  ON ~"commande~".~"cde_num_client~" = ~"chantier~".~"ch_client~" AND ~"commande~".~"cde_num_chantier~" = ~"chantier~".~"ch_numero~"},
      ~"tva~"
   WHERE ( ~"commande~".~"cde_num_client~" = ~"client~".~"clt_num_client~" ) and  
         ( ~"commande~".~"cde_num_article~" = ~"article~".~"art_num_article~" ) and
         ( ~"commande~".~"cde_facture~" >= :ra_fct1) and   
         ( ~"commande~".~"cde_facture~" <= :ra_fct2) and 
      ( ~"commande~".~"cde_type_document~" = :ra_type) and
      ( ~"commande~".~"cde_code_tva~" = ~"tva~".~"tvacod~")
" update="commande" updatewhere=0 updatekeyinplace=no arguments=(("ra_fct1", number),("ra_fct2", number),("ra_type", string))  sort="commande_cde_facture A type_ligne A cde_date_commande A cde_num_bon A " )
group(level=1 header.height=10795 trailer.height=26 by=("commande_cde_type_document" , "commande_cde_facture" ) newpage=yes resetpagecount=yes header.color="553648127" trailer.color="553648127" )
group(level=2 header.height=0 trailer.height=26 by=("type_ligne" ) header.color="536870912" trailer.color="553648127" )
text(band=header alignment="0" text=""border="0" color="0" x="0" y="26" height="423" width="52"  font.face="Arial" font.height="-10" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header.1 id=3 alignment="0" tabsequence=32766 border="0" color="0" x="10556" y="5345" height="423" width="635" format="[general]"  name=clt_pays edit.limit=3 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header.1 id=2 alignment="0" tabsequence=32766 border="0" color="0" x="11297" y="5345" height="423" width="1164" format="[general]"  name=clt_code_postal edit.limit=8 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header.1 id=6 alignment="0" tabsequence=32766 border="0" color="0" x="12567" y="5345" height="423" width="6085" format="[general]"  name=clt_localite edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header.1 id=5 alignment="0" tabsequence=32766 border="0" color="0" x="10556" y="4763" height="423" width="8043" format="[general]"  name=clt_adresse edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header.1 id=4 alignment="0" tabsequence=32766 border="0" color="0" x="10556" y="4181" height="423" width="8016" format="[general]"  name=clt_nom edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header.1 alignment="0" text="Désignation"border="0" color="0" x="7990" y="10213" height="396" width="1772"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header.1 alignment="1" text="N°Bon"border="0" color="0" x="1957" y="10213" height="396" width="926"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header.1 alignment="0" text="Date"border="0" color="0" x="449" y="10213" height="396" width="687"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header.1 alignment="0" text="MONTANT"border="0" color="0" x="17647" y="10240" height="396" width="1508"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header.1 alignment="0" text="P.U."border="0" color="0" x="15636" y="10213" height="396" width="582"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header.1 alignment="1" text="Réf. Client"border="0" color="0" x="3704" y="10240" height="396" width="1508"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header.1 alignment="0" text="Quantité"border="0" color="0" x="12144" y="10213" height="396" width="1270"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header.1 alignment="0" text="UM"border="0" color="0" x="14102" y="10213" height="396" width="476"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
line(band=header.1 x1="1561" y1="10055" x2="1561" y2="10795" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="536870912" )
line(band=header.1 x1="3201" y1="10055" x2="3201" y2="10795" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="536870912" )
line(band=header.1 x1="5715" y1="10055" x2="5715" y2="10795" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="536870912" )
line(band=header.1 x1="11562" y1="10055" x2="11562" y2="10795" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="536870912" )
line(band=header.1 x1="13943" y1="10055" x2="13943" y2="10795" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="536870912" )
line(band=header.1 x1="14710" y1="10055" x2="14710" y2="10795" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="536870912" )
line(band=header.1 x1="16933" y1="10055" x2="16933" y2="10795" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="536870912" )
text(band=header.1 alignment="0" text="Doit pour vente et livraison de ce qui suit:"border="0" color="0" x="79" y="8943" height="396" width="6111"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header.1 alignment="1" text="Note de crédit n°"border="0" color="0" x="79" y="5160" height="396" width="2487" visible="1~tif ( commande_cde_type_document = 'N' , 1 , 0)"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header.1 alignment="0" text="Liège, le "border="0" color="0" x="79" y="2937" height="396" width="1322"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header.1 alignment="1" text="Facture n°"border="0" color="0" x="1031" y="5160" height="396" width="1534" visible="1~tif ( commande_cde_type_document = 'F' , 1 , 0)"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header.1 alignment="1" text="T.V.A."border="0" color="0" x="1719" y="4287" height="396" width="846"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
compute(band=header.1 alignment="0" expression="if( clt_pays =~"BE ~",if( client_clt_asj = 'O', ~"NA~",~"  ~"),~"~")"border="0" color="0" x="3254" y="4287" height="423" width="2434" format="[general]" visible="1~tif( client_clt_asj = 'N', 0 ,1)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=header.1 id=3 alignment="0" tabsequence=32766 border="0" color="0" x="2698" y="4287" height="423" width="449" format="[general]" edit.limit=0 edit.case=any edit.autoselect=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=header.1 id=7 alignment="0" tabsequence=32766 border="0" color="0" x="3254" y="4287" height="423" width="2434" format="[general]"  name=clt_num_tva visible="1~tif ( clt_num_tva = '0' , 0 , 1)" edit.limit=0 edit.case=any edit.autoselect=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=header.1 id=20 alignment="0" tabsequence=32766 border="0" color="0" x="2698" y="5160" height="423" width="2116" format="#### - ####"  name=commande_cde_facture edit.limit=0 edit.case=any edit.autoselect=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header.1 id=26 alignment="0" tabsequence=32766 border="0" color="0" x="1640" y="2937" height="423" width="2196" format="[general]"  name=commande_cde_date_facture edit.limit=0 edit.case=any edit.autoselect=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
compute(band=header.1 alignment="1" expression="'Page ' + page() + ' / ' + pageCount()"border="0" color="0" x="15160" y="2937" height="423" width="4762" format="[general]"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header.1 alignment="0" text="4000 Liège"border="0" color="0" x="13149" y="979" height="529" width="2169"  font.face="Arial" font.height="-12" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header.1 alignment="0" text="Galerie de la Sauvenière, 5"border="0" color="0" x="13149" y="424" height="529" width="5291"  font.face="Arial" font.height="-12" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header.1 alignment="0" text="tél:  04/223 17 20"border="0" color="0" x="13149" y="1535" height="423" width="2672"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header.1 alignment="0" text="fax: 04/222 39 54"border="0" color="0" x="13149" y="1985" height="423" width="2645"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header.1 x1="0" y1="2779" x2="19923" y2="2779" pen.style="0" pen.width="52" pen.color="0"  background.mode="2" background.color="16777215" )
compute(band=header.1 alignment="0" expression=" page()"border="0" color="0" x="291" y="53" height="502" width="26" format="[general]"  name=page  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
rectangle(band=header.1 x="26" y="10028" height="767" width="19949" brush.hatch="7" brush.color="553648127" pen.style="0" pen.width="26" pen.color="0"  background.mode="2" background.color="0" )
text(band=header.1 alignment="0" text="Centre de recyclage sis à l'Ile Monsin à Liège et Sablières de Rôssart à Flémalle"border="0" color="0" x="79" y="8520" height="396" width="11906"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header.1 alignment="0" text="Concernant votre chantier:"border="0" color="0" x="79" y="7382" height="396" width="3995" visible="1~tif( isnull( chantier_ch_nom ) , 0 ,1 )"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=header.1 id=31 alignment="0" tabsequence=32766 border="0" color="0" x="4233" y="7382" height="396" width="15875" format="[general]"  name=chantier_ch_nom edit.limit=0 edit.case=any edit.autoselect=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header.1 alignment="0" text="recy"border="0" color="255" x="343" y="424" height="1534" width="2645"  font.face="Arial" font.height="-36" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header.1 alignment="0" text="liège"border="0" color="255" x="3016" y="424" height="1534" width="2645"  font.face="Century Schoolbook" font.height="-36" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" font.italic="1" background.mode="2" background.color="16777215" )
text(band=header.1 alignment="0" text="s.a."border="0" color="255" x="5847" y="530" height="1534" width="1455"  font.face="Juice ITC" font.height="-36" font.weight="700"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=9 alignment="0" tabsequence=32766 border="0" color="0" x="1693" y="27" height="423" width="1428" format="[General]"  name=cde_num_bon visible="1~tif  (type_ligne = '1',0,1)" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=12 alignment="0" tabsequence=32766 border="0" color="0" x="3333" y="27" height="423" width="2301" format="[general]"  name=commande_cde_reference_client visible="1~tif  (type_ligne = '1',0,1)" edit.limit=0 edit.case=any edit.autoselect=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=16 alignment="1" tabsequence=32766 border="0" color="0" x="14843" y="27" height="423" width="2037" format="#,##0.00"  name=cde_prix_unitaire visible="1~tif  (type_ligne = '1',0,1)" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
compute(band=detail alignment="0" expression="if( clt_pays = 'BE',  cde_code_tva  , 0) "border="0" color="0" x="19737" y="27" height="423" width="105" format="[general]"  name=tva_r visible="1~t0"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
compute(band=detail alignment="0" expression="case(client_clt_code_langue  when 1 then  art_description_francaise  when 2 then  article_art_description_neerlandaise ) "border="0" color="0" x="5847" y="27" height="423" width="5635" format="[general]" visible="1~tif  (type_ligne = '1',0,1)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=15 alignment="1" tabsequence=32766 border="0" color="0" x="11694" y="27" height="423" width="2169" format="#,##0.000"  name=commande_cde_quantite visible="1~tif  (type_ligne = '1',0,1)" edit.limit=0 edit.case=any edit.autoselect=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=19 alignment="0" tabsequence=32766 border="0" color="0" x="14075" y="27" height="423" width="529" format="[general]"  name=commande_cde_unite_mesure visible="1~tif  (type_ligne = '1',0,1)" edit.limit=0 edit.case=any edit.autoselect=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=18 alignment="0" tabsequence=32766 border="0" color="0" x="105" y="27" height="423" width="1455" format=""  name=cde_date_commande visible="1~tif  (type_ligne = '1',0,1)" edit.name="DD/MM/YY" editmask.mask="DD/MM/YY" editmask.focusrectangle=no  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
line(band=detail x1="11562" y1="0" x2="11562" y2="503" visible="1~tif  (type_ligne = '1',0,1)" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="553648127" )
line(band=detail x1="13943" y1="0" x2="13943" y2="503" visible="1~tif  (type_ligne = '1',0,1)" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="553648127" )
line(band=detail x1="14710" y1="0" x2="14710" y2="503" visible="1~tif  (type_ligne = '1',0,1)" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="553648127" )
line(band=detail x1="16933" y1="0" x2="16933" y2="503" visible="1~tif  (type_ligne = '1',0,1)" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="553648127" )
line(band=detail x1="5715" y1="0" x2="5715" y2="503" visible="1~tif  (type_ligne = '1',0,1)" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="553648127" )
line(band=detail x1="3201" y1="0" x2="3201" y2="503" visible="1~tif  (type_ligne = '1',0,1)" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="553648127" )
line(band=detail x1="1561" y1="0" x2="1561" y2="503" visible="1~tif  (type_ligne = '1',0,1)" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="553648127" )
line(band=detail x1="26" y1="0" x2="26" y2="503~trowheight()" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="553648127" )
column(band=detail id=13 alignment="0" tabsequence=32766 border="0" color="0" x="105" y="27" height="423" width="19817" format="[general]"  name=cde_commentaire visible="1~tif  (type_ligne = '1',1,0)" height.autosize=yes edit.limit=0 edit.case=any edit.autoselect=yes edit.autovscroll=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=detail alignment="1" expression="if ( commande_cde_devise = 'BEF' , /* BEF */ round(if( commande_cde_type_document = 'F' , (commande_cde_quantite  *  cde_prix_unitaire) , -(commande_cde_quantite * cde_prix_unitaire) ) ,0) , /* EUR */  round(if( commande_cde_type_document = 'F' , (commande_cde_quantite  *  cde_prix_unitaire) , -(commande_cde_quantite * cde_prix_unitaire) ) ,2) )"border="0" color="0" x="17012" y="27" height="423" width="2910" format="#,##0.00"  name=montant visible="1~tif  (type_ligne = '1',0,1)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
line(band=detail x1="19976" y1="0" x2="19976" y2="503~trowheight()" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="553648127" )
line(band=trailer.2 x1="0" y1="0" x2="19976" y2="0" pen.style="0" pen.width="26" pen.color="0"  background.mode="1" background.color="553648127" )
rectangle(band=footer x="16166" y="2858" height="1481" width="3545" visible="1~tif(page()=pagecount() , 1 , 0)" brush.hatch="6" brush.color="12632256" pen.style="0" pen.width="26" pen.color="0"  background.mode="2" background.color="0" )
text(band=footer alignment="3" text=""border="0" color="0" x="608" y="2699" height="396" width="132"  name=texte_promo  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
compute(band=footer alignment="0" expression="if( client_clt_code_formule = 1,commande_cde_resultat,~"~") "border="0" color="0" x="132" y="556" height="423" width="19632" format="[general]" visible="1~tif(page()=pagecount() , 1 , 0)"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
compute(band=footer alignment="0" expression="if( client_clt_code_formule = 1,if( client_clt_code_langue = 1,~"CERTIFIE SINCERE ET VERITABLE A LA SOMME DE:~",~"WAAR EN ECHT VOOR DE SOM VAN:~"),~"~")"border="0" color="0" x="132" y="106" height="423" width="12170" format="[general]" visible="1~tif(page()=pagecount() , 1 , 0)"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=footer id=20 alignment="0" tabsequence=32766 border="0" color="0" x="2407" y="3519" height="396" width="2116" format="#### - ####" visible="1~tif(page()=pagecount() , 1 , 0)" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=footer id=27 alignment="0" tabsequence=32766 border="0" color="0" x="2407" y="3096" height="396" width="2248" format="[general]"  name=commande_cde_date_paiement visible="1~tif(page()=pagecount() , 1 , 0)" edit.limit=0 edit.case=any edit.autoselect=yes  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=footer alignment="0" text="Echéance:"border="0" color="0" x="714" y="3096" height="396" width="1561" visible="1~tif(page()=pagecount() , 1 , 0)"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" font.underline="1" background.mode="1" background.color="536870912" )
text(band=footer alignment="0" text="Réf.à rappeler:"border="0" color="0" x="79" y="3519" height="396" width="2196" visible="1~tif(page()=pagecount() , 1 , 0)"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" font.underline="1" background.mode="1" background.color="536870912" )
line(band=footer x1="0" y1="4551" x2="19923" y2="4551" pen.style="0" pen.width="52" pen.color="0"  background.mode="2" background.color="16777215" )
text(band=footer alignment="0" text="R.C. Liège : 191.755"border="0" color="0" x="0" y="4683" height="396" width="3227"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" font.italic="1" background.mode="2" background.color="16777215" )
text(band=footer alignment="3" text="T.V.A. : BE 455.473.297"border="0" color="0" x="8255" y="4683" height="396" width="3730"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" font.italic="1" background.mode="2" background.color="16777215" )
text(band=footer alignment="1" text="Cr. Gén. : 196-0259612-95"border="0" color="0" x="15901" y="4683" height="396" width="4021"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" font.italic="1" background.mode="2" background.color="16777215" )
rectangle(band=footer x="8784" y="1191" height="2725" width="7302" visible="1~tif(page()=pagecount() , 1 , 0)" brush.hatch="7" brush.color="553648127" pen.style="0" pen.width="26" pen.color="0"  background.mode="2" background.color="0" )
compute(band=footer alignment="1" expression="if(page()=pagecount(),sum(if(  tva_r  = 0,montant,0)  for group 1),0)"border="0" color="0" x="8942" y="1667" height="423" width="3016" format="#,##0.00"  name=base_0 visible="1~tif ( base_0 = 0 , 0 , 1)"  hidesnaked=1  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=footer alignment="1" expression="if(page()=pagecount(),sum(if( tva_r  = 0,0,0) for group 1),0)"border="0" color="0" x="13546" y="1667" height="423" width="2354" format="#,##0.00"  name=tva_0 visible="1~tif ( tva_0 = 0 , 0 , 1)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=footer alignment="1" expression="if ( commande_cde_devise = 'BEF' , /* BEF */ if(page()=pagecount(),round(sum(if( tva_r  = 1,(montant *  tva_tvaprc )/100,0) for group 1),2),0) , /* EUR */ if(page()=pagecount(),round(sum(if( tva_r  = 1,(montant *  tva_tvaprc)/100,0) for group 1),2),0) )"border="0" color="0" x="13546" y="2117" height="423" width="2354" format="#,##0.00"  name=tva_1 visible="1~tif ( tva_1 = 0 , 0 , 1)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=footer alignment="1" expression="if(page()=pagecount(),sum(if(  tva_r  = 1,montant ,0)  for group 1),0)"border="0" color="0" x="8942" y="2117" height="423" width="3016" format="#,##0.00"  name=base_1 visible="1~tif ( base_1 = 0 , 0 , 1)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=footer alignment="1" text="TVA"border="0" color="0" x="14472" y="1217" height="396" width="608" visible="1~tif(page()=pagecount() , 1 , 0)"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=footer alignment="0" text="Base"border="0" color="0" x="10027" y="1217" height="396" width="767" visible="1~tif(page()=pagecount() , 1 , 0)"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=footer x1="8784" y1="1641" x2="16086" y2="1641" visible="1~tif(page()=pagecount() , 1 , 0)" pen.style="0" pen.width="26" pen.color="0"  background.mode="2" background.color="16777215" )
text(band=footer alignment="1" text="%"border="0" color="0" x="12647" y="1217" height="396" width="238" visible="1~tif(page()=pagecount() , 1 , 0)"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=footer alignment="1" expression="if(page()=pagecount(),sum(if(  tva_r  = 2,montant,0)  for group 1),0)"border="0" color="0" x="8942" y="2567" height="423" width="3016" format="#,##0.00"  name=base_2 visible="1~tif ( base_2 = 0 , 0 , 1)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=footer alignment="1" expression="if ( commande_cde_devise = 'BEF' , /* BEF */ if(page()=pagecount(),round(sum(if( tva_r  = 2,(montant  *  tva_tvaprc)/100,0) for group 1),2),0) , /* EUR */ if(page()=pagecount(),round(sum(if( tva_r  = 2,(montant  *  tva_tvaprc)/100,0) for group 1),2),0) )"border="0" color="0" x="13546" y="2567" height="423" width="2354" format="#,##0.00"  name=tva_2 visible="1~tif ( tva_2 = 0 , 0 , 1)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=footer alignment="1" expression="if(page()=pagecount(),sum(if(  tva_r  = 3,montant,0)  for group 1),0)"border="0" color="0" x="8942" y="3017" height="423" width="3016" format="#,##0.00"  name=base_3 visible="1~tif ( base_3 = 0 , 0 , 1)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=footer alignment="1" expression="if ( commande_cde_devise = 'BEF' , /* BEF */ if(page()=pagecount(),round(sum(if( tva_r  = 3,(montant  *  tva_tvaprc)/100,0) for group 1),2),0) , /* EUR */ if(page()=pagecount(),round(sum(if( tva_r  = 3,(montant  *  tva_tvaprc)/100,0) for group 1),2),0) )"border="0" color="0" x="13546" y="3017" height="423" width="2354" format="#,##0.00"  name=tva_3 visible="1~tif ( tva_3 = 0 , 0 , 1)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=footer alignment="1" expression="if(page()=pagecount(),sum(montant for group 1) ,0)"border="0" color="0" x="8916" y="3466" height="423" width="3016" format="#,##0.00"  name=base_tot visible="1~tif ( base_tot = 0 , 0 , 1)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=footer id=29 alignment="0" tabsequence=32766 border="0" color="0" x="12356" y="3466" height="396" width="767" format="[general]"  name=commande_cde_devise visible="1~tif ( base_tot = 0 , 0 , 1)" edit.limit=0 edit.case=any edit.autoselect=yes  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
compute(band=footer alignment="1" expression="if ( commande_cde_devise = 'BEF' , /* BEF */ if(page()=pagecount(),round(round(sum(if( tva_r  = 1,(montant *  tva_tvaprc)/100,0) for group 1),2)  + round(sum(if( tva_r  = 2,(montant *  tva_tvaprc)/100,0) for group 1),2) + round(sum(if( tva_r  = 3,(montant *  tva_tvaprc)/100,0) for group 1),2),0),0) , /* EUR */ if(page()=pagecount(),round(sum(if( tva_r  = 1,(montant *  tva_tvaprc)/100,0) for group 1),2)  + round(sum(if( tva_r  = 2,(montant *  tva_tvaprc)/100,0) for group 1),2) + round(sum(if( tva_r  = 3,(montant *  tva_tvaprc)/100,0) for group 1),2),0) )"border="0" color="0" x="13546" y="3466" height="423" width="2354" format="#,##0.00"  name=tva_tot visible="1~tif ( base_tot = 0 , 0 , 1)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
line(band=footer x1="8784" y1="3440" x2="16086" y2="3440" visible="1~tif(page()=pagecount() , 1 , 0)" pen.style="0" pen.width="26" pen.color="0"  background.mode="2" background.color="16777215" )
line(band=footer x1="13335" y1="1191" x2="13335" y2="3916" visible="1~tif(page()=pagecount() , 1 , 0)"  slideup=allabove pen.style="0" pen.width="26" pen.color="0"  background.mode="2" background.color="16777215" )
line(band=footer x1="12091" y1="1191" x2="12091" y2="3916" visible="1~tif(page()=pagecount() , 1 , 0)"  slideup=allabove pen.style="0" pen.width="26" pen.color="0"  background.mode="2" background.color="16777215" )
column(band=footer id=29 alignment="0" tabsequence=32766 border="0" color="0" x="18838" y="3440" height="396" width="767" format="[general]" visible="1~tif ( montant_tot = 0 , 0 , 1)" edit.limit=0 edit.case=any edit.autoselect=yes  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
compute(band=footer alignment="0" expression="if ( commande_cde_devise = 'BEF' , 'EUR' , 'BEF')"border="0" color="0" x="18838" y="3890" height="396" width="767" format="[general]" visible="1~tif ( montant_tot_eur = 0 , 0 , 1)"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
compute(band=footer alignment="1" expression="max(if(  tva_r  = 1, tva_tvaprc ,0)  for group 1)"border="0" color="0" x="12303" y="2117" height="423" width="873" format="0.00"  name=tvaprc_1 visible="1~tif(page()=pagecount() and base_1  <>0 , 1 ,0)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=footer alignment="1" expression="max(if(  tva_r  = 2, tva_tvaprc ,0)  for group 1)"border="0" color="0" x="12303" y="2567" height="423" width="873" format="0.00"  name=tvaprc_2 visible="1~tif(page()=pagecount() and base_2  <>0 , 1 ,0)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=footer alignment="1" expression="max(if(  tva_r  = 3, tva_tvaprc ,0)  for group 1)"border="0" color="0" x="12303" y="3017" height="423" width="873" format="0.00"  name=tvaprc_3 visible="1~tif(page()=pagecount() and base_3  <>0 , 1 ,0)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=footer alignment="1" expression="max(if(  tva_r  = 0, tva_tvaprc ,0)  for group 1)"border="0" color="0" x="12303" y="1667" height="423" width="873" format="0.00"  name=tvaprc_0 visible="1~tif(page()=pagecount() and base_0  <>0 , 1 ,0)"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=footer alignment="0" text="Solde Global"border="0" color="0" x="17012" y="2937" height="396" width="1852" visible="1~tif(page()=pagecount() , 1 , 0)"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="12632256" )
compute(band=footer alignment="1" expression="if ( commande_cde_devise = 'BEF' , /* BEF */ if(page()=pagecount(), round(sum(montant for group 1) + round(sum(if( tva_r  = 1,(montant *  tva_tvaprc)/100,0) for group 1),2)  + round(sum(if( tva_r  = 2,(montant *  tva_tvaprc)/100,0) for group 1),2)  + round(sum(if( tva_r  = 3,(montant *  tva_tvaprc)/100,0) for group 1),2),0),0) , /* EUR */ if(page()=pagecount(),sum(montant for group 1) + round(sum(if( tva_r  = 1,(montant *  tva_tvaprc)/100,0) for group 1),2)  + round(sum(if( tva_r  = 2,(montant *  tva_tvaprc)/100,0) for group 1),2) + round(sum(if( tva_r  = 3,(montant *  tva_tvaprc)/100,0) for group 1),2),0) )"border="0" color="0" x="16351" y="3440" height="423" width="2354" format="#,##0.00"  name=montant_tot visible="1~tif ( montant_tot = 0 , 0 , 1)"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
compute(band=footer alignment="1" expression="if ( commande_cde_devise = 'BEF' , /* BEF */ round(montant_tot / 40.3399  , 2) , /* EUR */ round(montant_tot * 40.3399  , 0))"border="0" color="0" x="16351" y="3890" height="423" width="2354" format="#,###.00"  name=montant_tot_eur visible="1~tif ( montant_tot_eur = 0 , 0 , 1)"  font.face="Arial" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
htmltable(border="1" cellpadding="0" cellspacing="0" generatecss="no" nowrap="yes")


Merci d'avance

Hors ligne

 

#6 04-12-2007 09:05:02

pick ouic  
La bourse ou la vie ^^
Award: gearotter
Lieu: Massy-Verrières
Date d'inscription: 29-05-2006
Messages: 4659
Pépites: 945
Banque: 2,147,483,647
Site web

Re: [RESOLU] Problème dans numérotation de page et pied de page

"commande_cde_facture" fait office de numero de la facturation ?
que correspond "commande_cde_type_document" ?

Connaitre son ignorance est une grande part de la connaissance.
http://animegifs.free.fr/anime/mazinger/mazinger.gif

Hors ligne

 

#7 04-12-2007 11:59:43

balzacdeabel  
Membre
Lieu: Visé
Date d'inscription: 20-09-2007
Messages: 7
Pépites: 28
Banque: 0

Re: [RESOLU] Problème dans numérotation de page et pied de page

"commande_cde_facture" fait office de numero de la facturation ?
que correspond "commande_cde_type_document" ?

Réponse :
"commande_cde_facture" est la numéro de facture de type 20070123 avec les dates d'un mois complet de facturation
"commande_cde_type_document" est le type de document à éditer F = facture et N = note de crédit

Hors ligne

 

#8 04-12-2007 12:56:45

pick ouic  
La bourse ou la vie ^^
Award: gearotter
Lieu: Massy-Verrières
Date d'inscription: 29-05-2006
Messages: 4659
Pépites: 945
Banque: 2,147,483,647
Site web

Re: [RESOLU] Problème dans numérotation de page et pied de page

si "commande_cde_facture" est un identifiant unique, autant faire une rupture uniquement sur ce n° ?

et pourquoi y a t'il 2 ruptures ?

Connaitre son ignorance est une grande part de la connaissance.
http://animegifs.free.fr/anime/mazinger/mazinger.gif

Hors ligne

 

#9 04-12-2007 13:14:23

balzacdeabel  
Membre
Lieu: Visé
Date d'inscription: 20-09-2007
Messages: 7
Pépites: 28
Banque: 0

Re: [RESOLU] Problème dans numérotation de page et pied de page

"commande_cde_facture" est une suite de numeros de factures par exemple de 20070123 à 20070250
le nombre de facture est variable chaque mois
toutes les factures d'un même mois sont générées en une fois dans la DW en question

Hors ligne

 

#10 04-12-2007 21:03:40

balzacdeabel  
Membre
Lieu: Visé
Date d'inscription: 20-09-2007
Messages: 7
Pépites: 28
Banque: 0

Re: [RESOLU] Problème dans numérotation de page et pied de page

Si ça peut aider, il y a une fonction qui génère les factures

Code: pb

long ll_fac,num,tot,i,lg,mon,ll_jour,ll_mois,ll_annee,j,a,m,cp,num1,conc,v_nul,fct1,tot_lig,prt,deb,fin
string pays,nul,mont,res,ra_type,mydev
date ld_date
integer li_copie,li_client
setpointer(hourglass!)
dw_list.accepttext()
dw_list.update()
if cbx_1.checked = true then
  prt = 1
else
  prt = 0
end if

ll_jour=day(today())
ll_mois = mymois
ll_annee = myannee
ld_date = date_facture(ll_jour,ll_mois,ll_annee)

dw_1.settransobject(SQLCA);
dw_3.settransobject(SQLCA);
dw_4.settransobject(SQLCA);

ra_type = 'F'
dw_1.retrieve(ra_type)

SELECT numero.num_fac
INTO :ll_fac
FROM numero
WHERE numero.num_doc = 'FAC'
USING SQLCA;

fct1 = ll_fac + 1
deb = fct1
tot=dw_1.rowcount()
i = 1
do while (i <= tot)
  dw_1.scrolltorow(i)  
  num = dw_1.getrow()
  if (dw_1.getitemnumber(num,"page") = 1) then
    ll_fac = ll_fac + 1
    num1 = num
  end if
  dw_1.object.commande_cde_facture[num] = ll_fac
  dw_1.object.commande_cde_date_facture[num] = ld_date
  mydev = dw_1.object.commande_cde_devise[num]  
  lg = dw_1.object.client_clt_code_langue[num]
  mon = dec(dw_1.object.montant_tot[num])
  if mydev = 'BEF' then mont = string(mon)
  if mydev = 'EUR' then mont = string(dw_1.object.montant_tot[num])
//  messagebox(string(dw_1.object.montant_tot[num]),mont)
  choose case lg
    case 1
      nb2mot(mont,mydev)
    case 2
      n_nb2mot(mont,mydev)
    case else
      n_nb2mot(mont,mydev)
  end choose
  dw_1.object.commande_cde_resultat[num] = resultat
  
  cp = long(dw_1.object.commande_cde_condition_paiement[num])
  j=day(ld_date)
  m=month(ld_date)
  a=year(ld_date)   
  dw_1.object.commande_cde_date_paiement[num] = date_paiement(j,m,a,cp)

  i = i + 1
loop
fin = ll_fac
UPDATE numero
  SET numero.num_fac = :ll_fac
  WHERE numero.num_doc = 'FAC'
  USING SQLCA ;

dw_1.update()

if prt = 1 and fin >= deb then
  // previsualisation des factures
  messagebox(ra_type,string(deb) + " / " + string(fin))
  dw_4.retrieve(ra_type,deb,fin)
  tot_lig=dw_4.rowcount()
  //  impression des factures
  for i = 1 to tot_lig
    dw_3.retrieve(integer(dw_4.object.cde_facture[i]),integer(dw_4.object.cde_facture[i]),ra_type)    
    li_client = dw_3.object.cde_num_client[1]
    select clt_copies_factures
    into :li_copie
    from client
    where clt_num_client = :li_client
    using sqlca;
    dw_3.Object.DataWindow.Print.copies = li_copie
    dw_3.print()
  next
end if

// note de crédit
ll_jour = day(today())
ll_mois = mymois
ll_annee = myannee
ld_date = date_facture(ll_jour,ll_mois,ll_annee)

dw_1.settransobject(SQLCA);
dw_3.settransobject(SQLCA);
dw_4.settransobject(SQLCA);
ra_type = 'N'
dw_1.retrieve(ra_type)
ll_fac = 0
SELECT numero.num_fac
INTO :ll_fac
FROM numero
WHERE numero.num_doc = 'NC'
USING SQLCA;

fct1 = ll_fac + 1
deb = fct1
tot=dw_1.rowcount()
i = 1
do while (i <= tot)
  dw_1.scrolltorow(i)
  
  num=dw_1.getrow()
  if (dw_1.object.page[num] = 1) then
    ll_fac = ll_fac + 1
    num1 = num
  end if
  dw_1.object.commande_cde_facture[num] = ll_fac
  dw_1.object.commande_cde_date_facture[num] = ld_date
  mydev = dw_1.object.commande_cde_devise[num]    
  lg = dw_1.object.client_clt_code_langue[num]
  mon = dec(dw_1.object.montant_tot[num])
  if mydev = 'BEF' then mont = string(mon)
  if mydev = 'EUR' then mont = string(dw_1.object.montant_tot[num])  
  choose case lg
    case 1
      nb2mot(mont,mydev)
    case 2
      n_nb2mot(mont,mydev)
    case else
      n_nb2mot(mont,mydev)
  end choose
  dw_1.object.commande_cde_resultat[num] = resultat  
  
  cp = long(dw_1.object.commande_cde_condition_paiement[num])  
  j = day(ld_date)
  m = month(ld_date)
  a = year(ld_date)
  dw_1.object.commande_cde_date_paiement[num] = date_paiement(j,m,a,cp)
  i = i + 1
loop
fin = ll_fac
UPDATE numero
  SET numero.num_fac = :ll_fac
  WHERE numero.num_doc = 'NC'
  USING SQLCA ;

dw_1.update()

if prt = 1 and fin >= deb then
  // previsualisation des factures
  dw_4.retrieve(ra_type,deb,fin)
  tot_lig = dw_4.rowcount()
  //  impression des factures
  for i = 1 to tot_lig
    dw_3.retrieve(dw_4.object.cde_facture[i],dw_4.object.cde_facture[i],ra_type)
    li_client = dw_3.object.cde_num_client[1]
    select clt_copies_factures
    into :li_copie
    from client
    where clt_num_client = :li_client
    using sqlca;
    dw_3.Object.DataWindow.Print.copies = li_copie
    dw_3.print()
  next
end if

if prt = 0 then
  gs_sta = 'N'
  opensheet(w_visualisation_facture,w_mdi_frame_recyliege,0,layered!)
  w_visualisation_facture.dw_rech.triggerevent('pbm_retrieve')
end if
setpointer(arrow!)
close(w_genere_facture)

Hors ligne

 

#11 04-12-2007 22:45:50

JCZ  
Builder Power
Award: bf
Lieu: 75019 paris
Date d'inscription: 21-05-2007
Messages: 1724
Pépites: 496,453,703,213
Banque: 9,223,372,036,854,776,000

Re: [RESOLU] Problème dans numérotation de page et pied de page

Pourquoi y a il 2 ruptures ?
Tu as visiblement 2 computes

Code: pb

compute(band=header.1 alignment="1" expression="'Page ' + page() + ' / ' + pageCount()"border="0" color="0" x="15160" y="2937" height="423" width="4762" format="[general]"  font.face="Arial" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=header.1 alignment="0" expression=" page()"border="0" color="0" x="291" y="53" height="502" width="26" format="[general]"  name=page  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )

Les 2 donnent des resultats faux ? ou juste le 2ieme ?
As tu essayé de les recreer ? de les changer de place ? de les afficher separement ( page() et pageCount() ) ?

Face à l'agression, la puissance de l'intelligence

Hors ligne

 

#12 15-12-2007 19:06:34

balzacdeabel  
Membre
Lieu: Visé
Date d'inscription: 20-09-2007
Messages: 7
Pépites: 28
Banque: 0

Re: [RESOLU] Problème dans numérotation de page et pied de page

Bonsoir à tous,

Mon problème est résolu car l'application a été migrée avec succès en version 9 et tout est OK.

Super

Merci à tous ceux qui se sont penchés sur la question.

Hors ligne

 

#13 17-12-2007 09:21:35

wazou1812  
Modératrice
Award: bf
Date d'inscription: 24-05-2006
Messages: 610
Pépites: 2,097
Banque: 3,536,631,712,504

Re: [RESOLU] Problème dans numérotation de page et pied de page

Mon problème est résolu car l'application a été migrée avec succès en version 9 et tout est OK.

bonjour,

Pour mettre ton en RESOLU, tu dois modifier ton premier Post et tu auras accès au titre.

Peux tu le faire ??

Merci

Hors ligne

 

#14 05-02-2008 22:24:39

JCZ  
Builder Power
Award: bf
Lieu: 75019 paris
Date d'inscription: 21-05-2007
Messages: 1724
Pépites: 496,453,703,213
Banque: 9,223,372,036,854,776,000

Re: [RESOLU] Problème dans numérotation de page et pied de page

Je vais le faire pour cette fois
Mais attention ... la prochaine fois

Face à l'agression, la puissance de l'intelligence

Hors ligne

 

 

Pages: 1

Pied de page des forums

Propulsé par FluxBB 1.2.22