Re: Oracle Report : Parent only if Child exists

Abu Hamza wrote:
> Hi,
> I'm new to Oracle Reports. I work as a Software Engineer. Currently
> i've been given assignment to develop a report using Oracle Report
> Builder 10g. It is a Master-Detail report. The parent query brings
> Master records and child query (quite complex) brings the Details. The
> report is showing all parent records even if child records do not
> exist. I only want those parent record displayed which have child
> records. What is the best way to achieve this through the Builder. Or
> do I have to change the Parent query and add extra conditions ?
>
> any help will be appreciated.
>
> thx.
>

[Quoted] [Quoted] If checking if children exist, is complex, then I'd modify the report. But I haven't touched reports this century, although I'm quite sure that RTFM will help you out. Received on Fri Dec 15 2006 - 21:35:02 CET