Re: Dev2000 - Report designer problem/question

[Quoted] I will try to restate the problem in a clearer fashion.

I have a situation that in sqlplus I would write as an outer join with a NVL on the child count column.

In the report (due to the size of the tables and complexity) I chose to write two seperate queries. One for the parent record and another for the child. In the data model editor I data linked them by the key. What I want to have happen is when the child query returns no data then I want to display a zero. I have been unable to do this. For some reason when the data link doesn't exist between the two queries then nothing is done for the child query. So what I get is a parent row of data and a blank for the child.

I hope this is a little clearer.

Thanks
Andy

Paul Dorsey wrote in message <70a9q2$lt7_at_bgtnsc03.worldnet.att.net>...
>I don't get it. Why doesn't a count summary field on the detail work?
>--
>Paul Dorsey
>Dulcian, Inc.
>www.dulcian.com
>212 595 7223
>Andrew Hendrickson wrote in message <707nu3$ebr$1_at_news-2.news.gte.net>...
>>To all:
>>
>>This is driving me crazy. I have a parent query and a child query data
>>linked together. When no data exists in the child I would like a zero to
>be
>>displayed on the report. Is there anyway to do this? I have tried
>>placeholder columns but have found them to be no help. I can find nothing
>>in the online help.
>>
>>TIA
>>Andy
>>Replace dot w .
>>
>>
>
>
Received on Sat Oct 17 1998 - 20:49:04 CEST