问题:我的开发环境VS2010,水晶报表CrystalReportsForVisualStudio.msi在开发环境下可以成功打开水晶报表。
可是换台机器(这台机器没有安装VS2010,只安装了CRRuntime_32bit_13_0.msi ),打开水晶报表后出现数据库登录框,然后输入任何用户名和密码都是错误的,不输入也是错误的。水晶报表数据取的我用拉模式。是直接从数据库中拉出。我链接数据库是windows认证。
以下是我的代码: myReport.Load(Application.StartupPath + @"\MalePremaritalCrystalReport.rpt");
CrystalDecisions.Shared.ConnectionInfo crConnectionInfo = myReport.Database.Tables[0].LogOnInfo.ConnectionInfo; myReport.Database.Dispose();
crConnectionInfo.ServerName = ConfigurationManager.AppSettings["Server"].ToString();
crConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["DB"].ToString();
crConnectionInfo.UserID = ConfigurationManager.AppSettings["User"].ToString();
crConnectionInfo.Password = ConfigurationManager.AppSettings["Pw"].ToString(); Database crDatabase = myReport.Database;
Tables crTables = crDatabase.Tables;
foreach (Table crTable in crTables)
{
TableLogOnInfo crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);
} myReport.RecordSelectionFormula = "{家庭信息.编号} =" + this.UserID;
this.crystalReportViewer1.ReportSource = myReport;
可是换台机器(这台机器没有安装VS2010,只安装了CRRuntime_32bit_13_0.msi ),打开水晶报表后出现数据库登录框,然后输入任何用户名和密码都是错误的,不输入也是错误的。水晶报表数据取的我用拉模式。是直接从数据库中拉出。我链接数据库是windows认证。
以下是我的代码: myReport.Load(Application.StartupPath + @"\MalePremaritalCrystalReport.rpt");
CrystalDecisions.Shared.ConnectionInfo crConnectionInfo = myReport.Database.Tables[0].LogOnInfo.ConnectionInfo; myReport.Database.Dispose();
crConnectionInfo.ServerName = ConfigurationManager.AppSettings["Server"].ToString();
crConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["DB"].ToString();
crConnectionInfo.UserID = ConfigurationManager.AppSettings["User"].ToString();
crConnectionInfo.Password = ConfigurationManager.AppSettings["Pw"].ToString(); Database crDatabase = myReport.Database;
Tables crTables = crDatabase.Tables;
foreach (Table crTable in crTables)
{
TableLogOnInfo crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);
} myReport.RecordSelectionFormula = "{家庭信息.编号} =" + this.UserID;
this.crystalReportViewer1.ReportSource = myReport;
希望对你有帮助