Iíve cruised the Forum first trying to find an occurrence of what Iím attempting and canít seem to find it.
The goal is to count the number of occurrences of a number in Group Header 2. The report layout looks like this:
This is where I want to count the number of CNoís that appear in GroupHeader2 for each ProductNo in GroupHeader1
As always, Iíve tried a number of unsuccessful variations using the =Count([ ?? ]) combination in GroupFooter1, but the number always includes the number of lines in the Detail Section as well as the GroupHeader2 Section.
Would appreciate any help on this,