Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
On Entry/On Exit band events
Message
 
À
05/04/2001 21:46:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00492141
Message ID:
00492942
Vues:
20
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform