Conditional visibility is a technique to determine whether a value is displayed in a report which is determined during the layout definition of any given report. It is used in many of the default reports in Acumatica.
TL:DR – This article about how to add conditional visibility to a report in Acumatica Report Designer.
Conditional Visibility
Visibility of a value in a report can be set in a number of different ways.
- The Behaviour Property
VisibleExpris useful for a field or whole section of a report. - An
=IIF([ACUMATICAFIELDNAMEHERE]<>null, [ACUMATICAFIELDNAMEHERE], '')expression looks more complex but provides more flexibility within the details section of a report but requires some rigour about whether the field could be null or not. - A Report Section variable can be added to determine whether a report section should be visible at all, for example if a customer is inactive it could be excluded from customer reports.
VisibleExpr Behaviour Property
=([SOOrder.PrepaymentReqPct] <> 0 Or [SOOrder.CuryPrepaymentReqAmt] <> 0) And [SOOrder.Behavior] = 'SO' And [SOOrderType.ARDocType] <> 'UND'
This is a an expression that determines whether the entire section regarding Prepayment Percent and Prepayment amount appears on the so641010 report.
IIf field exists expression
=([SOOrder.PrepaymentReqPct] <> 0 Or [SOOrder.CuryPrepaymentReqAmt] <> 0) And [SOOrder.Behavior] = 'SO' And [SOOrderType.ARDocType] <> 'UND'
This is a an expression that determines whether the entire section regarding Prepayment Percent and Prepayment amount appears on the so641010 report.
