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

ernest
ernest Member Posts: 162
edited 2011-09-13 in NAV/Navision Classic Client
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

Comments

  • Savatage
    Savatage Member Posts: 7,142
    What have you tried to do so far?

    Did you try the BlankZero property?
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • ernest
    ernest Member Posts: 162
    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
    GRIZZLY Member Posts: 127
    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!
    Sincerely yours, GRIZZLY
    Follow my blog at http://x-dynamics.blogspot.com
  • Savatage
    Savatage Member Posts: 7,142
    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
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org

Categories