locked
Int Parameter RRS feed

  • Question

  • User-1499457942 posted

    Hi

       I am displaying values in Month Parameter as 1,2,3,4,5,6,7,8,9,10,11,12.

    In a report i want to display its Label Value.

    Thanks

    Monday, December 18, 2017 10:30 AM

All replies

  • User2103319870 posted

     I am displaying values in Month Parameter as 1,2,3,4,5,6,7,8,9,10,11,12.

    In a report i want to display its Label Value.

    if you want to convert number to Month Names then use the below expression in your report. Change the Table2Column as per your table column name

    =Switch(Fields!Table2Column.Value=1,"January",Fields!Table2Column.Value="2","February",Fields!Table2Column.Value="3","March",Fields!Table2Column.Value="4","April",Fields!Table2Column.Value="5","May",Fields!Table2Column.Value="6","June",Fields!Table2Column.Value="7","July",Fields!Table2Column.Value="8","August",Fields!Table2Column.Value="9","September",Fields!Table2Column.Value="10","October",Fields!Table2Column.Value="11","November",Fields!Table2Column.Value="12","December")

    Monday, December 18, 2017 7:44 PM
  • User347430248 posted

    Hi JagjitSingh,

    i can see that other community member already suggested to use Switch. you can also do the same thing using IIF.

    below is an example for the same.

    <-- It will give you the full name of the month such as January.
    
    =IIF(Fields!MonthNumber.Value = 1, "January", IIF(Parameters!Month_Number.Value = 2, "February", ...)))))))))))

    Reference:<sub></sub><sup></sup>

    SSRS - How to convert month number into month name

    CONVERTING MONTH NUMBER TO MONTH NAME IN REPORTING SERVICES

    Regards

    Deepak

    Tuesday, December 19, 2017 2:02 AM