Solved

SSRS Graph X-Axis number to month name

Posted on 2016-07-27
4
14 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
  • 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS set number of in tablix 5 50
SSRS Dynamic Date Parameter 25 257
Report Builder 3.0 3 27
Need a SQL Server 2014 plug-in to scan the DB schema 4 20
Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

863 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now