Cancelled order in red color.

Business Central/NAV General Discussions
1

I have a report of export order in which i want to show cancelled order in RED color. I m using navision 2013 r2 with sql builder.

2

Even though your field is a character or Text the last column make it a Number and the one column before that you put it as ‘[Red]’, like shown below and the line will exported in Red.

In the Excel.addcolumn(customer.“no.”,false,true,true,[Red],Type::Number)

3

I don,t want in excel, i want in print layout.

4

In RDLC you can create two alternating rows, one where you format the text to be black and one red. Then hide/show it based on your “cancel” status.

5

I got the another solution.Thanks Erik P.Ernst.