a rep can have multiple claim numbers assigned. So what i would like to do in SSRS is to get the . total claim numbers for each rep example (I am also grouping on REP ) I tried = rowcounts() within the claim number text box, but it is giving a total for each claim i want a total for each REP if the rep has 4 claim numbers assigned , it should total 4 not 1 for each claim example
You need to add a group on the Rep column. Google for how to add subtotals and you will see many examples. For example, this video explains it and walks you through an example.
That's good. Did the video give you any more pointers as to what you might need to do? What I would suggest is to look at that video, do the sample problem they are showing and the compare to what you are doing to see how/why it is different.