Menu
I am trying to display selected month, current month and last month names on my report. I am using
=Parameters!Month.Label ---> Jun 2016(selected)
=Format(Now(), "MMM") & " " & Format(Now(), "yyyy") ---> Dec 2016 (current)
=Format(DateAdd("M", -1, Now()), "MMM") & " " & Format(Now(), "yyyy") ---> Nov 2016 (last)
But I need something like(JUNE 2016, DECEMBER 2016, NOVEMBER 2016 ). Any help would be appreciated. Thank you so much in advance.
587
SSRS is case sensitive and you can ensure that the available values in the report parameter are formatted consistently using the functions above.
SSRS Case statement is basically one of the widely used program flow statements. It allows us to control the program flow and it's output when we have more than two flows/conditions to set. In other words, a case statement is an optimized version of a nested If statement.
First, add a Row Group which is a Parent of the existing top level group. In the Group By expression, enter =CEILING(RowNumber(Nothing)/50) where 50 is the number of records to be displayed per page. Be sure to leave the group header & footer boxes unchecked.
UCase Function
=UCase(Format(Now(), "MMM") & " " & Format(Now(), "yyyy"))
=UCase(Format(DateAdd("M", -1, Now()), "MMM") & " " & Format(Now(), "yyyy"))
166
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
