Hi,
I need help on the following issue:

I have a query that is the union of two sqls. Depending upon the report
type selected on Parameter Form, only one SQL is fired at a time. I am
using single layout for both the reports.
The result set of two SQLs differ by a column as explained below:

Result Set for SQL 1(Report1): Col1 Col2 Col3---------->
Result Set for SQL 2(Report2): Col1 Null Col3

Desrired Output for SQL2: Col1 Col3-------------------->

When the SQL2 (Report2)is fired, I get a blank for Col2 (i.e. null) and
there is a gap in the report output for null values.

What I want is to collapse Col3 so that it does not leave any space
after Col1 and is printed inplace of Col2. The arrows represent that
the border of the col2 shoudl be extended till end of row.
My initial guess was using the Horizontal Elasticity property to
Variable using PL/SQL code. I don't know if I can alter the properties
programitically.

Any ideas,

TIA.

OraRepDvlpr wrote:

Load a global temporary table and report from it.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

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....

OraRepDvlpr wrote:
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@x.washington.edu
(replace 'x' with 'u' to respond)

I am facing the same problem as described in the posts.I am try to hide some fields depending on the parameters. Can u explain both the ways that can be used to solve this. ie creating a new layout and usage of global temporary tables.
Thanks in advance for any help offered.

sekhar