Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using MonthName with Parameters

Status
Not open for further replies.

fcoley

MIS
Aug 3, 2011
2
US
I am a newbie to SSRS and like what I have learned so far.
Is there a way to get the month and year by using monthname with a parameter? I have the below report heading:

Global_HeadCount and I would like for the end result to look like this:

"Global_HeadCount: September 2011", based on the paramter being passed in. In other words, whatever date is entered take the month and year and add that to the report header.

Is there anyway to accomplish that or should I say how can I accomplish that?

Thanks,
 
Try this for the expression:

Code:
="Global_HeadCount:  " & FORMAT(Parameters!YourDateParameter.Value, "M yyyy")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top