Results 1 to 1 of 1

Thread: CR11 Linked Table Not Updating

Threaded View

  1. Jun 13th, 2006, 11:28 AM #1
    Daywalker46410
    Daywalker46410 is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2003
    Location
    Chicago, IL
    Posts
    102

    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.
    Attached Images Attached Images     
    Joe Cody
    Data Integration Engineer
    Novaspect, Inc.
    Elk Grove Village, IL
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width