This is a migrated thread and some comments may be shown as answers.

How to count the occurrences of a textbox?

1 Answer 181 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Tyler
Top achievements
Rank 1
Tyler asked on 11 Jul 2012, 04:04 PM
Is it possible to place a text box in a group footer and then count the number of times the text box is generated? I am trying to count the number of groups that occur. When I use the Aggregate function Count() on the Field that is grouped I get a count of the individual line items, not the group itself. Any thoughts?

1 Answer, 1 is accepted

Sort by
0
Hadib Ahmabi
Top achievements
Rank 1
answered on 12 Jul 2012, 03:04 PM
Try this:
=Exec('group_name', Count(1))
it should be placed in the header/footer of the group which items you want to count.
Tags
General Discussions
Asked by
Tyler
Top achievements
Rank 1
Answers by
Hadib Ahmabi
Top achievements
Rank 1
Share this question
or