This issue occurs when the field used to build the URL is also used in the report linkage. For example: In this case, the URL was constructed using the Account Number field. Because that field was referenced in the report linkage, it was not reliably available in the final report output. As a result, when Apsona tried to use it in the URL field or in a calculated field, the value appeared as undefined.
This behavior is not caused by incorrect HTML or formula syntax, but by how Apsona handles fields that are part of report linkages. Fields used in linkages are often excluded from the final result set and cannot be safely referenced for calculations or HTML-based construction.
To resolve this, the field used in the linkage must be changed to a different field that still returns the same record set.
In this case, the linkage was updated to use Account Name instead of Account Number. This ensured that:
The same records were returned in the report.
The Designation Account Number field was now available in the output.
The URL could be correctly constructed.
After the change, the URL rendered correctly in the format.