Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Willem van Oosten
  Where is Willem van Oosten?
 Berkel en Rodenrijs
 Netherlands
 Willem van Oosten
 To: leigh p
  Where is leigh p?
 
 California - United States
 leigh p
 Tags
Subject: RE: Multi-Cursor Report Output
Thread ID: 33996 Message ID: 33997 # Views: 3 # Ratings: 0
Version: Visual FoxPro 7 Category: Reports and Printers
Date: Friday, December 05, 2003 9:34:23 PM         
   


> Hi All! I am in need of some assistance.
>
> I have 2 cursors - #1 = _rptQuery (parent) #2 = _rptQuery2 (child)
> These cursors have a one to many relationship. The key is record_id
>
> I want to output all records in the parent (_rptQuery) and those that match from the child (_rptQuery2).
> The problem I'm having is the output. When there is a match in the child table, it is printing 1 parent record for each child record... like this
>
> 00001 parent loan record - detail..................
> child record - detail.......
> 00001 parent loan record - detail...................
> child record - detail......
> 00001 parent loan record - detail...................
> child record - detail......
>


I don't have a vfp here on this computer,
If I remember well there is a possibility in the report generator to checkmark for "suppress repeated values".

Willem

ENTIRE THREAD

Multi-Cursor Report Output Posted by leigh p @ 12/5/2003 8:00:43 PM
RE: Multi-Cursor Report Output Posted by Willem van Oosten @ 12/5/2003 9:34:23 PM
RE: Multi-Cursor Report Output Posted by Jamie Osborn @ 12/5/2003 9:37:09 PM
RE: Multi-Cursor Report Output Posted by leigh p @ 12/6/2003 2:31:20 AM
RE: Multi-Cursor Report Output Posted by Jamie Osborn @ 12/6/2003 10:14:20 PM