Show field and label only if value is > 0 in report

Are you using RTC report or classic Report ?

Hi Shyam,

If you are using classic client report then you have to create two more sections to show the text field and lable field based on condition using CurrReport.showoutput(value > 0).

If you are using RTC report then you can define the expression on property of the field and label.

classic report only . if field has some value.. it should not visible(both label and textbox)

On Section you can write

IF <REC>.<Field Name/Varialbe Name>='' THEN

 CurrReport.SHOWOUTPUT:=FALSE;

value or expression is expected... it seems like simply error but am new to NAV pls help me.

whole section becomes hidden.. i just want that particular field text box and label should not visible if value is zero.

i have given like this

IF RecSalesInvLine."Line Discount Amount" = 0 THEN

 CurrReport.SHOWOUTPUT:=FALSE;

Then you need to do what Raj is suggested..

see this is whole section in this if sales discount value shows zero , then both field and label 

should not be visible (complete row) 

Create one more section and add this field which you want to hide or show. and on presection() use the code 

if sales discount value > 0 then

  currReport.showoutput(false)

Cheers,

working .. wat i have done is created new section placed sales discount label and text box..used the code on presection() .. text box is not visible if value is 0 but label is visible..

label should hide wat to do??

for classic you can use BlankZero property of text box and for RTC you can use Hidden property and pass <Expression> to toggle visibility

for the earlier section also u have to either write the code or use the blankzero property suggested by Anil