none
SSRS Line Chart Labels

    Question

  • Does anybody knows how to show  only the last data point label on a line chart

     

    Thanks

    bidev1

    Monday, May 16, 2011 2:19 PM

Answers

  • Hi bidev1,

    Thanks for your question, we could achieve this requirement in Reporting Services by typing in a expression in label's visible property, steps are:

    1. Show data label.

    2. Click the data label, and then press F4 button to open the property window.

    3. Find out the visible property and then type in below expression =IIF(Fields!Category.Value="Lastvalue",True,false)
        Note: Please replace the Lastvalue based on your report.

    Then all the data label will hide except the last value.

    Thanks,
    Challen Fu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, May 17, 2011 4:40 AM
    Moderator

All replies

  • Hi bidev1,

    Thanks for your question, we could achieve this requirement in Reporting Services by typing in a expression in label's visible property, steps are:

    1. Show data label.

    2. Click the data label, and then press F4 button to open the property window.

    3. Find out the visible property and then type in below expression =IIF(Fields!Category.Value="Lastvalue",True,false)
        Note: Please replace the Lastvalue based on your report.

    Then all the data label will hide except the last value.

    Thanks,
    Challen Fu


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, May 17, 2011 4:40 AM
    Moderator
  • Hello Challen Fu,

    Thanks for the reply, seems the method you gave me will only be possible if i could determine what the lastvalue will be

     

    Thanks

    bidev1

    Tuesday, May 17, 2011 8:41 AM
  • Hi bidev1,

    It is true you have to get the last value of your dataset, actually, you could create a hiden parameter whose value is just the last value, then you can set visible property using this expression =IIF(Fields!Category.Value=Parameters!Para.value,True,false) 


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, May 25, 2011 1:51 AM
    Moderator