Re: Problems with reports
Posted in 1999
Hi Guido! Informix processes your "AFTER GROUP OF" ... then "SKIPs TO TOP OF PAGE" (*within* your after group of) ... has to do a PAGER HEADER (*still within* your after group of) ... and *THEN* fetches the NEXT CUSTOMER ... ... so you will get the effects that you get! You have to put your "SKIP TO TOP OF ROW" in a "BEFORE GROUP OF" section! or do the AFTER/BEFORE clause by yourself like: FIRST PAGE HEADER let newpage=1 ON EVERY ROW if customer<>old_customer and newpage<>1 then begin print "TOTAL OF OLD CUSTOMER", total let newpage=1 skip to top of page let old_customer=customer end if newpage=1 then begin print "YOUR" print "PAGE HEADER" let newpage=0 end print "YOUR CUSTOMER DATA" let total=total+... ON LAST ROW print "TOTAL OF OLD CUSTOMER", total skip to top of page hope this helps for the first. best regards rick Guido Cirilli wrote: > > I have this report situation: > > ...... > ORDER BY <key of customer> > ...... > PAGE HEADER > <Header of customer> > > EVERY ROW > <row of customer> > > AFTER GROUP OF customer > <totals> > SKIP TO TOP OF PAGE > > I need a header in every page regarding the general data of the customer > (like address etc.), so i need a "PAGE HEADER" section. > Then i have to print all data regarding the customer (EVERY ROW section). > Then, when the customer changes (AFTER GROUP) i have to print totals and to > pass to another new page (SKIP TO TOP OF PAGE). > But, at this point, i observed that in the new page header it prints the > old customer data! Then it prints the new rows (regarding the NEW customer). > I launch the report passing to it the new record every time, like this: > START REPORT rep > FOREACH ...into rec.* > OUTPUT TO REPORT rep(rec) > END FOREACH > FINISH REPORT rep > > So it seems that after the "SKIP TO TOP OF PAGE" instruction, it > remains in the report and executes the "PAGE HEADER" section, with old > header data and then exits from the report, instead of exiting from the > report and doing the next FOREACH instruction. > Is there someone who can help me? > Thanx, Guido. > > P.S. > Sorry for my bad English!!! :-))))) -- snail: ANZER GmbH - Pieperstr. 14 - 32791 Lage - Germany email: rick_@t-online.de voice: (0049) 5232 / 9777-21 fax: (0049) 5232 / 78094