Problem with VAT table in NAV 2013 R2 Report

poppins

Hi everyone,
I am having a trouble with displaying VAT lines in a NAV 2013 R2 report.
Infact, the customer wants the VAT amounts displayed in the report even if the VAT amount is zero.
I couldn't figure out what visibility condition to put to get the amount dispalyed while avoiding the empty blank lines ](*,)
First, I used the condition:

=iif(Cstr(Fields!VATAmtLineVATAmt.Value)="",TRUE,FALSE)

It works fine when the VAT amount is >0, but i get nothing when the VAT amount is zero.
What shall I put?
Thanks in advance

clausl

=iif(Len(Fields!VATAmtLineVATAmt.Value)=0,TRUE,FALSE)

I wrote at blog about how to do filters here:
http://mibuso.com/blogs/clausl/2013/07/06/filtering-and-visbility-best-practice/

/Claus Lundstrøm