Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Reports 2.5
I'm a bit rusty with this but from memory you should try something like
this.
Presumably the details you want in header and footer info are retrieved in one of your queries.
Create calculated(?) fields at appropriate levels (you may need to play to get it done) sourced from the query item of interest. You need to set the aggregate function to somethign suitable. For footer info where the report page breaks on it I usually use LAST. The field you add to the footer should source from this new 'calculated' field.
I've used the term calculated field. It might be summary fields you need but this should point you in the right direction.
--
Alan D. Mills
steve.hiltz_at_atl.sofkin.ca wrote in message
<362cd95c.110936346_at_nntp.uunet.ca>...
>Hi All,
>
>Trying to develope a report with both header and footer information
>printed on each page... The real problem is that the header / footer
>information is not common and changes with the query...
> Ex/ Print employee imformation with the emp id and name printed on
>the top and bottom of each page... The detail or body could span
>more than one page, but the header/footer must still be printed on
>each page... Any ideas or suggestions would be greatly appreciated,
>since i have been pulling my hair out trying to solve this problem,
>and i have little hair left...
>
Received on Wed Oct 21 1998 - 05:05:51 CDT