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

最新推荐文章于 2024-09-18 15:20:49 发布

vainnetwork

最新推荐文章于 2024-09-18 15:20:49 发布

阅读量731

点赞数

文章标签： excel 报表 string file

本文链接：https://blog.csdn.net/vainnetwork/article/details/1408830

版权

string filetype = "";

   filetype = ddlFileType.SelectedValue;

   string contenttype = "";

   string myfilename = Request.MapPath(".")+" file://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);