Dealy

Dealy

  • NA
  • 213
  • 0

Crystal reports showing database login window

Jun 11 2015 4:39 AM

Hello,

I have these reports that running on the development machine but when I try to load them from different machines I get a database login window which does not allow me to select server or database. As a result the reports are failing to load.

 So far I tried the following but none of them works.

1. I set the Connection info inside the code on report Load. Here's the code I'm using:

 ConnectionInfo myConnectionInfo = new ConnectionInfo();

  TableLogOnInfos mytableloginfos = new TableLogOnInfos();

           myConnectionInfo.ServerName = "TSQL";

           myConnectionInfo.DatabaseName = "DB";
           myConnectionInfo.UserID = "user";
           myConnectionInfo.Password = "pass";

  mytableloginfos = myReportViewer.LogOnInfo;

    foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos)
            {
              myTableLogOnInfo.ConnectionInfo = myconnectioninfo;
           }

2. I've installed SQL Server 2008 express at the other machines (the db is on SQL2008) 

3. I've installed Crystal Report Runtime Engine for .NET 

Any ideas what am I doing wrong? 

Thank you in advance. 


Answers (4)