January 27, 2014 at 7:41 am
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
=MonthName(Parameters!ClaimMonth.Value)
January 27, 2014 at 8:02 am
Thank you so much,it worked..
January 27, 2014 at 8:03 am
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
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
Thank you..
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply