Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Unanswered: Resetting a datasource - at a dialog box dead-end.

    I have a Crystal Report developed using a Microsoft Access table as a sample data source.
    Now I want to redirect the report to use a query into an Oracle database.
    Under "Database/Set DataSource Location" I have selected the Access database as the Current Data Source and the have selected the Oracle database as the Replacement Data Source.
    When I click the Update button I get this message:
    "Some tables could not be replaced, as no match was found in the new data source. Please specify the table required for any unmodified tables."
    The dialog box will not let me exit, but if I try specifying an Oracle table in this dialog box the Update button becomes disabled.
    What the heck am I supposed to do to reset a datasource to a query?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Resolved. I had to select the tables in both windows of the dialog box.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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