Solved

SSRS Graph X-Axis number to month name

Posted on 2016-07-27
4
24 Views
Last Modified: 2016-08-02
Hi all, I'm having a problem changing the X-Axis labels from a number to text; such as 1 to January, 2 to February, etc...
I've tried a number of things but the best I can get is that each number is change to text but it is the same text.  So 1,2,3,4,5,6, etc.. are all showing January.  I've create =Switch expressions and used the =MonthName(Fields!MONTH.Value, True) in the Format applet which shows all pints as "Jan".

I'm using SQL 2012.
Any help would be wonderful.
Thanks,
John.
0
Comment
Question by:Thunder724
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 26

Expert Comment

by:Chris Luttrell
ID: 41732336
Try one of these:
=Format(Fields!MONTH.Value,"MMMM")
or
=Switch(Fields!MONTH.Value = 1, "January",
                   Fields!MONTH.Value = 2, "February",
                   Fields!MONTH.Value = 3, "March"................)
this came from http://www.sql-datatools.com/2015/05/ssrs-how-to-convert-month-number-into.html
0
 
LVL 4

Accepted Solution

by:
Thunder724 earned 0 total points
ID: 41733047
I figured it out in part.  I had to make sure the Category was set and that Axis range and intervals where set correctly; being Side Margins: Auto, Interval: 1, and interval type: Default.
That said I included a column in my stored procedure to be the textural name of the month too.

I am having difficulty figuring out one other graph in the same regards because the series is an expression not a column.
0
 
LVL 4

Author Comment

by:Thunder724
ID: 41733067
I got the last piece done the same as above; just had a query issue.
0
 
LVL 4

Author Closing Comment

by:Thunder724
ID: 41738726
I figured it out in a much different way presented.  I also had tried the suggestion provided prior to asking this question and it did not work because the answer was not related to a graph; but an expression for non graph objects.
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

761 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question