NPrinting - Misplaced and erroneous values in fields in Excel reports
Article Number: 000018429 | Last Modified: 2019/04/26
If the customer is using Calculated Dimensions in objects in a QlikView document the values of the fields might be misplaced once the fields are imported to an Excel report in NPrinting.
If Calculated Dimensions are used and the selected fields are not dragged and dropped on to a NPrinting report in order corresponding to the field order in the QlikView document the fields will contain erroneous values.
Nprinting Designer 16.0.0 to 16.6
The issue is due to the hidden dimension "check", if you show the column and "Update" the table in the template editor, the report preview will be correct.
As a workaround please advise the customer to use the calculated dimensions in the script and not in the objects or simply use the fields in the same order as in the QlikView document.