Hi friends, I am working on a report in SSRS 2008, In report(below) axis is from 0-80. The report has query having certain parameters and conditions. What I want is: In axis, i should append symbol say '$' or '%' or '@', etc based on a condition say employeeid. e.g. for employeeid = 1 axis should display as: 0$, 20$, 40$, 60$, 80$ for employeeid = 2 axis should display as: 0%, 20%, 40%, 60%, 80% I can do this at database level, but my requirement is to put this on report level. Could anyone help me to achieve this...... many thanks Fig: for reference only=================================== Rahul Vairagi ========================================== My Blogs: www.sqlserver2005forum.blogspot.com

Hello Rahul- I think if you select the axis, go to the properties window --> Interval --> and then select one of the Interval subcategories for building an expression, you should be able to accomplish what you are trying to do.Bonediggler

Hi Rahul Vairagi, 1. Right-click one of those Data Labels, and click Series Label Properties. 2.In the Series Label Properties dialog, structure the following expression for Label data: =Iif(Fields!employeeid.Value=1,sum(Fields!amount.value) & "$",Iif(Fields!employeeid.Value=2,sum(Fields!amount.value) & "%",sum(Fields!amount.value))) More information about Iif function:http://msdn.microsoft.com/en-us/library/ms157328.aspx Thanks, Lola Please remember to mark the replies as answers if they help.