Cancelled order should show in red color.

Seemab07

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.

Duikmeester

Add the field OrderCancelled TRUE/FALSE in your dataset then use an expression in the Rdlc:

allenyyzhou

Hi

You can have two detail line in report layout, one line is red. and use flag to control the line visibility.

RockWithNAV

You just need to write the respective code in NAV and then in SQL builder in for colour, background colour you can play with the expressions. It will work for sure.

Seemab07

can you give me an example.

Duikmeester

Add the field OrderCancelled TRUE/FALSE in your dataset then use an expression in the Rdlc: