sql server reporting services: Hey all,

I need to calculate % bases on 2 columns (Col1 and Col2), and my result that
I want is in Col3(%). Please see the layout below. Is that possible?

Col1 Col2 Col3(%)
-------------------------------------
A 5 50%
B 2 20%
C 3 30%
D 0 0%
Total 10 100%

Thanks in advance!


Calculate Percentage

[quoted text, click to view]

Assuming you have Tabular report Design,
Expression in Col3 can be -
= Reportitems!textbox2.value/Reportitems!textbox34.value
and Format field with %
(My formula syntax can be wrong, use textbox reading syntax)