Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Month name not appearing in bar chart

Author  Topic  topher Starting Member 7 Posts Posted - 2007-02-13 : 19:27:57 Hi, I have created a standard bar graph with the date appering under each column in date format. I am trying to format the column lables so that it only shows the year and month. So far I have been able to display the year and the month in integer format (using month(fieldname) format), but when I try to use monthname(field) there are no lables at all under the columns. The expressions I have used are: =Year(Feild!StartDate.Value) & " - " & Month(Field!StartDate.Value) This brings back the format: 2007 - 2 (for month of Feb). =Year(Feild!StartDate.Value) & " - " & MonthName(Field!StartDate.Value) This is what is bringing back an empty column label. Ultimately I am after the format of: 2007 - February. I have tried expanding the graph and changing the font to 8pt in case the label was too big for the column, but this has not helped. If anyone can see what is going wrong, any help would be greatly appreciated. Thanks.