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 2012 Forums
 Analysis Server and Reporting Services (2012)
 Display my Parameter in mm-yyyy format

Author  Topic 

Blessed1978
Yak Posting Veteran

97 Posts

Posted - 2014-07-17 : 14:47:27
How to format my parameter that I use a a header to display in MMM-yyyy format. I tried going to text box properties to change it but it still shows up in date time format

I want it to show the date as. MM-yyy. So MAR-2013

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-07-18 : 09:24:32
see here: http://technet.microsoft.com/en-us/library/dd220510(v=sql.110).aspx

and here: http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

You need an expression. Something like (untested)


=Format(Parameters!MyParameter.Value,"MMM-yyyy")
Go to Top of Page
   

- Advertisement -