Having Problem with data label in graphics
I have this Graphic and im triyng to put the 7.15% only in the last line is there any way i can erase the other numbers i recieve this number as a parameter from the Stored Procedure, it seems to repeat the number for every month... http://i53.tinypic.com/10rlpop.jpg
March 26th, 2011 12:49am

Hi, There is one wrokaround to do this. I have tried this on SSRS 2008 R2 or RB 3.0. As your line looks like a aveage line, you can add a expression for substracting the running value of sum from total sum and only display the lable when value is 0. Steps 1) Select any of line lables 2) Right Click and select "Series Lable Properties" 3) Add following expression for Lable Data =IIF(RunningValue(Fields!per.Value,sum,"DataSet1") - sum(Fields!per.Value,"DataSet1") =0, CSTR(Sum(Fields!per.Value,"DataSet1") / CountRows("DataSet1")),"") Note:- Change the field name and data source value in above expession - Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
March 26th, 2011 11:57am

I't Worked flawlessly, Thank You!
March 28th, 2011 4:14pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics