Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sum at my report
Message
De
19/09/2004 09:43:28
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
19/09/2004 02:45:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00943063
Message ID:
00943830
Vues:
17
>hello,
>at the end of my report i sum all totals for all departments
>i need to see at my repoert as under.
>thanks.
>
>                section                totalsalary  department
>                   1                       1000         1
>                   2                       5000         1
>                   3                       2000         1
>
> total for department 1                       8000
>
>                 ...........................................2
>                 ...........................................2
>                                                       .
>                                                       .
> total for department 2
> .
> .
>
>
>best regards.
>m.qasem

I would put the total into a group footer. You don't even need code to add each department; just mark a report field (which you place in the group footer) as "sum".

To create group headers and footers, give the command "Report | Data Grouping". In the group expression, type Department, if that is the name of your field.

Sort your data on department.

Now, every time the Department changes, the information in the report's group header and group footer will be printed.

You can now erase all your previous commands that sum the individual departments.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform