Collapsing a column in layout dynamically in Oracle Reports 6

geturchandu · *nix forums beginner Joined: 02 May 2006 Posts: 1

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

--
geturchandu
------------------------------------------------------------------------
geturchandu's Profile: http://www.dbtalk.net/m267
View this thread: http://www.dbtalk.net/t78709

DA Morgan · *nix forums Guru Joined: 06 Mar 2005 Posts: 1042

OraRepDvlpr wrote:

ORA-LEARNER · *nix forums beginner Joined: 11 May 2005 Posts: 10

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

DA Morgan · *nix forums Guru Joined: 06 Mar 2005 Posts: 1042

OraRepDvlpr wrote:

ORA-LEARNER · *nix forums beginner Joined: 11 May 2005 Posts: 10

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.

Google