how to display discount field in O.C. report only when is<>0

ernest

Hi all

I want to modify the Order Confirmation report. I want to display the Discount % field and headings only when the % of discount is different from 0, and when this value is 0 I dont want to display it at all.


Can you please help me to solve this issue?


Thank you and best regards

Savatage

What have you tried to do so far?

Did you try the BlankZero property?

ernest

Hi Harry

thanks for your reply.

When the discount is 0(zero) I dont want to display even the heading of the report. So I dont know how to accomplish this.

Please suggest if you have any idea.

Thank you and best regards

GRIZZLY

Add new sections for header (without discount column) and body.
When all lines have no discount, then change CurrReport.SHOWOUTPUT(FALSE) variable in OnSectionPrint trigger for existing sections and CurrReport.SHOWOUTPUT(TRUE) for a new ones.
Hope you've got an idea!

Savatage

are you talking about an invoice discount on the header or sales line discount?

if the discount is on the header you could make a textbox with a new variable DisccountLabel type text

add then if discount = 0 then
DiscountLabel = '' else
discountlabel = "Discount";

make discountlabel the sourceexp of the textbox

or you can hide it. a few ways to do it
if it's on the sales line you have to handle it diffeently