Re: Collapsing a column in layout dynamically in Oracle Reports 6

OraRepDvlpr wrote:

> 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.
Load a global temporary table and report from it.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)