Good Day,
Below is the grid data window report. I need someone to help me color the column based on the data content. For example, under column trans type, where there is payment i color the entire row red, where there is invoice i color blue the entire row. How do I archive this?
Hi, Matthews -
In the DataWindow Painter, click on (select) the detail band:
Next, in the Background tab of the Properties pane, click on the Expression button on the right side of the Color property:
This opens the expression dialog window for the DataWindow.Detail.Color property. Enter an expression similar to what I show below:
Note: The name of the first column in the grid DataWindow I used was "company_name".
I suggest you use lighter shades of Red and Blue so as to not wash out the black text. Black text on Blue background in particular is difficult to read. Of course, you can set the text color for each and every column in a similar manner when an invoice is being displayed. The choice is yours.
Best regards, John
Do you have a good way to do this while staying "compatible" with themes? I found those hardcoded colors often only work well with the "default" color scheme and really clash with other themes.
You bring up an excellent question, however. One thing you may wish to consider is posing your question as a new thread in the Q&A forum. Good luck!