SSRS dynamic text for the field

Hi, I have a field "MonthName", and I want the month name show with * if it is a current month.
i.e. the current is month is April, in ssrs table, it will show April *. For the past month, still shows the regular month name, like January , February , March.
I have created the expression for the field, I know it is not correct, Can some one help me to correct it. thanks a lot.

=iif (Fields!MonthName.Value= monthname(today()), "monthname(today())&"*"","Fields!MonthName.Value")
tanj1035Asked:
Who is Participating?
 
Feridun KadirPrincipal ConsultantCommented:
Try something like this, I split this out over several lines to make it easier to read

=
IIf (
MonthName(month(today()))=Fields!MonthName.Value,
Fields!MonthName.Value+"*",
Fields!MonthName.Value
)

Open in new window

0
 
tanj1035Author Commented:
really helpful!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.