Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: peter gee
  Where is peter gee?
 Hobart
 Australia
 peter gee
 To: Frank Cazabon
  Where is Frank Cazabon?
 
 Trinidad And Tobago
 Frank Cazabon
 Tags
Subject: RE: multiple cursors in reports.
Thread ID: 112502 Message ID: 112930 # Views: 4 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Tuesday, November 14, 2006 10:07:00 AM         
   


> that sounds like you've got something set up incorrectly, I've done reports like this before using this technique and it displays all the records from one cursor together, then all the records from the other cursor. Double check that you've got the relations set properly and the correct (parent) alias is selected at the start of the report and that you've got the detail bands set to use the correct aliases. If you don't spot anything wrong I'll see if I can knock up a simple example for you.

frank,
i can't seem to get this to work.
i have set up some cursors

select 1 as dumkey, bla bla bla into cursor curReportINR
select 1 as dumkey, bla bla bla into cursor curReportWD
select 1 as dumkey, bla bla bla into cursor curReportPatient
SET RELATION TO curReportPatient.dumkey INTO Curreportwd ADDITIVE
SET RELATION TO curReportPatient.dumkey INTO Curreportinr ADDITIVE

only one patient will be selected in the report.
the relations in the datasession window looks good.
i have set the target alias of the detail tab to many different things, cant seem to get it to work.
i have thought about using a 'flat file' cursor for this, but there are loads of fields and i would like to understand how to use the parent/child relationships properly. This is a trivial matter to set up a subreport in access.

i would appreciate you sending me a working example.

Pete.
peterrichardgee(at)gmail.com

ENTIRE THREAD

multiple cursors in reports. Posted by peter gee @ 11/9/2006 6:42:05 AM
RE: multiple cursors in reports. Posted by Frank Cazabon @ 11/9/2006 2:49:14 PM
RE: multiple cursors in reports. Posted by peter gee @ 11/13/2006 1:19:59 AM
RE: multiple cursors in reports. Posted by Frank Cazabon @ 11/13/2006 2:20:15 PM
RE: multiple cursors in reports. Posted by peter gee @ 11/14/2006 10:07:00 AM
RE: multiple cursors in reports. Posted by Frank Cazabon @ 11/14/2006 2:37:09 PM
RE: multiple cursors in reports. Posted by Frank Cazabon @ 11/14/2006 3:05:27 PM