Posting from the Informix-list

Obnoxio The Clown wrote: > >From: Adam Tauno Williams <adam@morrison-ind.com> >> >> > From: Alois Erlmaier <AErlmaier@t-online.de> >> >>Is there a function (like pageno) in ACE-Reports, that >>shows die total >> >>nuber of pages of a report? I want to see for example: >>page 5 of 20. >> >Nope. You'll have to page the report to awk or perl and >>mangle it manually. >>I use a construct like: >> >> print "report date: ", today, >> column 45, "page -", >> pageno using "?", "-" >> >> >>in ace reports all the time. > And how, pray tell, does this give you the total number of pages in the report? That was the perl of wisdom /awk/wardly left out of the reply..... Actually, you can do it without going outside of ACE. If you select count(*) to find out how many rows your SQL is returning AND if you know how many lines each row requires in printing you can figure the number of printable lines (less margins and headers and footers) and derive the total number of pages that way. It's crudek, but mostly effective. If you're doing sub-queries that may print multiple lines things start getting nasty. carlos Currently on hiatus from unemployment. ---------------------- Do you do Linux? :) Get your FREE @linuxstart.com email address at: http://www.linuxstart.com