Int Parameter

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

Answer 1

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")

Answer 2

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:

SSRS - How to convert month number into month name

CONVERTING MONTH NUMBER TO MONTH NAME IN REPORTING SERVICES

Regards

Deepak