水晶报表中不需要填写登陆信息实现

最新推荐文章于 2021-04-12 23:17:22 发布

weixin_30297281

最新推荐文章于 2021-04-12 23:17:22 发布

阅读量65

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/litaocnblogs/archive/2009/06/23/1508812.html

版权

在后台：

    protected void Page_Load(object sender, EventArgs e)
    {
        BindReport();
    }

    private void BindReport()
    {
        DataSet dsCryShui = new DataSet();
        TicOA.BLL.SF_SHUI ShuiBll = new TicOA.BLL.SF_SHUI();

dsCryShui = dsCryShui = ShuiBll.GetListShuiAndShuiSys("");
ReportDocument redoc = new ReportDocument();

string reportLocalPath = "/CrystalReportShui.rpt";

        //获取程序根目录
        string tmpRootDir = Server.MapPath(System.Web.HttpContext.Current.Request.ApplicationPath.ToString());
        //转换成绝对路径
        string reportPath = tmpRootDir + reportLocalPath.Replace(@"/", @"\");

//读取Report
redoc.Load(reportPath);

redoc.SetDataSource(dsCryShui);

#region 设置缺省的数据库连接属性(这样每次都不需要填写登录信息)
TableLogOnInfo logOnInfo = new TableLogOnInfo();

        //从web.config中获取logOnInfo参数信息
        string ServerName, DatabaseName, UserID, Password;
        //获取ServerName
        ServerName = System.Configuration.ConfigurationManager.AppSettings["ServerName"];
        //获取DatabaseName
        DatabaseName = System.Configuration.ConfigurationManager.AppSettings["DatabaseName"];
        //获取UserId
        UserID = System.Configuration.ConfigurationManager.AppSettings["UserID"];
        //获取password
        Password = System.Configuration.ConfigurationManager.AppSettings["Password"];
        //设置logOnInfo参数
        logOnInfo.ConnectionInfo.ServerName = ServerName;
        logOnInfo.ConnectionInfo.DatabaseName = DatabaseName;
        logOnInfo.ConnectionInfo.UserID = UserID;
        logOnInfo.ConnectionInfo.Password = Password;

redoc.Database.Tables[0].ApplyLogOnInfo(logOnInfo);

#endregion

this.CrystalReportShui.ReportSource = redoc;

this.CrystalReportShui.HasCrystalLogo = false;

}

在前台 <CR:CrystalReportViewer ID="CrystalReportShui" runat="server" AutoDataBind="true"
Width="100%" Height="100%" />

转载于:https://www.cnblogs.com/litaocnblogs/archive/2009/06/23/1508812.html