Crystal Report在发布时要求数据库登录

本文关键字：数据库 登录 布时 Report Crystal | 更新日期: 2023-09-27 17:58:53

我正在WPF中开发一个应用程序，它需要从中获取报告，我完成了它，在我的电脑中一切都很好，没有数据库登录对话框出现，完全没有问题。但当我在客户端电脑中发布它时，当它想通过Crystal report Viewer显示报告时，数据库登录对话框就会出现！我做了我想到的一切，在网上到处搜索，尽了最大努力，但无法解决这个问题。这是我的代码：

ReportDocument CryRpt1 = new ReportDocument();
string Path1 = System.Windows.Forms.Application.StartupPath + "''CryReportSendItems.rpt";
CryRpt1.Load(Path1, OpenReportMethod.OpenReportByDefault);
AssignConnection(CryRpt1);
CryRpt1.Refresh();
Crv.ViewerCore.ReportSource = CryRpt1;

这就是AssignConnection方法：

private void AssignConnection(ReportDocument rpt)
        {
            ConnectionInfo connection = new ConnectionInfo();        
            connection.ServerName = "*ServerName*";
            connection.DatabaseName = "*DBName*";
            connection.UserID = "*User*";
            connection.Password = "*Password*";
            foreach (CrystalDecisions.CrystalReports.Engine.Table table in rpt.Database.Tables)
            {
                AssignTableConnection(table, connection);
            }
            foreach (CrystalDecisions.CrystalReports.Engine.Section section in rpt.ReportDefinition.Sections)
            {
                foreach (CrystalDecisions.CrystalReports.Engine.ReportObject reportObject in section.ReportObjects)
                {
                    if (reportObject.Kind == ReportObjectKind.SubreportObject)
                    {
                        SubreportObject subReport = (SubreportObject)reportObject;
                        ReportDocument subDocument = subReport.OpenSubreport(subReport.SubreportName);
                        foreach (CrystalDecisions.CrystalReports.Engine.Table table in subDocument.Database.Tables)
                        {
                            AssignTableConnection(table, connection);
                        }
                        subDocument.SetDatabaseLogon(connection.UserID, connection.Password, connection.ServerName, connection.DatabaseName);
                    }
                }
            }
            rpt.SetDatabaseLogon(connection.UserID, connection.Password, connection.ServerName, connection.DatabaseName);
        }
        private void AssignTableConnection(CrystalDecisions.CrystalReports.Engine.Table table, ConnectionInfo connection)
        {
            // Cache the logon info block
            TableLogOnInfo logOnInfo = table.LogOnInfo;
            connection.Type = logOnInfo.ConnectionInfo.Type;
            // Set the connection
            logOnInfo.ConnectionInfo = connection;
            // Apply the connection to the table!
            table.LogOnInfo.ConnectionInfo.DatabaseName = connection.DatabaseName;
            table.LogOnInfo.ConnectionInfo.ServerName = connection.ServerName;
            table.LogOnInfo.ConnectionInfo.UserID = connection.UserID;
            table.LogOnInfo.ConnectionInfo.Password = connection.Password;
            table.LogOnInfo.ConnectionInfo.Type = connection.Type;
            table.ApplyLogOnInfo(logOnInfo);
        }

*注意：我的windows版本是10（x64），客户端windows版本是7（x64）。

有人能帮我吗？

Crystal Report在发布时要求数据库登录

我找到了答案，有人可以用这个吗：

使用实体框架在代码中再次填写报告。

        using (var db = new DatabaseContext())
        {
            CryRpt1.SetDataSource(db.VwSendItems);
        }

在此之前：

        SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder("Data Source=*Server*;Initial Catalog=*DBCenter*;Persist Security Info=True;User ID=*User*;password=*Password*");  //from config.xml
        crConnectionInfo.ServerName = builder.DataSource;
        crConnectionInfo.DatabaseName = builder.InitialCatalog;
        crConnectionInfo.IntegratedSecurity = true;
        CrTables = CryRpt1.Database.Tables;
        foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
        {
            crtableLogoninfo = CrTable.LogOnInfo;
            crtableLogoninfo.ConnectionInfo = crConnectionInfo;
            CrTable.ApplyLogOnInfo(crtableLogoninfo);
        }
        //AssignConnection(CryRpt1);
        ConnectionInfo connection = new ConnectionInfo
        {
            ServerName = "10.20.1.41",
            DatabaseName = "DBCenterMostafavi",
            UserID = "site",
            Password = "123!@#a"
        };
        CryRpt1.SetDatabaseLogon(connection.UserID, connection.Password, connection.ServerName, connection.DatabaseName);
        foreach (CrystalDecisions.CrystalReports.Engine.Table table in CryRpt1.Database.Tables)
        {
            AssignTableConnection(table, connection);
        }

就是这样。

相关文章：