Count Detail

  • Thread starter Thread starter Dan @BCBS
  • Start date Start date
D

Dan @BCBS

My report has a text box with "=Count(1)" to produce a count at the end of
each sort in the detail.

The detail is sorted Three ways: County, Member then Doctor. But some
members have more than one doctor ( member #123 has 2 doctors, member #999
has only one doctor) in the detail.

How can I change the =Count1 to just count the member per county?
Because it's counting all the lines in the detail (all the doctors)..??

Thanks
 
Dan @BCBS said:
My report has a text box with "=Count(1)" to produce a count at the end of
each sort in the detail.

The detail is sorted Three ways: County, Member then Doctor. But some
members have more than one doctor ( member #123 has 2 doctors, member #999
has only one doctor) in the detail.

How can I change the =Count1 to just count the member per county?
Because it's counting all the lines in the detail (all the doctors)..??
Click to expand...


That's the way Count works. What you need is a text box
(named txtMemCnt) in the member group header or footer
section. Set ifs control source expression to =1 and
RunningSum to Over Group. Then the County group footer text
box can display the number of members by using the
expression =txtMemCnt
 
That did it thanks...

Marshall Barton said:
That's the way Count works. What you need is a text box
(named txtMemCnt) in the member group header or footer
section. Set ifs control source expression to =1 and
RunningSum to Over Group. Then the County group footer text
box can display the number of members by using the
expression =txtMemCnt
Click to expand...
 
Back
Top