Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Incrementing fields in group headers
Message
De
12/04/2000 12:35:59
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00357742
Message ID:
00358768
Vues:
18
Hi,
Create 2 counter, e.g.
1. Item Counter for a Group
Counter1 = Counter1 + 1
(group by group header)
e.g. if we use counter 1, it will show like below:
Cntr1
1 PRODUCT A
2 Item1
3 Item2
1 Product B
2 Item1
3 Item2

2. Counter for group header
Counter2 = IIF(Counter1=1,Counter2+1,Counter2)

Now Use Counter2 for the group header. I already used this method
in my report.

e.g.
Cntr2 Cntr1
1 1 PRODUCT A
1 2 Item1
1 3 Item2
2 1 Product B
2 2 Item1
2 3 Item2

Then,just use the "print when" option for counter2, and select
option for "dont print duplicate values". Dont use counter1.
So the report will be like this.

Cntr2
1 PRODUCT A
Item1
Item2
2 Product B
Item1
Item2

The End. That's all.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform