Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: anand kulkarni
  Where is anand kulkarni?
 sholapur
 India
 anand kulkarni
 To: Martin Krivka
  Where is Martin Krivka?
 
 Czech Republic
 Martin Krivka
 Tags
Subject: RE: 2 tables in one report
Thread ID: 345292 Message ID: 345308 # Views: 49 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Reports and Printers
Date: Tuesday, May 22, 2012 11:48:30 AM         
   


> > Hello Expert's
> >
> > If i have 2 tables sales and purchase i have 10 records with both tables . I want to print those tables at time in one report page horizontally . HOw can i ? print this . Is that possible .
> >
> >
> > i.e.
> > -------------------------------------------------------------------------------
> > Sales date Sales amount ============ Purchase date Purchase amoutn
> > --------------------------------------------------------------------------------
> >
> >
> > 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 !!!
>
>
>
> Hi,
> what about this:
> 
> select ;
>   a.id,
>   a.sales_date, a.sales_amount,;
>   b.purchase_date, b.purchase_amount ;
> from ;
>   sales as a, purchase as b;
> where ;
>   a.id = b.id ;
> into cursor repo1
> 
> * and then
> select repo1
> report form ...
> 

>
> Where report contain 4 fields...
>
> Martin

Martin , Thanks , you are right this way it is possible but i want to use two tables as i said in my post . Before this i have made some reports with the technique you posted :) .


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

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