Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Incrementing fields in group headers
Message
From
12/04/2000 12:35:59
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00357742
Message ID:
00358768
Views:
17
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform