How to Show the Vertical Axis in terms of Lakhs in BAR CHART,SSRS Report
Hi all, I have the created the bar chart report using SSRS. Here i can able to display the each columns in terms of lakhs and expression is shown below. ="Rs "& (round(Fields!value.Value/100000,2))&" Lakh". But how to display vertical axis in terms of Lakhs. Please refer below chat. Please let me know how to display the vertical axis in terms of lakhs. Gangadhar
October 1st, 2012 1:21am

Hi Gangadhar, Put the expression =round(Fields!value.Value/100000,2)) in series properties under value filed. The other way is create a calculated filed lets say Calc_Value in your dataset and use this expression=round(Fields!value.Value/100000,2)) Now use this calculated field Calc_Value everywhere as per your requirement. Aftab Ansari
Free Windows Admin Tool Kit Click here and download it now
October 1st, 2012 4:27am

Hi Gangadhar, In Reporting Services, we can customize the output format for the chart data label. However, the value axis or Y-axis of the column chart is used to display numeric data values. So, it is not support displaying the string type value on the Y-Axis. Regards, Fanny LiuFanny Liu TechNet Community Support
October 1st, 2012 5:29am

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

Other recent topics Other recent topics