• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Count of Grouped Records

I have a sales report that groups sales by SLS_REP and TKT_NO.
I would like to have a count of the number of Tickets from each sales rep in the SLS_REP Footer. I presently get a count of the number of items sold on each ticket in the TKT_NO Footer and a total of items sold in the SLS_REP Footer. This is good information but I would also like to get a count of the number of tickets per SLS_REP.

Thanks,
Ward
0
draw58
Asked:
draw58
  • 2
  • 2
1 Solution
 
IrogSintaCommented:
Add an invisible textbox in your SLS_REP detail section and call it txtCountSLS.  Insert "=1" in its ControlSource (without the quotes) and change its RunningSum property to Over Group.
Then add a textbox to your SLS_REP footer section with "=txtCountSLS" in its ControlSource.
0
 
draw58Author Commented:
Thanks,
That worked great! Could you please tell me how I could have a grand total in the report footer?
0
 
IrogSintaCommented:
Same procedure.  Add another invisible textbox in the same section as before but this time its RunnungSum property should be Over All.
0
 
draw58Author Commented:
Thank You!
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now