Reputation: 404
There is a matrix I have like:
id name score
1 A 5
2 B 5
1 A 4
4 C 2
2 B 4
What I am doing is to grouping by the matrix based on id and name and sorted decreased in ssrs 2008 rdl and the output becomes:
id name score
1 A 9
2 B 9
4 C 2
What I need to do is to repeat the column header before each group by like:
Score:9
id name
1 A
2 B
Score:2
id name
4 C
I could not find how to do it. I appreciate if someone helps. Best regards.
Upvotes: 0
Views: 250
Reputation: 690
Expression on 1st row should be : ="Score : " + CStr(Fields!score.Value)
Then your table design should be like this:
Upvotes: 0