Data field Lists appear blank when printing reports or templates in V2.
Hint Ref: 020802050007
Hint Date: 05/02/2008
Hint Details:
PROBLEM: The user wanted to show a list of contract Unit Numbers on his Contract Template. However, whilst the list appeared when he displayed the Preview in Report Builder, the list was not displayed when he actually printed the template.
The list SQL he was using was:
(select List(UnitNumber) from unit join Subcontract on Subcontract.UnitID=-Unit.UnitID where subcontract.contractid=:incontractid) as Unitlist,
SOLUTION: Casting the resultant list as a Character String resolved the problem:
Cast((select List(UnitNumber) from unit join Subcontract on Subcontract.UnitID=-Unit.UnitID where subcontract.contractid=:incontractid) as char(50)) as Unitlist,