Clever Geek Handbook

Reporting Services Matrix Percentages

Reporting Services 2000 SP2

I have a matrix displaying the number of employees

                 Business1      Business2      Business3
StartBefore99    9              14             4
StartAfter99     30             20             34

I would like to display percentages like

                 Business1      Business2      Business3
StartBefore99    9 (23%)        14 (41%)       4 (10%)
StartAfter99     30 (77%)       20  (59%)      34 (90%)

Any suggestions? I could do it in SQL, but would rather do the expression in RS.

Greetings

+1


source to share


2 answers


What you can do is use an expression such as

= SUM (Fields! StartBefore99.Value) + FORMAT (Sums! StartBeforeValue99) / Fields! Total.value, 2)



Total is the field that you calculate in your dataset. It's been a while since I touched RS, but this is basically the code I wrote earlier. You need to do the SUM which I count from my matrix. If it were just a table, it would be a little simpler in that you don't need to sum.

0


source


Thanks a lot Josh

This is what I ended up using



=Sum(Fields!StartBefore99.Value) & " (" & Format( ((Sum(Fields!StartBefore99.Value)/Fields!TotalNumberOfPeopleInPlant.value)*100), "0")  & "%)"

I did TotalNumberOfPeopleInPlant in SQL and returned a value with each row .. in the future I will be looking into this bit in RS!

0


source






More articles:


All Articles