Post reply

How to display name before value

  • May 22, 2009 at 7:43 am

    #384640

    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

    #999052

    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