4 Attachment(s)
CR11 Linked Table Not Updating
I am running an embedded report in a VB.NET 2003 program that uses a linked table. The data from the primary table is retrieved just fine, but the two fields (of five total) from the linked table are not being retrieved properly. I have the same data populating a ListView control in the VB app and it works fine. I created a stand alone report and the problem persists there. I have tried messing around with the various settings for the link to no avail, although it's a LEFT OUTER JOIN in the VB's SQL query. I have attached JPG shots of the SQL query in VB and Crystal, as well as returned data from VB and Crystal to give an idea of what I'm talking about.
FYI, the database I am connecting to is an AS/400 database via ODBC connections.
Thanks in advance for the assistance.