web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) how to highlight color...

Microsoft Dynamics AX (Archived)

how to highlight color in SSRS Report in AX?

(0) Share

Report

Report

Posted on by Community Member

Dear All,

I created a Simple Consumption Report , and Column Field are ProductName, ItermID, OnHand.

I want to highlight some color for On Hand's Field such as:

-OnHand > 1000 is Red color

-OnHand > 3000 is Yellow Color

-OnHand < 100 is Black Color.

how to write this code?

please help me, and give me your ideas.

thanks in Advance.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (2)

Verified answer

Martin Dráb 237,967 Most Valuable Professional on at

Like (2)

Report

Write an expression for the Color property instead of using a fixed value. Let the expression return the name of the color you want ("Red"). A simple example:

=IIF(Fields!OnHand.Value > 0, “Red”, “Black”)

Was this reply helpful? Yes No
Verified answer

z4hid.kh4n 675 on at

Like (1)

Report

Hi Emarith,

Refer to this. It is not AX blog but it will give you understanding how conditional formatting works in SSRS. What Martin have suggested is best simple example.

blogs.msdn.com/.../sql-reporting-how-to-conditional-color-1-4-the-basics-report-expressions-custom-code.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Martin Drab,

thank you very much.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Zahid Khan,

thanks you very much.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans