Sharepoint 列表转 PDF 报告
我有一个 SharePoint 列表,我需要将其转换为文档(任何类型)并将其导出为 PDF。 您对执行此操作的最佳方法有什么建议吗? 我有 Crystal Reports,但不确定这是否是正确的用例。
I have a SharePoint list and I need to transform it into a document (any type) and export it to PDF. Would you have any tips on the best way to do this? I have Crystal Reports but not sure if this is the correct use case for this.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(5)
您可以使用对象模型或通过 Web 服务以编程方式访问文档库。
如果使用对象模型。 您可以使用 SPContext 对象来获取当前站点/列表。 从那里,您可以迭代项目,或者您可以使用 SPList 对象上的方法将其转换为数据集,然后您可以使用该数据集使用某种 PDF 库(例如 PDF4NET)生成 PDF。 如果您采用这种方式,推出它的最佳方法是将其打包为解决方案文件 (.WSP) 中的一项功能,您可以将其部署到您的场中。 在这种情况下,代码将在共享点环境中运行。 您可以对此非常感兴趣,并在所有列表的操作菜单中添加“打印 PDF”菜单选项。
另一方面,您还可以使用 Web 服务远程访问该列表。 在这种情况下,您可以将其用作报告包的数据提供者。
You can programatically access the document library using the object model or via web services.
If you use the object model. You can use the SPContext object to get the current site/list. From there, you can iterate through the items or, you can use a method on the SPList object to turn it into a dataset which you could then use to generate a PDF using some kind of PDF library (e.g. PDF4NET). If you go this route the best way to roll it out is by packaging it up as a feature in a solution file (.WSP) which you can deploy to your farm. In this case the code would be running in the share point environment. You can get pretty fancy with this and have something like a "Print PDF" menu option in the action menu for all lists.
On the other hand, you could also access the list remotely using the web services. In such a case you could just use this as a data provider for your reporting package.
PDFsharepoint 工具 (http://www.pdfsharepoint.com) 可用于生成 PDF 输出。 这个工具的好处是,您将使用所见即所得编辑器“设计”或“导入”模板,并且仅映射数据。 无需编写您自己的 PDF 生成器的混乱代码。 但它不是免费工具......
The PDFsharepoint tool (http://www.pdfsharepoint.com) can be used to generate the PDF output. Nice thing about this tool is that you will "design" or "import" a template using WYSIWYG editor and only map the data. Without mess of coding your own PDF generator. It is not free tool though ...
我使用 MS-Access 从 SharePoint 列表创建 PDF 报告取得了很大成功。 您甚至可以将报告作为视图嵌入到列表中。 当您选择视图时,它会为您打开 Access。 此外,您还可以加入多个列表,甚至可以从 access 中加入其他数据。
Access 2007 会将报告另存为 PDF,或者您可以使用 PDF 打印机适配器(例如 PDFCreator)。
I have had much success using MS-Access for creating PDF reports from SharePoint lists. You can even embed the report as a view in the list. When you select the view, it opens Access for you. Plus you can join multiple lists and even other data from within access.
Access 2007 will save a report as a PDF or you can use a PDF printer adapter such as PDFCreator.
将 SharePoint 列表导出为 pdf 的最简单方法是,首先将列表导出为 Excel 文件。 然后将 Excel 文件另存为 Pdf 文档。
The easiest way to export SharePoint list to pdf is, first export the list as Excel file. Then save the Excel file as Pdf document.
有一个第三方产品可以自动执行此操作。
i-PMO 的“SharePoint Data Miner”可用于跨任何列表数据创建 RS 报告,然后使用其 SharePoint 站点报告查看器和文档发布器将报告作为 PDF 输出到文档库中。
There is a 3rd Party product that automates this.
i-PMO's "SharePoint Data Miner" can be used to create a RS Report across any list data, then use the their SharePoint site Report Viewer and Document publisher to output the report as a PDF into a Document Library.