Report Designer - How to make the quantity in the printed form blank when the quantity in transaction is 0 and show qty if transaction has quantity?

Hi ​@MarkD 

Try creating conditions in Schema Builder's Filter.

Best Regards,

NNT

​@MarkD I think the only thing wrong with your current expression is that there needs to be an equals sign in front of it.

Hi ​@MarkD 

Try creating conditions in Schema Builder's Filter.

 

 

 

Best Regards,

NNT

Thanks Nhat. Unfortunately, they still want to see that line but this is good resource in future if other clients ask for it.

Do you intend to display the Qty field as blank only (and not hide the entire row)? If so, you can use this formula for the Qty field:
=IIf([ARTran.Qty]<>0, [ARTran.Qty], null)
 

 

Hi ​@aleksandrsechin, this works too. I actually kept my simple formula and set the value to “True”. Currently, if the quantity in my invoice is 0 which I call invoice by amount, qty column shows blank just like yours and shows otherwise if there is a quantity. Many thanks for sharing this!

This works too, Drew! Thanks for that. Although, I set the value to True and added = in front of my expression which worked miraculously.