Print Format Script Column cannot find Columns from context

Description

Steps to reproduce:

  • log in to GW

  • navigate to a Print format (e.g. for Order Detail) → Print Format Item

  • modify an Item (e.g. QtyEntered_Quantity):

    • Format Type: Script

    • Script: @COL/M_Product_ID@

  • on the Display Order tab, move Quantity before Product

  • run the Order Detail report

  • in the Quantity column you will see an error message: Item not found: M_Product_ID

Note: if you move Quantity back after Product, it will display the Product as expected.

Environment

None

Activity

Peter Takacs
June 1, 2023 at 10:15 AM

Reopening due to a NullPointerException. Steps to reproduce:

  • log in to GardenWorld and run e.g. Order Detail report

  • through report wizard set e.g. DatePromised as Sort Criteria and also Grouping Criteria

  • still in the wizard, on the Summary Fields tab select e.g. Order - Count and click OK

  • go to the Print Format and create a new Print Format Item of Format Type: Script, the Script can be e.g. @COL/C_Order_ID@

  • save and run the report with this print format -> throws NPE

The cause is, that on the grouping rows our script column is null (has no value), and this case is not handled in DataEngine.

Fixed

Details

Assignee

Reporter

Fix versions

Priority

Created March 24, 2023 at 3:02 PM
Updated August 1, 2023 at 5:26 PM
Resolved June 5, 2023 at 1:10 PM