Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Total on last detail line
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01014348
Message ID:
01014607
Vues:
18
Hi Cathy:

I know that you are the expert on VFP reporting (I attended some of your presentations at GLGDW), but your solution went over my head. Could you be a little more detailed?

Sorry,

Yossi

>Create a data group on Invoice Number. In the Data Group Footer, print the amount and mark it as SUM, reset on Invoice Number. Then create a Summary band and print the amount and mark it as SUM, reset on EndOfReport.
>
>
>>Hi All:
>>
>>How can I produce a report that has total information on the last detail line?
>>
>>Easy Report to do for invoices with multiple line items:
>>
>>
>>Invoice Number  Amount
>>10001           1,000
>>                2,000
>>                3,000
>>TOTAL           6,000
>>
>>10002           4,000
>>
>>10003           5,000
>>                6,000
>>TOTAL          11,000
>>
>>GRAND TOTAL    21,000
>>
>>
>>This I can't do, unless I run one pass through the file and mark each last line:
>>
>>
>>Invoice Number  Amount  Total
>>10001           1,000
>>                2,000
>>                3,000   6,000
>>
>>10002           4,000   4,000
>>
>>10003           5,000
>>                6,000  11,000
>>
>>GRAND TOTAL            21,000
>>
>>
>>Thanks!
>>
>>Yossi
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform