Re: begin with report on INFORMIX V4

Bruno SITOT wrote: > > Why each record is displayed twice with the script following ? thanks > > database > essai > end > > define > variable t_a_payer integer > variable t_dette integer > end > > output > report to pipe "impscr" > end > > select impaye.*,client.* > from impaye,client > where ip_solde<>0 > and ip_soc="01" > and ip_client=c_client > order by ip_client,ip_nofac,ip_date > end > > format > page header > print "controle" > > before group of ip_client > let t_a_payer=0 > let t_dette=0 > print c_client,c_nom > > on every row > let t_a_payer=t_a_payer+ip_solde > let t_dette=t_dette+ip_montant > print ip_nofac," ",ip_date," ",ip_montant,ip_solde > > after group of ip_client > print "Controle : ",t_dette,t_a_payer,c_solde > > end What does the program "impscr" do? If you send the report to a file, do you still get records displayed twice? Is ip_client or c_client a primary key? Why are you manually adding totals when you can PRINT GROUP TOTAL. I think it's TOTAL, it's a long time since I used ACE. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+