Hi Friends, Below is my details problem description. I am using SSRS 2005 Chart. I need to display Number on Y-Axis in Billions. Example : 1,000,000,000,000 - Right Now it is displaying this formate on Y-Axis. My requirment is to Display in formate of 1 Bn. How can i display like this on Y-Axis ? If you need more information , let me know. Thanks.

First, normalize your values around zero, so the smallest value is -50 and the largest value is 50. You can do this in the chart control itself, no need to change your dataset. Your values are between 0 and 100, so just subtract 50. Next, under value axis properties -> axis options, set your minimum to -50, maximum to 50, and interval to 50. Finally, under value axis properties -> Number, select Category as "Custom" and enter this in as the custom format expression: ="Large;Small;Medium"

Hi SSRS New Bie Beginner, Just add some more information besides nick 2010's reply. In SSRS 2008 and later version, we could select number format under Category and you check Show values in, you can select Thousands, Millions, or Billions to display numbers using financial formats. For example, if the field value is 1,000,000,000 and you select Billions, the value displayed in the report is 1. If possible, I will recommend you update your SSRS 2005 to SSRS 2008 or R2. For more information about format number please see http://msdn.microsoft.com/en-us/library/dd220510.aspx Thanks, Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

How can we Query to Report Server and Check the Status of that , is it still Running or Locked Out ? Can we write query to access the property of Report Server and it's Status in SSMS ? Thanks.

Hi, Please ask different questions on different thread, if you main question answer has been resolved please mark this thread as "Mark As Answer" too. In that way you WILL get replies faster. Have you tried writing queries using "ReportServer" db from SSMS, please tried it, you might will get your answer in your question itself. Thanks KumarKG