Microsoft Dynamics AX (Archived)

SSRS report to highlight the field value

(0) Share

Report

Posted on by Daljit Kaur Rahsi

1,260

Hi all,

I want to highlight the field value of the unit is equal to 'g' what expression I can use to perform this actions?

Highlight the unit if equal to 'g', but for some reason I am not receiving the highlights. I am using following expression:

=IIF(Fields!Unit.Value = "g", “Yellow”, Nothing)

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Zain Bokhari 3,208 Moderator on at

Like (0)

Report

Maybe try using Like instead of = operator.

Or deploy the report again. Maybe your changes have not been deployed. Clear the caches and try again.

The expression you wrote seems correct.

By the way, where are you using the above expression exactly?

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report

Okay that did not work, I wanted to highlight the "g" if unit is "g". But it instead wrote it as "Yellow". My requirement is to highlight "g" if unit id is "g"

Was this reply helpful? Yes No
Sohaib Cheema 49,443 User Group Leader on at

Like (0)

Report

give a try to correct expression on FontWeight property of textbox

=iif(Fields!Unit.Value = "g","Bold", "Normal")

Was this reply helpful? Yes No
Suggested answer

Zain Bokhari 3,208 Moderator on at

Like (0)

Report

Your expression is correct but you are putting it in the wrong place. Go to the report design right click on the unit field box.

click Text Box Properties

Then Click Fill and then click the small expression button in front of the "No Color" button

Put your condition expression here and change write "No color" instead of "Nothing" in the else part of your expression.

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (1)

Report

My bad, that is working - thanks for the help :)

Was this reply helpful? Yes No
Zain Bokhari 3,208 Moderator on at

Like (0)

Report

Great :)

Was this reply helpful? Yes No