Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to add Subtotal and Groupby ?
Message
De
08/07/2011 07:16:09
 
 
À
08/07/2011 06:43:12
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Divers
Thread ID:
01517672
Message ID:
01517673
Vues:
55
>Hi,
>
>How to convert the EXCEL VBA code of the subtotal and groupby to VFP9 ?
>
>    Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(3), Replace:=True, PageBreaks:=False, SummaryBelowData:=True
>
>
>
>Please advise.
>
>Thanks.


Open the VBA editor in Excel.
Mark Subtotal and press F1.
That will open Excel VBA help and you will see the positioned parameters, and will see how you could use this method in VFP.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform