Dear All,
I have a question on how to connect an external database correctly.
I am using Crystal Report XI R2 and Crystal Report Server XI R2 with SP2.
For the same report, it works fine in CR but not CRS, CRS
It is a normal access database (.mdb) with just one table, I am just testing because I got another database which is more complex and isn't working in the same manner. I have created an ODBC connection in System DSN. That's how I connect to the database in CR. But when I add the report to CRS, it shows the following error: "The report you requested requires further information." and ask me for a database login.
I am not sure what I should put into the User ID and password fields because I didn't set any password for the database and it is working in CR without such information.
Would anyone can help me with this issue or tell me how to connect to an external database in CRS?
Many Thanks,
Cliff