给你个咯。记得要先添加引用CrystalDecisions. 再新建一个报表文件,空白的就行。把字段托到表里,然后用下面的代码,CrystalReport1.rpt放在相同目录下。 using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using CrystalDecisions.Shared; using CrystalDecisions.CrystalReports.Engine;namespace Deom { public partial class Report : System.Web.UI.Page { ReportDocument rdoc = new ReportDocument(); protected void Page_Load(object sender, EventArgs e) { rdoc.Load(Server.MapPath("CrystalReport1.rpt")); #region 去掉登录界面 TableLogOnInfo logonInfo = new TableLogOnInfo(); foreach (CrystalDecisions.CrystalReports.Engine.Table tb in rdoc.Database.Tables) { logonInfo = tb.LogOnInfo; logonInfo.ConnectionInfo.ServerName = "127.0.0.1"; logonInfo.ConnectionInfo.DatabaseName = "database"; logonInfo.ConnectionInfo.UserID = "sa"; logonInfo.ConnectionInfo.Password = "123456"; tb.ApplyLogOnInfo(logonInfo); } #endregion this.CrystalReportViewer1.ReportSource = rdoc; } } }
再新建一个报表文件,空白的就行。把字段托到表里,然后用下面的代码,CrystalReport1.rpt放在相同目录下。
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;namespace Deom
{
public partial class Report : System.Web.UI.Page
{
ReportDocument rdoc = new ReportDocument();
protected void Page_Load(object sender, EventArgs e)
{
rdoc.Load(Server.MapPath("CrystalReport1.rpt")); #region 去掉登录界面
TableLogOnInfo logonInfo = new TableLogOnInfo();
foreach (CrystalDecisions.CrystalReports.Engine.Table tb in rdoc.Database.Tables)
{
logonInfo = tb.LogOnInfo;
logonInfo.ConnectionInfo.ServerName = "127.0.0.1";
logonInfo.ConnectionInfo.DatabaseName = "database";
logonInfo.ConnectionInfo.UserID = "sa";
logonInfo.ConnectionInfo.Password = "123456";
tb.ApplyLogOnInfo(logonInfo);
}
#endregion this.CrystalReportViewer1.ReportSource = rdoc;
}
}
}
http://topic.csdn.net/u/20081118/10/49a1751d-1d86-44e4-969f-a847c2316dd3.html