Post reply

how to convert month from int to character

  • January 27, 2014 at 7:41 am

    #284794

    Hello I have a claim month parameter in SSRS report

    Claim month when I give the value as 5 when I generate the report it has to show May

    How can I write the expression for this in the textbox?

    =Parameters!ClaimMonth.Value

  • January 27, 2014 at 7:55 am

    #1683557

    =MonthName(Parameters!ClaimMonth.Value)

  • January 27, 2014 at 8:02 am

    #1683562

    Thank you so much,it worked..

  • January 27, 2014 at 8:03 am

    #1683564

    Hello I am creating an SSRS report where in the header I am trying to insert a text box with expression;in that expression the date should be july 1,2013 - june 30,2014

    because july to june is one year for us in our company;so july 1 and june 30 are constant for every report;just years will be changing

    how can I subtract previous year ...any help for the expression in order to get that format?

  • January 27, 2014 at 8:14 am

    #1683570

    You can build strings within text boxes, that use parameter values or use part of the current date

    ie.

    = "July, 1st " & YEAR(Parameter.value)-1 & " - " & " June, 31st" & YEAR(Parameter.value)

    or

    = "July, 1st " & YEAR(NOW())-1 & " - " & " June, 31st" & YEAR(NOW())

    The options are endless 🙂

  • January 27, 2014 at 10:11 am

    #1683632

    Thank you..

Viewing 6 posts - 1 through 5 (of 5 total)

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