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
 Tags
Subject: multiple cursors in reports.
Thread ID: 112502 Message ID: 112502 # Views: 7 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Thursday, November 09, 2006 6:42:05 AM         
   


hi all
i would like to generate a report that displays results from two cursors in a report.
The two tables have un-related data.
i would prefer to use the reporting instead of creating a memo field with the contents because i can change the formatting of values that are not in range etc.

the contents of the report will look something like:

patient's name etc.

Latest INR values on File:
Date Time INR value Nurse Comments
28/09/2006 2.9 S Jackson a comment
08/09/2006 2.3 S Jackson
06/09/2006 4.5 P Gee
04/09/2006 2.4 S Jackson
03/09/2006 2.2 P Gee

Latest Warfarin Doses on File:
Date Mon Tue Wed Thu Fri Sat Sun Ave Nurse Doctor
09/09/2006 0.0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 S Jackson A Healer
05/09/2006 8.0 8.0 8.0 8.0 8.0 8.0 8.0 2.0 P Gee P Killer
01/09/2006 4.0 4.0 4.0 4.0 4.0 4.0 4.0 6.0 P Gee A Healer
23/08/2006 3.0 3.0 3.0 3.0 3.0 3.0 3.0 4.0 P Gee P Killer
03/08/2006 8.0 0.0 0.0 0.0 0.0 0.0 0.0 1.1 S Jackson A Healer

i am thinking that i can just pass variable parameters to a report, but as i wrote i wont be able to change the formatting of values out of range.

regards
Pete.

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