首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > asp.net >

ASPNET怎么制作水晶报表

2012-01-12 
ASPNET如何制作水晶报表希望高手发表意见。。以前没有做过这个水晶报表。。查了写资料,大多雷同。。代码也用不了

ASPNET如何制作水晶报表
希望高手发表意见。。以前没有做过这个水晶报表。。查了写资料,大多雷同。。代码也用不了。。

[解决办法]
数据库连接类,需要在webconfig中设置好AppSettings["servername"],AppSettings["userid"],AppSettings["pass"]这三个数据库OLEDB的连接字符串. 

C# code
public class LoginCrystalReport    {        public void Login(CrystalDecisions.CrystalReports.Engine.ReportDocument report)        {            string servername, username, password;            // t Database Logon to main report             servername = System.Configuration.ConfigurationSettings.AppSettings["servername"];            username = System.Configuration.ConfigurationSettings.AppSettings["userid"];            password = System.Configuration.ConfigurationSettings.AppSettings["pass"];            foreach (CrystalDecisions.Shared.IConnectionInfo connection in report.DataSourceConnections)            {                if (connection.ServerName == servername)                {                    connection.SetLogon(username, password);                }            }            // t Database Logon to subreport             foreach (CrystalDecisions.CrystalReports.Engine.ReportDocument subreport in report.Subreports)            {                foreach (CrystalDecisions.Shared.IConnectionInfo connection in subreport.DataSourceConnections)                {                    if (connection.ServerName == servername)                    {                        connection.SetLogon(username, password);                    }                }            }        }    } 

热点排行