🚀 go-pugleaf

Bowen Moursund < wrote:
> 
> >Thanks for try; still doesn't constrain parent records.
> 
> Didn't we go through this before, on a similar subject? :-)
> 
I must have trouble expressing myself.   I needed parent record claims =
false _and_ child record procs = 'X'.  Like when you relate the two
tables, set skip to the child  and "set filter to claims->closed = false
.and. procs->tos = 'X'".  Parent record can only print _if_ there is a
related child record = 'X'.   Your way prints a report that looks like
this:
       Parent   Child   Child    Child
     (Closed=F)(Tos=X) (Tos=X)  (Tos=X)
	IDNO	CODE	BILLED	ALLOWED
	12345 
	23456  
	34567	99214	100.00	50.00
	34567	80010	 75.00	40.00
	45678
	56789
	67890	99214	100.00	50.00
What I needed was:
	IDNO	CODE	BILLED	ALLOWED
	34567	99214	100.00	50.00
	34567	80010	 75.00	40.00
	67890	99214	100.00	50.00
Your suggestion in addition to canrender events on report gets the
correct output.  Thanks,

Patricia