SageForum for UK versions of Sage 50- Help and support.

Hello,

I am new to sage and the report designer. I am learning as i am going. I would like to be able to stop the Vat % from being shown when the total of that row = 0. Is this possible?

I will attached a screen shot to show what i mean.

Thanks in advance.

Yes you can do that.

If you find the field you want to hide when the total is zero and look at its properties your will find one called suppress print and one called conditional formatting.

Go in the conditional formatting property by clicking on the dots to the right of the property.
Enter the expression on which you want the field to be hidden.
Then on the properties tab, change the "suppress print" property to "true" using the drop down box.

From now on when there is zero vat on the line the item will be suppressed from being printed.