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

I'd go for changing the parent query - seems wasteful to return data that might not be reported. Received on Fri Dec 15 2006 - 19:39:46 CET