locked
How to control Label text in SSRS report RRS feed

  • Question

  • I create SSRS stacked bar chart.The report show like as,

    In Y Axis the account name will show I need to control that label's text. which means I need enough to show first 10 letters from the Account Name.

    For ex:Let Assume the account name is SampleAccountNameABCConsultancy

    I need to show the SampleAcco instead of SampleAccountNameABCConsultancy

    Thursday, November 20, 2014 3:50 AM

Answers

  • In chart data properties click CateGory Groups prerties-general-label .In that label expression use the following expression
        
        =IIF(Fields!accountname.Value="",Fields!accountname.Value,left(Fields!accountname.Value,10))
    • Marked as answer by VijayKumar123 Thursday, November 20, 2014 4:45 AM
    • Edited by VijayKumar123 Thursday, November 20, 2014 4:45 AM
    Thursday, November 20, 2014 4:44 AM