Count Detail

[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

 

[Marshall Barton]

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)..??

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

 

[Dan @BCBS]

That did it thanks...

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