I'm using Crystal reports as a part of Microsoft Visual studio .net 2002. I'm using field definition file (ttx) and a datatable as a datasource for report. (In VB .net code, Datatable is filled with data and then is set to be datasource for the report). Program works fine on the development PC. But when I try to show report on some other PC, 'Database login' dialog appears. How can I avoide this dialog?
FIX FOR - Crystal Report displays database login page for VS2003 .Net Crystal Report
I finally was able to resolve this problem. I spent more than two weeks pondering on this problem. I had all my crystal Reports developed on a VS 2003 .Net platform. The Crystal Reports are based on ADO.Net datasets (XML). They were working fine at all the 17 clients but when we recently deployed it to a new client in a virtual environment, we got the above error where the Crystal report was asking for database credentials.
Our App already sets the LogOnInfo for each table, subreport, section. Finally after weeks of research through various blogs, Crystal (SAP/Business Objects) support websites.... I found that the problem lies within the current version of your crdbadoplus.dll. It doesn't matter where this dll is there on your machine, but in my case this dll was causing the logon window to come up everytime, the crystal report was launched from the application. To fix the problem. Copy crdbadoplus.dll (Version: 220.127.116.11) into the application root folder where it was deployed to eg: C:\Program Files\Your Client Application\ and the database logon window stopped popping.....So if all fails please try to get this dll..and try it....Good luck guys...(May be this will help lots of ppl who are spending hours and hours on the net trying to find a resolution to this problem.). Please let me know if this worked for you guys....