Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Martin Krivka
  Where is Martin Krivka?
 
 Czech Republic
 Martin Krivka
 To: anand kulkarni
  Where is anand kulkarni?
 sholapur
 India
 anand kulkarni
 Tags
Subject: RE: 2 tables in one report
Thread ID: 345292 Message ID: 345543 # Views: 34 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Reports and Printers
Date: Thursday, May 24, 2012 8:03:21 AM         
   


> >
> >
> >
> > Ok :)
> >
> >
> > Anyway, these two tables are in relation ? Or they are just a list of sales/purchases ?
> >
> > Martin
>
> Hi Martin,
>
> These tow tables are just simple tables . No relation , No index , No grouping they are just ten records appended tables . :)
>
> regards
> Anand S. Kulkarni
>
> When it rains ... all Birds occupy shelter , but Eagle is the only bird with its capacity to fly over the sky to avoid rains !!!


Just idea:

select "S" as groupID, field1, field2 from sales UNION ALL select "P" as groupID, field1, field2 from purchases order by 1 into cursor repo1


In this case, report need to have 2 columns and be grouped on groupID, where group start on new column.

I know that it is SQL again, but I thing that is not possible to do it with two unrelated tables.

Martin

ENTIRE THREAD

2 tables in one report Posted by anand kulkarni @ 5/22/2012 10:03:09 AM
RE: 2 tables in one report Posted by Martin Krivka @ 5/22/2012 10:40:22 AM
RE: 2 tables in one report Posted by anand kulkarni @ 5/22/2012 11:48:30 AM
RE: 2 tables in one report Posted by Martin Krivka @ 5/22/2012 1:02:50 PM
RE: 2 tables in one report Posted by anand kulkarni @ 5/22/2012 1:07:15 PM
RE: 2 tables in one report Posted by Rahul Moudgill @ 5/24/2012 6:31:00 AM
RE: 2 tables in one report Posted by Jun Tangunan @ 5/24/2012 6:56:20 AM
RE: 2 tables in one report Posted by Martin Krivka @ 5/24/2012 8:03:21 AM
RE: 2 tables in one report Posted by Anil Sharma @ 5/24/2012 7:20:35 AM
RE: 2 tables in one report Posted by anand kulkarni @ 5/24/2012 8:37:46 AM