I have a crystal report which connect to an excel sheet on network. I am able to open it locally and refresh it. But after I upload it to the BOE, open it from infoview, I am not able to refresh it. it prompts for the database connection info.
I created an ODBC connection (choose MS excel and point to the excel file on network drive) on the BOE Server, it did not ask me for the login info and the server is responding. I also added this connection to BOE. But when I refresh the report from either infoview or CMC, it ask me for the database connection info with user login.
What should I do to solve this?
try the following:
Log on into the CMC, select Folders and navigate to the report, hightlight it and press the right mouse button. In the context menu choose Database Configuration, scroll down and select the Use same database logon as when report is run option.
The data source is an excel sheet in a network drive. I am able to refresh this report from my client computer, but after upload it to BOE, the report cannot be refreshed. The datasource configuration of this report is like the following:
Because no user name and password are required to open the excel, I leave it blank. But when I refresh the report, it said that "the database logon information for this report is either incomplete or incorrect."
How can I be able to refresh this report from BOE?
I made a mistake. The report connecting to the ODBC of the excel on network drive happened to use the ODBC of local excel.
Actually, if the excel is on the BOE server,
no problem to refresh it on BOE.
But if the excel is on the network drive, I still get the error of the imcomplete logon info.
Can you please help?