show data label

Question

hi,

i want to show data label on  my line chart,but only last data label.

i cannot use last in expression as 

=RunningValue(Fields!total.Value,Sum,"Dataset1") in my data field.

how can i get last value

Answer 1

Hey There,

Wouldn't the last RunningValue of your expression (=RunningValue(Fields!total.Value,Sum,"Dataset1")) be same as the Sum of the dataset?

SUM (Fields!total.Value, "DataSet1")

Could you elaborate a little more on your scenario?

Cheers,

IceQB

---

Please mark correct answers :)

Answer 2

ya

but when i put this expression ,it will shows all the data label.i just want last data label.

what condition do i need to put?

Answer 3

Hi Tsql,

Please refer to the steps to achieve your requirement:
1. Add a text-box to your report body and set the visibility property of the text-box to “Hide”, And then add an expression to the text-box like below:
   =Last(Fields!Column.Value, "DataSet1")
2. In the “Series Label Properties” window, click the expression button and type in the expression below:
   =Iif(Fields!Column.Value=ReportItems!Textbox1.Value, "LastValue:" & Fields!Column.Value,"")

The report looks like below:


If you have any questions, please feel free to ask.

Regards,
Charlie Liao

Answer 4

hi,

thanks ,but i am using runningvalue as a expression to show data,

so it showing multiple 78 at the end,as it is cumulative.

any idea how can i show unique value as the end

Answer 5

Hi Tsql,

Thank you for you posting again. If in this case you could change the expression to:
=Iif(Fields!Column.Value=ReportItems!Textbox1.Value, RunningValue(Fields!Column.Value,Sum,"DataSet1"),"")

Now the report looks like below:


Please feel free to ask if you have anything unclear.

Regards,
Charlie Liao