SQLTeam.com | Weblogs | Forums

Total row group within ssrs


#1

I HAVE A SSRS REPORT WITH 4 COLUMNS

REP, CLAIM_NUMBER,LOCATION, DATE

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


#2

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.


#3

i am already grouping on REP


#4

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.