OraFAQ Forum: Reports & Discoverer » Query and Report layout issue

Home » Developer & Programmer » Reports & Discoverer » Query and Report layout issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query and Report layout issue [message #465272]

Tue, 13 July 2010 06:16

lakshmi83
Messages: 12
Registered: August 2008
Location: Hyderabad

Junior Member

Hello All,

In one of the report requirements we have to link 2 tables and if data is not available in one of the table in the report output the other column data should be displayed.

Example:

We have 2 tables shipment,order_release.Even shipment is not existing for this order_release in the output the order_release alone need to be displayed.

select shipment_id,order_release_id
from shipment s,order_release orl,link_table lt
where s.shipment_id=lt.shipment_gid
and orl.order_release_id=lt.order_release_id

Output: shipment_id order_release
....... 12374
....... 83460
23459 ......
34785 43987

Can any one help in achieving this?

Thanks in Advance.

Regards,
Lakshmi.

Report message to a moderator

Re: Query and Report layout issue [message #465287 is a reply to message #465272]

Tue, 13 July 2010 07:15

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Is it OUTER JOIN you are looking for?

Report message to a moderator

Re: Query and Report layout issue [message #465485 is a reply to message #465287]

Wed, 14 July 2010 06:01

lakshmi83
Messages: 12
Registered: August 2008
Location: Hyderabad

Junior Member

Yes Littlefoot,

Thanks for the response.
Will the performance of the report go worst by using outer joins?
as i have many tables involved in the original query and all need to fetch data in the below fashion.

Kindly Advice.

Regards,
Lakshmi.

Report message to a moderator

Re: Query and Report layout issue [message #465487 is a reply to message #465485]

Wed, 14 July 2010 06:03

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

If outer-join is required to get the result you need then performance is a bit irrelevant - it might well slow it down, but you'll probably have to live with that - suggest you test it.

EDIT: typo

[Updated on: Wed, 14 July 2010 06:03]

Report message to a moderator

Re: Query and Report layout issue [message #465488 is a reply to message #465487]

Wed, 14 July 2010 06:10

lakshmi83
Messages: 12
Registered: August 2008
Location: Hyderabad

Junior Member

Thanks for the quick response.

Regards,
Lakshmi.

Report message to a moderator

Previous Topic:	REP-1241 Circular column dependency originating with column
Next Topic:	generating pdf on oas

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 04:58:13 CDT 2024