asked on
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())&"*"","
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())&"*"","
Microsoft DynamicsSSRSSQL
Last Comment
tanj1035
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
really helpful!!!!