May 22, 2009 at 7:43 am
Hi ,
I want to display name for that value.......for example
coverage type of B=Sum(IIF(Fields!Coverage_Type.Value = "B",1,0))
How to display "coverage type of B" in front of the value......
Thanks
raghu
May 22, 2009 at 11:42 am
Unless I am missing something, put this in the text box:
="Coverage Type of B: " & Sum(IIF(Fields!Coverage_Type.Value = "B",1,0))
Now, I wouldn't do it this way because you lose the ability to format the columns independently. I would use two text boxes, the first one would have the text in it - set to right-align, the next one to the right would have the calculation with the appropriate numeric formatting and also aligned right.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply