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


I've emailed the stuff to your hotmail account.

> > 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




Frank.

Frank Cazabon
Samaan Systems Ltd.
www.SamaanSystems.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