Re: Report, only show those "parent" where a child exists

From: Paul Dorsey <pdorsey_at_dulcian.com>
Date: Sun, 12 Dec 1999 01:09:50 GMT
Message-ID: <yBC44.948$mv4.21069_at_news.rdc1.nj.home.com>


You need to put a summary column in the group in q1. Then put a format trigger on the frame associated with the q1 group that returns false when the count = 0.

--
Paul Dorsey
Dulcian, Inc.
(212) 595-7223
web address: http://www.dulcian.com
email: pdorsey_at_dulcian.com


mig <oxe_at_xinfo.dk> wrote in message
news:iNu44.148$oa1.1362_at_news.get2net.dk...

> How does one limit the report to show parent records (from group q1) only
> when a records exists in the child query (q2)
> I thought I knew:
>
> I tried to make a counter in q2 - and that can exists in the parent-group
> frame (at the parent level), and when the counter is 0 then a trigger to
the
> parent level saying that then the parent record is not to be printed - but
> now I can-not make it work
>
> Why
> and does anybody have another better method
>
> thanks in advance
>
> akarb$xinfo.com (well remove the $)
>
> please also send a email if possible - as I do not often read theis
> newsgroup
>
>
>
>
>
>
Received on Sun Dec 12 1999 - 02:09:50 CET

Original text of this message