现在的位置: 首页 > 综合 > 正文

水晶报表导出为word,excel和pdf格式

2012年02月03日 ⁄ 综合 ⁄ 共 1525字 ⁄ 字号 评论关闭

   string filetype = "";
  
   filetype = ddlFileType.SelectedValue;
   
   string contenttype = "";
   
   string myfilename = Request.MapPath(".")+"//ReportExportFile//"+Session.SessionID+"."+filetype;

   CrystalDecisions.Shared.DiskFileDestinationOptions mydiskfiledestinationoptions = new CrystalDecisions.Shared.DiskFileDestinationOptions();

   mydiskfiledestinationoptions.DiskFileName = myfilename;
  
   CrystalDecisions.Shared.ExportOptions myExportOptions = myreport.ExportOptions;

   myExportOptions.DestinationOptions = mydiskfiledestinationoptions;
   
   myExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;

   switch(ddlFileType.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 "xls":
     
            contenttype = "application/vnd.ms-excel";

            this.EnableViewState = false;
            myExportOptions.ExportFormatType =CrystalDecisions.Shared.ExportFormatType.Excel;
            break;
   }
   
   myreport.Export();

   Response.ClearContent();
 
   Response.ClearHeaders();
   
   Response.ContentType = contenttype;
   
   Response.WriteFile(myfilename);
   
   Response.Flush();
   
   Response.Close();

   System.IO.File.Delete(myfilename);
 

抱歉!评论已关闭.