reporting services - SSRS - Sum value and porcent -
i have problem in report
i have table this:
description | mounth [description] | [sum(valeur)] porcent when execute have
descr m1 m2 m3 m4 m5 m6 m7 m8 m9 m10 desc1 x1 x2 x3 x4 x5 x6 x7 x8 x9 x10 desc2 y1 y2 y3 y4 y5 y6 y7 y8 y9 y10 %%%% p1 p2 p3 p4 p5 p6 p7 p8 p9 p10 in porcent row need have porcent of desc1 value / desc2 value
example: p1 = y1 / x1
p2 = y2 / x2 ...
how can in 1 look in textbox porcent of table?
thanks help
do know how utilize reportiteams??? if yes 1 thing create 2 little single cell tables. , assign desc1 field 1 table , desc2 table. in table field want show p1 = y1 / x1 write below code. =reportitems!tablix1 (which has value of desc2) / reportitems!tablix1 (which has value of desc1)
it work sure. still if face issue allow me know. can mail service me on dilipc01@gmail.com , remember have used 2 single cell tables, create size of tables very small, create font size 1 , color white not visible in report, do not seek hide 2 little tables else reportitems property not work. if want more help please leave comment help you.
regards, dilip chauhan.
reporting-services sum
No comments:
Post a Comment