April 28, 2015 at 2:55 pm
Hi
Hope to ask this correctly...
I have a report which display clients and up to 4 different programs they can be in
Output looks like :
Client Name prog1 prog2 prog3 prog4 Total
Client Name............ x x 2
Client Name 2 x x x 3
....
So I can get the total by clients grouping on client and =count(Fields!Prog.Value) where prog contains the program in the total field
I can get counts by program in the total =Count(Fields!Progr1.Value)
Prog1 = 44
prog2 = 33
etc..
What I cant get is a count by number of programs a client is in ..
I'd like a total like...
Clients enrolled in 1 program = 33
Clients enrolled in 2 programs = 43
etc....
So in the above 2 clients
the total would look like
Clients enrolled in 1 program = 0
Clients enrolled in 2 programs = 1
Clients enrolled in 3 program = 1
Clients enrolled in 4 programs = 0
Thanks
April 28, 2015 at 3:13 pm
did a bit of research and found running value
Came up with : =runningvalue(count(Fields!Prog.Value),sum,nothing)
Which gives a grand total of number of programs all clients are in ..
is it possible to do something like
=runningvalue(count(Fields!Prog.Value)=1 ,sum,nothing) , so it counts only clients with one program ,
then do the same for 2,3 and 4 ?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply