Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to make this Total
Message
 
 
À
15/01/2004 20:55:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00867338
Message ID:
00867354
Vues:
23
Hi, João

>
> Tax    Amount
>+---+----------+ .....
> 19     30,32
>  5      0,50
>  8      0,55
> 19     30,32
>  8      0,50
>  0      0,00
> 19     30,32
>+----+---------+
>
>
>In the footer page i only want to print once, the 19 Tax, the 8 Tax, etc,.

You have to do this with another cursor where you do:
select tax, sum(amount) as TotalPerTax from Table ;
  group by tax ;
  into cursor FooterTotals
Then, to print it, if you know there would be a certain maximum taxes, you can put the cursor content in a string and put a fixed-height field.

There are other solutions but they are too complex, as they involve doing a union, a group in the report and conditional fields...

Hope this helps,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform