Post reply

how to display month and year in header of report

  • April 23, 2014 at 11:05 am

    #306772

    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...

  • April 23, 2014 at 12:11 pm

    #1708218

    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.

  • April 24, 2014 at 1:13 pm

    #1708566

    This might be what you're after:

    ="For " + Format(Parameters!startdate.Value, "MMMyyyy"

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply