Getting Query output into a Report (VFP) 
Author Message
 Getting Query output into a Report (VFP)

  This might seem like a stupid question, but I haven't seen this mentioned
anywhere in the manuals. I'm trying to take a Query output that has several
summed fields (here's the SQL code):

SELECT Dispatch.driver_no, SUM(Dispatch.payout),;
  SUM(Dispatch.recov_labr), SUM(Dispatch.storage+Dispatch.storage1),;
  SUM(Dispatch.miles1*Dispatch.rate1), SUM(Dispatch.hook_up),;
  SUM(Dispatch.flat_bed), SUM(Dispatch.other),;
  SUM(Dispatch.miles2*Dispatch.rate2), SUM(Dispatch.swap_out),;
  SUM(Dispatch.inv_total);
 FROM "dispatch_database!dispatch";
 WHERE MONTH(Dispatch.call_date) > 1;
   AND MONTH(Dispatch.call_date)<3 = .T.;
 GROUP BY Dispatch.driver_no;
 ORDER BY Dispatch.driver_no

 How do I take the output of this search and dump the results into a Report? It
seems like there should be an easy way to do this, but so far all it seems VFP
wants to include is fields from a table. Just to make it work, I've sent the
SQL output to a table, then I use that table for my report. Isn't there an
easier way?



Tue, 25 Aug 1998 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Getting Landscape output in Report Writer -Reply

2. Getting Landscape output in Report Writer

3. vfp report output

4. VFP Report output to WinWord 6.x

5. VFP report output to RTF?

6. VFP Report Writer - Output HTML?

7. Getting query output to a file?

8. Outputting a Query Answer table into a report

9. Report from Query output

10. Problem with SQL Query Designer output to Report

11. Query output to Report

12. Query Designer + Reports (VFP 3.0)


 
Powered by phpBB® Forum Software