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: 112545 # Views: 5 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Thursday, November 09, 2006 2:49:14 PM         
   


Hi Peter,

is the wrafarin stuff for the current patient? Maybe you could set up your report using multiple detail bands and have the patient table as the parent related into latest INR table and also into the warfarin table?

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




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