Le forum (ô combien francophone) des utilisateurs de Powerbuilder.
Pages: 1
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
fais un export de ta dw, et mets le nous.
sinon, dans la rupture ?
Hors ligne
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
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
Hors ligne
Voici la DW exportée
$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
"commande_cde_facture" fait office de numero de la facturation ?
que correspond "commande_cde_type_document" ?
Hors ligne
"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
si "commande_cde_facture" est un identifiant unique, autant faire une rupture uniquement sur ce n° ?
et pourquoi y a t'il 2 ruptures ?
Hors ligne
"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
Si ça peut aider, il y a une fonction qui génère les factures
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
Pourquoi y a il 2 ruptures ?
Tu as visiblement 2 computes
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() ) ?
Hors ligne
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
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
Je vais le faire pour cette fois
Mais attention ... la prochaine fois
Hors ligne
Pages: 1