I have created a new Crystal report which uses a Command object to pull information from a DB2 database via ODBC.
The report works fine through the the Crystal Reports application, so I have gone and added it to the BusinessObjects server using the Central Management Console web-app. However when I try and open the report in Infoview I get the aforementioned error.
Does anyone know if there is some configuration setting I need to change on the BO server so my report will run through Infoview? I feel I should mention my report runs very quickly indeed when I refresh it within the Crystal Reports app, which is running on the same server as the BO server.
Do you have the DSN for the DB2 database set on the server machine?
I guess the Crystal reports developer and the Business Objects Server are on the different machine. If this is so then you need to have a DSN with the same name created on the server machine which will help the report to fetch the data in the report.
I hope this information helps you.