Karenros


Hi

Is it possible to specify the last value as a data label on a line graph...

Regards

Karen




Re: is it possible to specify the last value as a datallabel on a line graph

FLHTCUI - Arizona Harley Rider


=Last(Fields!YourFieldName.Value)







Re: is it possible to specify the last value as a datallabel on a line graph

Karenros

thanks i tried that and i gave that expression in the point label but it shows at all the point. can i just have the value of =Last(Fields!YourFeildName.Value) show up on the report where the graph ends.






Re: is it possible to specify the last value as a datallabel on a line graph

FLHTCUI - Arizona Harley Rider

=Iif(Fields!YourFieldName.Value < Last(Fields!YourFieldName.Value, "YourDataSetName"), "", Fields!YourFieldName.Value)






Re: is it possible to specify the last value as a datallabel on a line graph

Karenros

Where should i give this expression





Re: is it possible to specify the last value as a datallabel on a line graph

FLHTCUI - Arizona Harley Rider

What What do you mean "Where should i give this expression "

Put it to the "Point Labels / Data label:" selection in the "Edit Chart Value" dialog box.

If you have any problems let me know. . .






Re: is it possible to specify the last value as a datallabel on a line graph

Karenros

yeah i did it, but i am getting that value at every point ... which i dont want i just want it at the end.....at the last plot value





Re: is it possible to specify the last value as a datallabel on a line graph

FLHTCUI - Arizona Harley Rider

Try this:

=Iif(Fields!YourFieldName.Value < Max(Fields!YourFieldName.Value, "YourDataSetName"), "", Fields!YourFieldName.Value)

Use MAX instead of LAST






Re: is it possible to specify the last value as a datallabel on a line graph

Karenros

No it doesnt work




Re: is it possible to specify the last value as a datallabel on a line graph

FLHTCUI - Arizona Harley Rider

It works every time on my line chart. I wish I could have helped. Stay with it, I'm sure the answer is out there.






Re: is it possible to specify the last value as a datallabel on a line graph

Karenros

thanks it ok... we put a Text box in it and i am showing the last(value)

thanks a lot for your help





Re: is it possible to specify the last value as a datallabel on a line graph

Karenros

I can get it but its showing up three time.....




Re: is it possible to specify the last value as a datallabel on a line graph

FLHTCUI - Arizona Harley Rider

Once again try this:

=Iif(Fields!YourFieldName.Value = Last(Fields!YourFieldName.Value, "YourDataSetName"), Last(Fields!YourFieldName.Value, "YourDataSetName"), "")

It struck me that my line graph only grows larger and never falls. Anyway try this. . . .






Re: is it possible to specify the last value as a datallabel on a line graph

Karenros

yeah that what i ended up doing... thanks a lot