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