Xref: alice comp.databases.oracle.tools:17681 Path: alice!news-feed.fnsi.net!newsfeed.wli.net!howland.erols.net!news.net.uni-c.dk!not-for-mail From: "Wernberg-Tougaard" Newsgroups: comp.databases.oracle.tools Subject: Re: Reports 2.5 Date: 21 Oct 1998 08:22:09 GMT Organization: Ministry of Research and Information Technology Lines: 26 Message-ID: <01bdfcd4$86cd26e0$100514ac@chwer1.uvm.dk> References: <362cd341.109373040@nntp.uunet.ca> X-Trace: news.net.uni-c.dk 908958129 14268 (None) 195.192.252.171 X-Complaints-To: usenet@news.net.uni-c.dk X-Newsreader: Microsoft Internet News 4.70.1161 steve.hiltz@atl.sofkin.ca wrote in <362cd341.109373040@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... The solution that we have focused on, is to use some key ( could be emp-id) in a function that used a cursor to retrive the wanted information. This information is then displayed using the SRW.SET_FIELD_CHAR(0, get_name(id)); We normally use a field that has "DESTYPE" as its contents. If needed I will explain it in greater lenght. -- Christian Wernberg-Tougaard Political Economist Danish Ministry of Research and Information Technology, Building Society Please remove *NO_SPAM* if e-mailing me. "The views expressed are the author's and do not necessarily reflect the official position of the Danish Ministry of Research and Information Technology"