Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Every person that you meets knows something that you don't; learn from them
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

13
September

How Do I Format the Y-axis on a Percentage Stacked Chart in SQL Reporting Services 2008?

A number of clients have recently asked me "How Do I Format the Y-axis on a Percentage Stacked Chart  in SQL Reporting Services 2008?" To show the correct percentage scale.

When the Numerical Format Percentage is applied to the Y - axis, it displays the scale as:

0%, 1000%, 2000%, 4000% etc,

instead of :

0%, 10%, 20%, 40% etc

Solution:

The only way to get SQL Reporting Services 2008 to display the correct scale is to create a custom numerical format.

  1. Right click on the Y-axis of the chart

  2. Select the Vertical Axis Properties menu option

  3. In the Vertical Axis Properties dialog box, select the Number option

  4. Click on the Custom option

  5. Enter the following syntax in the Custom Format text box:

    #0.##\%

  6. Press the OK button


If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


1

david

19
October
Excellent, thank you, from Costa Rica
2

Julia

21
October
No Problems David, glad I could help Julia
3

Kishore

12
December
Thank you guys. You people solved my problem too. Thank a lot.
4

Bruno Willian

28
February
Work like a charm, you are a genius!
5

Chris P

13
August
Thanks for this - helped me today!
6

jenebie

04
September
This is great. I've been working on this for a couple of hours, I thought it will work by tweaking the SP, but your custom code is the answer. Thanks for sharing this!
7

Narayana

20
July
Thanks for this
8

Baba

19
November
Thank you :) this really helped

MAKE A COMMENT

Name *

Email Address *

Comment *