Suppress empty filed

[mbb]

i'm creating an invoice in sales module. how do i suppress a field from displaying if it contains null or zero values ? any codes for that ?

[autocount.daniel]

Hello,

You may try the below script in the label > OnBeforePrint

Assume that the field is in the detail table, the field is "FromDocNo"

//------------------------------------------------------------------------------------------------------------------------------
object oFromDocNo = ppChildReport1.GetCurrentColumnValue("FromDocNo");
(sender as XRLabel).Text = (oFromDocNo!=null && oFromDocNo!=DBNull.Value)?oFromDocNo.ToString():"";
//------------------------------------------------------------------------------------------------------------------------------


Note that, the label.Text will never return a null or DBNull.Value value. Even if the data field is null, in the label.Text, it'll be "", aka empty string.

Regards,
Daniel