Re: Collapsing a column in layout dynamically in Oracle Reports 6
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 26 Apr 2005 22:41:37 -0700
Message-ID: <1114580255.787450_at_yasure>
Date: Tue, 26 Apr 2005 22:41:37 -0700
Message-ID: <1114580255.787450_at_yasure>
OraRepDvlpr wrote:
> Thanx Daniel.
> I found an easy way (accidently) of doing it by creating a new layout
> (with two columns) and then hiding one layout at a time depending upon
> report type. I would like to know about the global temp table that you
> suggested. What should be in the global temp table?
>
> Not related to this, I cannot get rid of the border around a OLE object
> in the margin section even if I deselected all (TOP/LEFT/RIGHT/BOTTOM)
> from Format-> Borders for an bmp. Any idea....
I use global temporary tables, a lot, to stage data for reports.
Since the table is permanent, only the data is temporary, it is simple to insert it into the table using PL/SQL and then report on it.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Wed Apr 27 2005 - 07:41:37 CEST