Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Incrementing fields in group headers
Message
 
 
To
12/04/2000 12:35:59
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00357742
Message ID:
00358791
Views:
10
Hi Adzalan,

I haven't tested it, but it seems to work. Thanks a lot.

>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.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform