Wiki

SAP BUSINESS ONE

None Defined

how to suppress or hide all $0 rows on the sales tax report

how to suppress or hide all $0 rows on the sales tax report

Hi Michael,

Follow these steps:

1. You need to convert the amount field to a float (without the currency symbol). So create a formula that uses Amount operations, and in the parenthesis, select the amount field. I tested it on the field Total Amount

Make the original amount field in visible create a formula to compare the amount field to 0, and make a condition that say the first formula doesn’t equal to 0.

link all the fields in the repetitive area to the second formula using the Link To

if the answer to the condition is yes, the row is printed if the answer to the condition is no, the row is not printed as well make sure that you set the Auto Height Adjustment for the repetitive area

Solution

30 Apr 2007