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

最新推荐文章于 2019-07-06 05:03:04 发布

原创最新推荐文章于 2019-07-06 05:03:04 发布 · 779 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#excel #报表 #string #file

本文介绍了一个使用 Crystal Reports 在不同文件类型间导出报告的方法。通过选择不同的文件类型（如 PDF、Word 或 Excel），系统会相应地调整内容类型及导出格式，并将文件保存到服务器上指定路径。随后，该文件会被发送给用户并立即删除服务器上的副本。

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);