Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
On Entry/On Exit band events
Message
 
To
05/04/2001 21:46:01
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00492141
Message ID:
00492942
Views:
19
Personally, the way I would handle this would be to build a cursor of all the invoice totals you need BEFORE you run the report.

So...

SELECT invoice,SUM(dollars) AS invdlrs,CNT(*) AS numlines ;
FROM invoices ;
GROUP BY 1 ;
INTO CURSOR invtots

INDEX ON invoice TAG invoice

SELECT invoices
SET RELATION TO invoice INTO invtots

Now in the report, you can just reference invtots.invdlrs for the total dollars in the invoice at any time you're processing that invoice.

--Brad
Previous
Reply
Map
View

Click here to load this message in the networking platform