Multiple Selection List, Multiple Selection Search and Multiple Selection Table
YesNo
Amount in words. Expression syntax: $P{COLUMN_LOOKUP}.apply(“AmtInWords”, $F{GrandTotal})
Chart. Expression syntax: $P{COLUMN_LOOKUP}.apply(“chart/width/height”, $F{chart_id}). Replace width and height with the actual width and height in pixel of the Chart Image.
Report Starter will introduce a new parameter "COLUMN_LOOKUP" of type java.util.function.BiFunction
To use this, add a new report parameter "COLUMN_LOOKUP" of type java.util.function.BiFunction to your jasper report.
The BiFunction parameter is an interface that has a single method, apply that take two input argument. First argument is use to lookup the display type, typically of the "tablename.columnname" format string (except the image,amtinwords and chart display type above). Second argument take the report field value.
E.g 1: $P{COLUMN_LOOKUP}.apply("c_bpartner.m_pricelist_id",$F{m_pricelist_id}) to get the display text for m_pricelist_id
Eg 2: $P{COLUMN_LOOKUP}.apply("c_bpartner.invoicerule",$F{invoicerule}) to get display text for invoicerule
Eg 3: $P{COLUMN_LOOKUP}.apply("c_bpartner_location.c_location_id",$F{c_location_id}) to get display text for an address
Implement support for jasper report to lookup display text or image for the following display type:
List
Search, Table and Table Dir
Location
Locator
Account Combination
Attribute Set Instance
Image. Expression syntax: $P{COLUMN_LOOKUP}.apply(“image”, $F{image_id})
Multiple Selection List, Multiple Selection Search and Multiple Selection Table
YesNo
Amount in words. Expression syntax: $P{COLUMN_LOOKUP}.apply(“AmtInWords”, $F{GrandTotal})
Chart. Expression syntax: $P{COLUMN_LOOKUP}.apply(“chart/width/height”, $F{chart_id}). Replace width and height with the actual width and height in pixel of the Chart Image.
Report Starter will introduce a new parameter "COLUMN_LOOKUP" of type java.util.function.BiFunction
To use this, add a new report parameter "COLUMN_LOOKUP" of type java.util.function.BiFunction to your jasper report.
The BiFunction parameter is an interface that has a single method, apply that take two input argument. First argument is use to lookup the display type, typically of the "tablename.columnname" format string (except the image,amtinwords and chart display type above). Second argument take the report field value.
E.g 1: $P{COLUMN_LOOKUP}.apply("c_bpartner.m_pricelist_id",$F{m_pricelist_id}) to get the display text for m_pricelist_id
Eg 2: $P{COLUMN_LOOKUP}.apply("c_bpartner.invoicerule",$F{invoicerule}) to get display text for invoicerule
Eg 3: $P{COLUMN_LOOKUP}.apply("c_bpartner_location.c_location_id",$F{c_location_id}) to get display text for an address