Retrieve Record

Horse06
Horse06 Member Posts: 496
edited 2006-03-22 in NAV/Navision Classic Client
Hi I create a Return Line Table with shipment cost field. The record is like this:
Type Shipment Cost
Repair
Ship back 3.00
Receive
Some have shipment cost, some don't need the shipment cost. When we create the report, We want to leave the shipment cost empty instead of zero in this column if the shipment cost is 0. Thanks in advance!

Comments

  • bbrown
    bbrown Member Posts: 3,268
    Two possible solutions:

    1. Set the property BlankZero to TRUE on the TextBox control. I know this property is available on a form. I am not sure about a report. (Not near Navision).

    2. If BlankZero not available:

    Create a text variable CostVal and display in report (be sure to right justify.

    IF "Shipment Cost" = 0 THEN
    CostVal := ''
    ELSE
    CostVal := FORMAT("Shipment Cost")
    There are no bugs - only undocumented features.

Categories