using System;
using System.Data;
using System.Configuration;
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 CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using System.Data;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
private ReportDocument customerReport;
private void ConfigureCrystalReports()
{
customerReport = new ReportDocument();
string reportPath = Server.MapPath("myself.rpt");
customerReport.Load(reportPath);
// DataSet dataSet = DataSetConfiguration.CustomerDataSet;
DataSet dataSet = new DataSet();
int ok = 15;
SqlConnection cn = new SqlConnection("server=;database=oa;user=;pwd=");
SqlDataAdapter da = new SqlDataAdapter("exec pro '" + ok.ToString() + "'", cn);
da.Fill(dataSet, "issue_content");
SqlDataAdapter da2 = new SqlDataAdapter("select * from customer where [customer id]='"+ok.ToString()+"'", cn);
da2.Fill(dataSet, "customer");
//Response.Write("<script>alert('" + dataSet.Tables[1].Rows.Count.ToString() + "')</script>");
//return;
this.customerReport.OpenSubreport("Customer.rpt").SetDataSource(dataSet.Tables["customer"]);
//dataSet.Relations.Add("mo", dataSet.Tables["issue_content"].Columns["id"], dataSet.Tables["customer"].Columns["customer id"]);
ParameterFields paramFields = new ParameterFields();
ParameterField paramField1 = new ParameterField();
ParameterField paramField2 = new ParameterField();
ParameterDiscreteValue discreteVal1 = new ParameterDiscreteValue();
ParameterDiscreteValue discreteVal2 = new ParameterDiscreteValue();
paramField1.ParameterFieldName = "c";
discreteVal1.Value = "sx1";
paramField1.CurrentValues.Add(discreteVal1);
paramFields.Add(paramField1);
//************************************8
paramField2 = new ParameterField();
paramField2.ParameterFieldName = "sx2";
discreteVal2.Value = sx2;
paramField2.CurrentValues.Add(discreteVal2);
paramFields.Add(paramField2);
crystalReportViewer.ParameterFieldInfo = paramFields;
customerReport.SetDataSource(dataSet);
crystalReportViewer.ReportSource = customerReport;
}
private void Page_Init(object sender, EventArgs e)
{
ConfigureCrystalReports();
}
}