hi am new to navision,i have one requirement, in sales invoice report tax text field and label field should be visible only if the value is greater then zero..pls help me..
Are you using RTC report or classic Report ?
Don't forget to the post(s) that solved your problem
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
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
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
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
Don't forget to the post(s) that solved your problem!
for the earlier section also u have to either write the code or use the blankzero property suggested by Anil
© 1995-2013 Dynamics User Group, all rights reserved.