Crystal Reports - 根据模板导出PDF文件

在NuGet添加下面几个包：

前面5个是Crystal Reports在.Net环境下操作的程序包，第6个是生成PDF的包。  

1	CrystalDecisions.CrystalReports.Engine
2	CrystalDecisions.ReportSource
3	CrystalDecisions.Shared
4	CrystalReports.ReportAppServer.CommLayer
5	CrystalReports.ReportAppServer.CommonObjectModel
6	PDFsharp

代码也很简单，就是用ReportDocument打开Crystal Reports模板 → 然后连接数据库把数据装进去 → 导出PDF。

具体代码如下，每个步骤都有说明，相应的参数改成你的就可以了。 

using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; using PdfSharp.Pdf; using PdfSharp.Pdf.IO; using PdfSharp.Pdf.Security; using System;namespace ConsoleApp1 {class Program{static void Main(string[] args){string path = @"C:\Template\Temp2021-5.rpt";using (ReportDocument reportDocument = new ReportDocument()){//根据路径加载模板reportDocument.Load(path);//写入Crystal Reports模板所需参数reportDocument.SetParameterValue("Id", 101);//创建数据库连接对象ConnectionInfo connectInfo = new ConnectionInfo(){ServerName = "10.10.10.10",DatabaseName = "DBTest",UserID = "sa",Password = "abc123"};//登录到数据库reportDocument.SetDatabaseLogon(connectInfo.UserID, connectInfo.Password);foreach (Table tbl in reportDocument.Database.Tables){tbl.LogOnInfo.ConnectionInfo = connectInfo;tbl.ApplyLogOnInfo(tbl.LogOnInfo);}//导出数据System.IO.Stream stream = reportDocument.ExportToStream(ExportFormatType.PortableDocFormat);byte[] bytes = new byte[stream.Length];stream.Read(bytes, 0, bytes.Length);stream.Seek(0, System.IO.SeekOrigin.Begin);//把数据装到PDFPdfDocument document = PdfReader.Open(stream);PdfSecuritySettings securitySettings = document.SecuritySettings;securitySettings.UserPassword = "user";securitySettings.OwnerPassword = "owner";securitySettings.PermitAccessibilityExtractContent = false;securitySettings.PermitAnnotations = false;securitySettings.PermitAssembleDocument = false;securitySettings.PermitExtractContent = false;securitySettings.PermitFormsFill = true;securitySettings.PermitFullQualityPrint = false;securitySettings.PermitModifyDocument = true;securitySettings.PermitPrint = false;//保存文件string savePath = @"C:\test file\" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".pdf";document.Save(savePath);document.Close();}}} }

---

有一点，如果你报错了，说找不到某个版本的程序集，可能是你引用的跟实际的包的版本不一致，在引用里面删掉，然后再添加你实际用的包就行了。

Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.'

总结

以上是生活随笔为你收集整理的Crystal Reports - 根据模板导出PDF文件的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。