水晶报表导出格式

using System;
using System.Collections;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;
using System.IO;
using Ghy.Funds.FundsClassLibrary;
using System.Data.SqlClient;

namespace WebAppTest
{
 /// <summary>
 /// WebForm1 的摘要说明。
 /// </summary>
 public class WebForm1 : System.Web.UI.Page
 {
  
  protected System.Web.UI.WebControls.DropDownList DropDownList1;
  protected CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer1;
  protected System.Web.UI.WebControls.Button Btn_Export;
  ReportDocument reportDoc=new ReportDocument();

  //页面加载
  //SqlConnection myconn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectString"]);
  //SqlConnection myconn1 = new SqlConnection(ConfigurationSettings.AppSettings["ConnectString"]);
  //读取web.config配置文件中的数据库连接字符串,并连接到指定的数据库
  
  private void Page_Load(object sender, System.EventArgs e)
  {
   // Put user code to initialize the page here
   if (!Page.IsPostBack)
   {
    //测试的时候用绑定 
             reportDataBind();
   }
   
  }

  #region Web Form Designer generated code
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: This call is required by the ASP.NET Web Form Designer.
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  /// Required method for Designer support - do not modify
  /// the contents of this method with the code editor.
  /// </summary>
  private void InitializeComponent()
  {   
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion

  //绑定数据源
  private void reportDataBind()
  {
     SqlConnection myConn = new SqlConnection("server = 10.100.0.8; database =eProcessDB; uid = sa; pwd =admin@sa ");
     string sql = "SELECT FUNDS_RPT_HQ.VKBUR, FUNDS_RPT_HQ.VKBUR_NAME, FUNDS_RPT_HQ.FORM_DATE, FUNDS_RPT_HQ.AMT_BEG, FUNDS_RPT_HQ.INGDS, FUNDS_RPT_HQ.INOTH, FUNDS_RPT_HQ.PAYHQ, FUNDS_RPT_HQ.PAYOTH, FUNDS_RPT_HQ.AMT_END, FUNDS_RPT_HQ.TOT_INGDS, FUNDS_RPT_HQ.TOT_PAYHQ, FUNDS_RPT_HQ.FEE_END FROM  FUNDS_RPT_HQ WHERE FUNDS_RPT_HQ.FORM_DATE ='2007-05-09' " ;
     myConn.Open();
           SqlDataAdapter myComm = new SqlDataAdapter(sql, myConn);
           DataSet dset1 = new DataSet();
           myComm.Fill(dset1,"FUNDS_RPT_HQ");
           myConn.Close();
     string ls_rptPathName;
     ls_rptPathName = Server.MapPath(".")+"\\Funds_Rpt_HQ.rpt";
     reportDoc.Load(ls_rptPathName);
     reportDoc.SetDataSource(dset1);
           CrystalReportViewer1.ReportSource = reportDoc;
          
   
  }

  private void Btn_Export_Click(object sender, System.EventArgs e)
  {   //内容类型

   reportDataBind();

   string contenttype = "";
   string ls_FileType;
   ls_FileType = DropDownList1.SelectedValue;
   string myfilename = "ExportFormat";
   //string myfilename = Request.MapPath(".")+"file://ReportExportFile//"+Session.SessionID+"."+ls_FileType;

   DiskFileDestinationOptions opts = new DiskFileDestinationOptions();
            opts.DiskFileName = myfilename;
            DiskFileDestinationOptions myoptions = new DiskFileDestinationOptions();
   myoptions.DiskFileName= myfilename;
   reportDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
   CrystalDecisions.Shared.ExportOptions myExportOptions = reportDoc.ExportOptions;
            myExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;

   opts.DiskFileName = "C:\filename.pdf";
   reportDoc.ExportOptions.DestinationOptions = opts;
   reportDoc.Export();

//   switch(DropDownList1.SelectedItem.Value)
//   {
//    case "PDF":
//     contenttype = "application/pdf";
//     myExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
//     break;
//   
//    case "DOC":
//     Response.ContentType = "application/ms-excel";
//     myExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.WordForWindows;
//     break;
//   
//    case "EXCEL":
//     contenttype = "application/vnd.ms-excel";
//     this.EnableViewState = false;
//     myExportOptions.ExportFormatType =CrystalDecisions.Shared.ExportFormatType.Excel;
//     break;
//   }
//           
//   CrystalReportViewer1.Export();
//   Response.ClearContent();
//   Response.ClearHeaders();
//   Response.ContentType = contenttype;
//   Response.WriteFile(myfilename);
//   Response.Flush();
//   Response.Close();
//   System.IO.File.Delete(myfilename);

  }

 }
}