SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 Display my Parameter in mm-yyyy format
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Blessed1978
Starting Member

48 Posts

Posted - 07/17/2014 :  14:47:27  Show Profile  Reply with Quote
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
Constraint Violating Yak Guru

398 Posts

Posted - 07/18/2014 :  09:24:32  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000