Want to show all values in X-axies of a SSRS chart
I' am Using SSRS 2008, in my chart's X-axis it is showing "A0 A2 A4 A6 A7 A8 A10 ......." instead of " A0 A1 A2 A3 A4 A5 A6......." can any one suggest me to over come this issue...Thank's in advance....
April 21st, 2009 4:25pm

Go to CHART -> Properties -> X-Axis tab In Major Gridlines(Left hand side)select Interval : 1ScaleMinimum box - A0Maximum box - your maximum desired value.Hope it helps Thanks a bunch ! Sweta
Free Windows Admin Tool Kit Click here and download it now
April 21st, 2009 4:42pm

Thank you swetha, swetha i' am using SSRS 2008 and one more thing is i'am a column for X-axies from database lets take Cust_name as example.... if there are 10 names, incatergory field (X-axies), here for me it is showing 5 cust_names in catergories field (X-axies)......
April 21st, 2009 5:17pm

I use 2005 and assume 2008 wud b having more advanced features....so not sure whats going wrong with this simple req of urs..I tried to simulate your req by preparing a CHART having Manufacturers in X-axis and Sales in Y-Axis.Its working all fineeven whenthere are around 40-45 odd manufacturer names in my Chart.Just try to fullyexpand the area of your chart....Thanks a bunch ! Sweta
Free Windows Admin Tool Kit Click here and download it now
April 21st, 2009 5:55pm

ok fine sweta thank you very much, i'll try again according to what u said.....
April 22nd, 2009 6:43am

To enable all of the labels to display, you can set the axis interval = 1 in the property pages. Alex has posted a blog on this at blogs.msdn.com/alexgor. -SeanProgram Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2009 6:46am

Hi sean,i did what u said its working fine.....thank you very much
April 22nd, 2009 9:18am

nice good also got ans from this block and find in VS 2008 R2 right click horizontal Axis properties and in Axis option on top and in interval where u see default "Auto" just write =1 will display all labels very fine thank for the people for posting right answers.............Eric
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2010 9:30am

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

Other recent topics Other recent topics