Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Reports 2.5

Re: Reports 2.5

From: <steve.hiltz_at_atl.sofkin.ca>
Date: 1998/10/21
Message-ID: <362dd920.176419836@nntp.uunet.ca>#1/1

On 21 Oct 1998 08:22:09 GMT, "Wernberg-Tougaard" <Christian.H.wernberg-Tougaard_at_uvm.dk*NO_SPAM*> wrote:\\

Read your responce to the user group and im still not clear on the result... I have tried to set the source of my header/footer fields to a db column in the query, but i get an error that the field references the db column at a frequence below its group... The problem is that the header/footer is based some information in the query, so how can i access the information to get the results to display??? Also, there is more than one row being retrieved from the DB, if it was only the one row, I could pass in to key and retrieve the header/footer information...

>
>steve.hiltz_at_atl.sofkin.ca wrote in <362cd341.109373040_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...
>
>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"
>
Received on Wed Oct 21 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US