解决访问水晶报表出现登录界面

最新推荐文章于 2016-08-23 15:09:00 发布

zhou_xuexi

最新推荐文章于 2016-08-23 15:09:00 发布

阅读量956

点赞数

文章标签：报表 dataset report object class cmd

本文链接：https://blog.csdn.net/zhou_xuexi/article/details/4747226

版权

在网上看的有的人给的解决方法不完全对，今天自己试了一下，和大家共享一下首先是pull模式，数据源大家自己配了页面代码： <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="PullModel.aspx.cs" Inherits="Report.PullModel" %> <%@ Register Assembly="CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" Namespace="CrystalDecisions.Web" TagPrefix="CR" %> 后台代码： using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace Report { public partial class PullModel : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { //this.CrystalReportSource1.ReportDocument.Load(Server.MapPath("Customer.rpt")); this.CrystalReportSource1.ReportDocument.SetDatabaseLogon("sa", "admin888", "ZHOU-93EB3AF622//SQLEXPRESS", "Northwind");//取消登录的关键代码 //this.CrystalReportSource1.DataBind(); //this.CrystalReportViewer1.ReportSource=this.CrystalReportSource1; //this.CrystalReportViewer1.DataBind(); } } } push模式页面代码 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="PushModel.aspx.cs" Inherits="Report._Default" %> <%@ Register Assembly="CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" Namespace="CrystalDecisions.Web" TagPrefix="CR" %> 后台代码： using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using CrystalDecisions.CrystalReports.Engine; namespace Report { public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { //this.CrystalReportSource1.ReportDocument.Load(Server.MapPath("Customer.rpt")); //this.CrystalReportSource1.ReportDocument.SetDatabaseLogon("sa", "admin888", "ZHOU-93EB3AF622//SQLEXPRESS", "Northwind"); //this.CrystalReportSource1.DataBind(); //CrystalReportViewer1.ReportSource = this.CrystalReportSource1; //CrystalReportViewer1.DataBind(); SqlConnection conn = new SqlConnection(@"server=ZHOU-93EB3AF622/SQLEXPRESS;database=Northwind;uid=sa;pwd=admin888;"); SqlCommand cmd = new SqlCommand("select * from employees", conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); ReportDocument reportDocument=new ReportDocument(); reportDocument.Load(Server.MapPath("Customer.rpt")); reportDocument.SetDataSource(ds); reportDocument.SetDatabaseLogon("sa", "admin888", "ZHOU-93EB3AF622//SQLEXPRESS", "Northwind");//取消登录界面的关键代码 this.CrystalReportViewer1.ReportSource=reportDocument; this.CrystalReportViewer1.DataBind(); } } }