Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: leigh p
  Where is leigh p?
 
 California - United States
 leigh p
 Tags
Subject: Multi-Cursor Report Output
Thread ID: 33996 Message ID: 33996 # Views: 4 # Ratings: 0
Version: Visual FoxPro 7 Category: Reports and Printers
Date: Friday, December 05, 2003 8:00:43 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 need it to print just one parent record followed by all child records in succession.
I thought the problem my be when I set the relation into the 2 cursors - as I'm fairly new to this.
This is my code...
SELECT _rptQuery2
INDEX ON parent_id TAG record_id
SELECT _rptquery
SET RELATION TO record_id INTO _rptquery2
SET SKIP TO _rptquery2

or maybe this is just a report design issue. anyone?

Thanks in Advance,
Leigh




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