Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Rog
  Where is Rog?
 Lawrence
 Kansas - United States
 Rog
 Tags
Subject: Print values from mult recs on same row?
Thread ID: 289139 Message ID: 289139 # Views: 23 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Tuesday, December 28, 2010 5:05:42 PM         
   


Is it possible to have values from multiple records on the same row of a report? For example, I'd like the report to look like this:

DATE    Value 1    Value 2    Value 3
         100         111       106 


Another way of saying it is I'd like it to print:

XXXXX XXXXX XXXXX

Instead of

xxxxx
xxxxx
xxxxx

The table actually may have 3 different records by date and time, in the above example, But I want the report to have one line per date, with all three values for that date (ignoring the time).

Any suggestions?

ENTIRE THREAD

Print values from mult recs on same row? Posted by Rog @ 12/28/2010 5:05:42 PM
RE: Print values from mult recs on same row? Posted by Suresh Adhikari @ 12/28/2010 5:27:22 PM