Hi All,

Thank you for taking time to read my Post. May I have your insight on my below challenge.

DESIGN:

I have designed a Line Chart in SSRS 2008 R2 BIDS.

The Chart dataset has the following Columns (calendar Year, Month, Values) returned from an MDX query.
The column 'Values' is the measures and the 'calendar Year' & 'Month'  columns are the Dimesions.

I have restricted or filtered the MDX query to return only 'Values' for 'Months' under 'Calendar Year' 2013

PROBLEM:

I would like to return Months under the SSRS Line chart Horizontal Axis (Category Groups).The problem is I am unable to
return these Months in Month Names.
When I set Horizontal Axis Interval properties to =Str(Fields!Month.Value) and Interval Type 'Months'
The Months are returned in Numeric format e.g '01/01/2013' instead of  'JANUARY'  see Below

Is anyone familiar with a workaround that I can implement to return Months in Month Names.

Re