I have an application that uses a crystal report within it. It uses and OLE DB (ADO) connection. I have opened the report in crystal and added another table, then linked it. I can refresh the report without error. I am using the same sql login that the application uses to log into the database.
When I replace the report with the one I had just modified, there is an error within the application. "The table could not be found."
The table that I have added is a sql view that queries data from another database, within the same server. I have verified that it is not a permission issue.
How can I get this application to view data from another database, just on this report?
When I replace the report with the one I had just modified, there is an error within the application. "The table could not be found."
The table that I have added is a sql view that queries data from another database, within the same server. I have verified that it is not a permission issue.
How can I get this application to view data from another database, just on this report?