Special Field "Group number" not numbering properly. 1

[rleyba828]

Hi Team,

Just a quick Crystal Reports XI question on the "Group Number" field. This is related directly to my previous post (

http://www.tek-tips.com/viewthread.cfm?qid=1667796)

below.

The issue is regarding cascaded groupings --> I have a top level group on ChangeNumber and within that Group a 2nd level group called Firewalls. The issue is the "Group Number" counter keeps numbering on the cascaded (Group #2) count and not its top level group count.

Example:

ChangeNumber           Firewall         Router
1    0000111           Firewall-A
                       Firewall-B
                       Firewall-C
                       Firewall-D

5    0000112           Firewall-A        Router-A
                       Firewall-C
                       Firewall-E
8    0000113           Firewall-B

It should be:

ChangeNumber           Firewall         Router
1    0000111           Firewall-A
                       Firewall-B
                       Firewall-C
                       Firewall-D

2    0000112           Firewall-A        Router-A
                       Firewall-C
                       Firewall-E
3    0000113           Firewall-B

Although I keep adding the Special Field "Group Number" to the top level group, it still keeps picking up the 2nd level one. What would be the best way to fix it?

Thanks very much.

 

[lbass]

Insert a running total instead that does a distinctcount of your group #1 groupfield and place it in the group header #1.

-LB

 

[rleyba828]

Great! Works perfectly. Thanks very much.