Grid Cell Color

(0) Share

Report

Posted on by Community Member

Hi everyone,

I am using dynamics ax 2012 and new to development. I want to colorize the grid cells based on its value. So same row may contains cells with different color. For this, i am overriding displayoptions() of Data source. But i realized that only the last set color is affecting the entire cells in a row. How can i achieve this.

As an another example i am using the following code to colorize different columns

public void displayOption(Common _record, FormRowDisplayOption _options)

{

_options.backColor(WinApi::RGB2int(255,0,0));

_options.affectedElementsByControl(FIELD_1.id());

_options.backColor(WinApi::RGB2int(0,0,255));

_options.affectedElementsByControl(FIELD_2.id());

Here i am expecting red color for FIELD_1 and blue color for FIELD_2. But i am getting both the columns with blue color.

please suggest the code for achieving the desired result

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi No Man,

Per record you can have only one back color. It is not per control.

The affectedElementsByControl is only for specifying which contols needs to have the background color if you don't want to have all controls marked with the background..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andrea,

Per record only one back color means I cannot specify cell wise coloring based on cell value. My grid has many columns having cell values like L, S,P, A etc. I need to mark each cell value with different color. In that case one row may affected by different colours. ( example in row 1 Col A value - L, Col B value - P ...). So is there any solution in such a situation.

Was this reply helpful? Yes No
Suggested answer

PA-22040759-0 6,194 on at

Like (0)

Report

I have had a similar requirement from a customer, and it won't work with the grid control.

I ended up solving this using the FormTableControl. In the AOT there is a tutorial form for this control.

But it will give you a lot more work to do to present the data.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi No man, Palle,

I was about writing about the FormTable control. This indeed can have a color per cell, but you have to manually fill the cells. Be careful with much records in this control.

Was this reply helpful? Yes No
PA-22040759-0 6,194 on at

Like (0)

Report

I must admit that with fifteen years of experience with AX, I only this one time found it relevant to use the FormTableControl for anything :-)

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

We had once a challenge where we could not even use this FormTableControl. We ended up in placing controls dynamically on the form and use a vertical scrollbar to show records that did not fit on the form.

Was years back with AX3.0.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Andre, palle..

It would be helpful if you could provide me something useful tutorial about FormTableControl that suits my requirement.

Was this reply helpful? Yes No
Verified answer

PA-22040759-0 6,194 on at

Like (0)

Report

Please have a look at the Tutorial_Form_Table form, which you can find in the AOT.

And here is a link to the MSDN documentation: msdn.microsoft.com/.../formtablecontrol.aspx

Was this reply helpful? Yes No