Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to display month and year in header of report Expand / Collapse
Author
Message
Posted Wednesday, April 23, 2014 11:05 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 3:46 PM
Points: 76, Visits: 156
Hello,
I have a parameter called start date (@startdate) and I f I give the date as '10/1/2013'

when I click on preview report I have to get as "For Oct 2013" on the header

how to write the expression for this.

I have taken a text box and I written as = "For" +


Any help please...
Post #1564390
Posted Wednesday, April 23, 2014 12:11 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 5:53 PM
Points: 143, Visits: 316
something like this should work
= "For " & MonthName(Month(Today())) & " " & YEAR(Today())



Good Luck :) .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
Post #1564410
Posted Thursday, April 24, 2014 1:13 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:28 PM
Points: 184, Visits: 8,849
This might be what you're after:

="For " + Format(Parameters!startdate.Value, "MMMyyyy"
Post #1564837
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse