怎样用代码实现水晶报表的输出?输出成excel文件或pdf文件,并且可以选择输出目录!

解决方案 »

  1.   

    给LZ个视频教程 还有源码
    http://www.microsoft.com/china/msdn/events/webcasts/shared/webcast/episode.aspx?newsID=1242276
      

  2.   

    string connStr =ConfigurationSettings.AppSettings["ConnString1"].ToString();
            SqlDataSource datasource = new SqlDataSource(connStr , SQL语句);
            ReportDocument doc = new ReportDocument();
            TableLogOnInfo logininfo = new TableLogOnInfo();
            string path;        path = Server.MapPath("report1.rpt");
            doc.Load(path);
            string a, b, c, d;
            a = System.Configuration.ConfigurationManager.AppSettings[0];
            b = System.Configuration.ConfigurationManager.AppSettings[1];
            c = System.Configuration.ConfigurationManager.AppSettings[2];
            d = System.Configuration.ConfigurationManager.AppSettings[3];
            logininfo.ConnectionInfo.ServerName = a;
            logininfo.ConnectionInfo.DatabaseName = b;
            logininfo.ConnectionInfo.UserID = c;
            logininfo.ConnectionInfo.Password = d;        try
            {
                doc.Database.Tables[0].ApplyLogOnInfo(logininfo);
                doc.Database.Tables[0].SetDataSource(datasource.Select(DataSourceSelectArguments.Empty));
                CrystalReportViewer1.ReportSource = doc;
            }
            catch
            {
                Response.Write("<script>alert('输出报表失败,请检查输入信息或网络!');</script>");
            }