How to total a page group
I have a report paged by user and grouped by department. Some PersoN Budget Dept Billing No | Date | Time | Location | Number | Calling Period | Minutes | Cost 111-111 1/1/2011 7:00am somewhere 222-222-2222 Day 22.2 $.22 Totals For: Some Person ? 22.2 $.22 I have Sum total for Minutes and for Cost. I also want to Total by Calling period so that if Some Person has 8 rows, it will show 8 as the total. How to do this?MCP
February 12th, 2011 3:08am

sorry, my title makes no sense other than since i am paging on each person, i figure that is how is would count rows or somethingMCP
Free Windows Admin Tool Kit Click here and download it now
February 12th, 2011 3:18am

Duh, nevermind. Just realized the have a CountRows function to do this based on a grouping. Just for reference though, the link is http://msdn.microsoft.com/en-us/library/ms156330.aspxMCP
February 12th, 2011 3:43am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics