水晶报表应用之登录失败及导出解决方案

最新推荐文章于 2021-02-26 17:02:03 发布

jabby12

最新推荐文章于 2021-02-26 17:02:03 发布

阅读量2k

点赞数

分类专栏：水晶报表文章标签：报表 report string file

本文链接：https://blog.csdn.net/jabby12/article/details/211483

版权

水晶报表专栏收录该内容

2 篇文章 0 订阅

订阅专栏

ReportDocument rd = new ReportDocument();

  private void setcry()
  {
   TableLogOnInfo t=new TableLogOnInfo();

rd.Load(Server.MapPath("CrystalReport1.rpt")); //Load the Crystal Report

   t.ConnectionInfo.ServerName="localhost";
   t.ConnectionInfo.DatabaseName="Northwind";
   t.ConnectionInfo.UserID="xxx";
   t.ConnectionInfo.Password="xxx";
   rd.Database.Tables["Categories"].ApplyLogOnInfo(t);//Save the connection info

   DiskFileDestinationOptions dd = new DiskFileDestinationOptions();
   string pdfname= @"d:/CrystalReport1.pdf";
   dd.DiskFileName =pdfname; //Save as a PDF file

   rd.ExportOptions.DestinationOptions = dd;
   rd.ExportOptions.ExportDestinationType=ExportDestinationType.DiskFile;
   rd.ExportOptions.ExportFormatType=ExportFormatType.PortableDocFormat;
   rd.Export();
   rd.Close();
   Response.ClearContent();
   Response.ClearHeaders();
   Response.ContentType="application/pdf";
   Response.WriteFile(pdfname);
   Response.Flush();
   Response.Close();
  }