[水晶报表]Asp.net调用水晶报表

1.如果是对单个表的处理

------------------------------------------------------------------------------------------

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

using System.Drawing;

using System.IO;

using System.Text;

using CrystalDecisions.Shared;

using CrystalDecisions.CrystalReports.Engine;

using CrystalDecisions.ReportSource;

public partial class Rpt_EveryMrpPlanningDetail : System.Web.UI.Page

{

public string sql;

public string Itemfrom;

public string Itemto;

public string Mrpdate;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

MrpDate_Bind();

sql = "select item,DueDateDay,QtyOnHand,QtyRecv,QtyReq,ExceptMessage,MrpRef,Parent,Lead_time,order_min,order_mult,days_supply,PriVendNum,ReplenPoNum,ProcessDueDate,ProcessQtyReq,ProcessVendNum,RecordDate,UpdateBy,CreateDate from UF_EveryMrpPlanningDetail where convert(varchar(10),CreateDate,120)='-10-06' ";

Bind();

CrystalReportSource1.ReportDocument.SetDatabaseLogon(PublicVar.UserID, PublicVar.PW, PublicVar.DS, PublicVar.DB);

CrystalReportSource1.DataBind();

}

}

protected void MrpDate_Bind()

{

string sqlstr = "SELECT distinct(CreateDate) ,convert(varchar(10),CreateDate,120) as mrpdate FROM UF_EveryMrpPlanningDetail order by CreateDate desc";

//SELECT convert(varchar(10),CreateDate,120) as mrpdate FROM UF_EveryMrpPlanningDetail group by CreateDate order by CreateDate desc //also can be this

PublicFunction.DropDown_List(DropDownList_MrpDate, sqlstr, 1);

}

protected void But_Check_Click(object sender, EventArgs e)

{

if (TextBox1.Text == "") { Itemfrom = ""; } else { Itemfrom = TextBox1.Text; }

if (TextBox2.Text == "") {Itemto = "ZZZZZZZZZZZZZZ";}else{Itemto = TextBox2.Text;}

Mrpdate=DropDownList_MrpDate.SelectedItem.Text;

PublicVar.sqlstr = "select item,DueDateDay,QtyOnHand,QtyRecv,QtyReq,ExceptMessage,MrpRef,Parent,Lead_time,order_min,order_mult,days_supply,PriVendNum,ReplenPoNum,ProcessDueDate,ProcessQtyReq,ProcessVendNum,RecordDate,UpdateBy,CreateDate from UF_EveryMrpPlanningDetail ";

sql = PublicVar.sqlstr + "where convert(varchar(10),CreateDate,120)>=" + "convert(varchar(10)," + Mrpdate+ ",120)" + "and item >='" + Itemfrom + "'and item<='" + Itemto + "'";

Bind();

}

protected void Bind()

{

//string DBConfig_sql = "Data Source=syteline;Initial Catalog=SHAT_App;Persist Security Info=True;User ID=SA;Password=SVTEP";//连接到指定数据库

string DBConfig_sql = PublicVar.strCon;

DataSet ds = new DataSet();

SqlConnection sqlCon = new SqlConnection(DBConfig_sql);

SqlCommand sqlCmd = new SqlCommand(sql, sqlCon);

SqlDataAdapter sqlAd = new SqlDataAdapter();

sqlAd.SelectCommand = sqlCmd;

sqlAd.Fill(ds, "sql");

//CrystalReportSource1.ReportDocument.Load(Server.MapPath("HandQty.rpt"));

//注意此处必需指明Dataset中的表的名称，否则会提示“您请求的报表需要更多信息.”

CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables["sql"]);

//{?}中的参数可以不用赋值，即使赋了值也不起作用。

// CrystalReportSource1.ReportDocument.ParameterFields["Parm"].CurrentValues.AddValue("1234567");

//CrystalReportSource1.ReportDocument.ParameterFields["Title"].CurrentValues.AddValue("这时推模式的报表样例！");

CrystalReportSource1.DataBind();

CrystalReportViewer1.ReportSource = CrystalReportSource1;

CrystalReportViewer1.DataBind();

}

}

-------------------------------------------------------------------------------------------------------------------------------

2.水晶报表调用存储过程示例子:

-------------------------------------------------------------------------------------------------------

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

using System.Drawing;

using System.IO;

using System.Text;

using CrystalDecisions.Shared;

using CrystalDecisions.CrystalReports.Engine;

using CrystalDecisions.ReportSource;

public partial class HandQty : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

CrystalReportSource1.ReportDocument.SetDatabaseLogon(PublicVar.UserID, PublicVar.PW, PublicVar.DS, PublicVar.DB);//取得公共变量

CrystalReportSource1.ReportDocument.SetParameterValue("@item", null);

CrystalReportSource1.DataBind();

}

}

protected void Button1_Click(object sender, EventArgs e)

{

CrystalReportSource1.ReportDocument.SetDatabaseLogon(PublicVar.UserID, PublicVar.PW, PublicVar.DS, PublicVar.DB);//取得公共变量

CrystalReportSource1.ReportDocument.SetParameterValue("@item", TextBox1.Text);

CrystalReportSource1.DataBind();

}

}

--------------------------------------------------------------------------------------------------------------------------

CrystalReportSource1.ReportDocument.SetDatabaseLogon(PublicVar.UserID, PublicVar.PW, PublicVar.DS, PublicVar.DB);--连接数据库

CrystalReportSource1.ReportDocument.SetParameterValue("@item", TextBox1.Text);---传入存储过程的参数

CrystalReportSource1.DataBind();--邦定到数据源