加载报表

web(asp.net)

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 CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Enterprise;
using CrystalDecisions.CrystalReports;
using CrystalDecisions.Shared;

public partial class Report : System.Web.UI.Page
{   
  
    protected void Page_Load(object sender, EventArgs e)
    {
        TableLogOnInfo logOnInfo = new TableLogOnInfo();
        ReportDocument Rd = new ReportDocument();      
        Rd.Load(@"C:/Documents and Settings/xwgang/My Documents/Visual Studio 2005/WebSites/WebSite1/EmailReport.rpt");
        logOnInfo.ConnectionInfo.ServerName ="192.168.33.99";
        logOnInfo.ConnectionInfo.DatabaseName ="EmailManage";
        logOnInfo.ConnectionInfo.UserID = "czping";
        logOnInfo.ConnectionInfo.Password = "trio";
        Rd.Database.Tables[0].ApplyLogOnInfo(logOnInfo);
        this .CrystalReportViewer1.ReportSource = Rd;
    }

}

winform

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace reports
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            SqlConnection connection = new SqlConnection();
            connection.ConnectionString = "data source=192.168.33.99;database=EmailManage;user id=czping;password=trio";

            SqlDataAdapter da = new SqlDataAdapter("select * from logdetails", connection);
            DataSet dt = new DataSet();
            da.Fill(dt);

            CrystalReport1 cr = new CrystalReport1();
            cr.SetDataSource(dt);
            this .crystalReportViewer1.ReportSource =cr;

        }
    }
}

 web(ASP.NET)

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 System.Data ;
using System.Data .SqlClient ;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Enterprise;
using CrystalDecisions.CrystalReports;
using CrystalDecisions.Shared;
using CrystalDecisions.ReportSource;

public partial class _Default : System.Web.UI.Page
{

public static object DTSET;

    protected void Page_Load(object sender, EventArgs e)
    {
        string TPO = Request["tpo"];
            string DN = Request["dn"];
            string DNLine = Request["dnline"];
            string USER = Request["user"];
            string ReportName = Request["RptName"];

           BindReport(ReportName);

    }

 

private void BindReport(string ReportName)
        {
            switch (ReportName)
            {
                case "CryTEST":  //进口报关单草单
                    CryTEST cryTest = new CryTEST(); //实例化一个水晶报表对象    
                    cryTest.SetDataSource(DTSET); //报表对象和dataset数据绑定  
                    this.CrystalReportViewer1.ReportSource = cryTest; //在crystalReportViewer控件上显示
                    break;
                default:
                    break;
            }
        }

}