I am having a problem with a RLDS report printing a parameter in the page footer
The code is
sql = "SELECT a.Comments AS AgreementComment FROM Transactions t LEFT JOIN Agreements a ON t.Agreement = a.ID WHERE (InvoiceNo = @InvoiceNo)"
Dim AgreementComment As String = Me.DataConnector.GetScalar
(Of String)(sql, parameters)
") = AgreementComment
the AgreementComment has the correct data but nothing prints
attached is a copy of the report setup