>Hi, I am having the hardest time getting a count of a group in the summary band of my report. The group is based on an expression of three different fields concatenated. I've created a variable, set to the expression and count (as well as sum) set on, as well as placing the Reset to the Group (and to the Report.) Then I've placed the field in the header, footer, and summary bands and it always shows totol detail lines and not total groups. I have tried all sorts of variations of the above. I would be pulling my hair out, but theres barely any left. Help.
Build a group on the concatentation of the three fields. Then create a field expression of "1234" with the count button checked, reset on the concatentation.
--Todd Sherman
-Wake Up! Smell the Coffee!