Cancelled order should show in red color.

Seemab07 Member Posts: 32

2018-02-07 in NAV Three Tier

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.

0

Best Answer

• 

  Duikmeester Member Posts: 309

  2018-02-28 Answer ✓

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

  5

Answers

• 

  allenyyzhou Member Posts: 142

  2018-02-08

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

  0
• 

  RockWithNAV Member Posts: 1,199

  2018-02-08

  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.

  Thanks
  
  Blog - rockwithnav.wordpress.com/
  Twitter - https://twitter.com/RockwithNav
  Facebook - https://facebook.com/rockwithnav/

  0
• 

  Seemab07 Member Posts: 32

  2018-02-28

  can you give me an example.

  0
• 

  Duikmeester Member Posts: 309

  2018-02-28 Answer ✓

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

  5