VB.net RLDS Report

HI Experts

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)

Me.ReportParameters("AgeementComment") = AgreementComment

the AgreementComment has the correct data but nothing prints

attached is a copy of the report setup
29-04-2015-6-58-14-PM.png
KevinfeeningAsked:
Who is Participating?
 
KevinfeeningAuthor Commented:
still no idea

If I stop the program at

Me.ReportParameters("AgeementComment") = AgreementComment

agreementComment contains the correct string

If I need to explain print layout or preview mode I cannot help you I wish I could

all I know is the parameter has the data but it isn't transferring to the report
0
 
sarabhaiCommented:
Is it works in Preview mode ?
0
 
KevinfeeningAuthor Commented:
Not sure what you mean preview mode

but if you stop the program at
Me.ReportParameters("AgeementComment") = AgreementComment

agreementComment contains the correct string
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
KevinfeeningAuthor Commented:
Extreme novice at this
0
 
sarabhaiCommented:
using Print layout
0
 
KevinfeeningAuthor Commented:
Found spelling mistake

Me.ReportParameters("AgeementComment") = AgreementComment

AgeementComment missing r would have thought the program would have shown error

thanks for support
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.