Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Suresh Adhikari
  Where is Suresh Adhikari?
 New Delhi
 India
 Suresh Adhikari
 To: Rog
  Where is Rog?
 Lawrence
 Kansas - United States
 Rog
 Tags
Subject: RE: Print values from mult recs on same row?
Thread ID: 289139 Message ID: 289142 # Views: 34 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Tuesday, December 28, 2010 5:27:22 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?


In Report's Page Setup, Set:

No. of Columns = 3
Column Print Order = Left to Right

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