SQL Express Reporting Services 能否从 RDL 生成 Word 文档
我知道我可以使用 SQL Reporting Service 生成 PDF 报告(甚至 SQL Express 也可以做到这一点),并且我可以使用 SQL Developer 版本生成 Word 文档。 由于我的开发工具是 SQL Developer 并且我的网站使用 SQL Express(我知道,它远非理想),我想知道 SQL Express 中包含的报告服务是否可以生成 Word 文档作为输出。
有谁有这方面的经验吗?
I know I can generate PDF reports with SQL Reporting Service (even SQL Express can do this) and I can do Word documents with SQL Developer edition. Since my dev box is SQL Developer and my website uses SQL Express (I know, it's far from ideal) I would like to know if the reporting service that is included with SQL Express can generate Word documents as an output.
Anyone who has experience with this?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
![扫码二维码加入Web技术交流群](/public/img/jiaqun_03.jpg)
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(4)
除非您有需要以 Word 格式呈现的现有报告,否则 Open XML Format SDK 可能是比 Reporting Services 更好的选择(我认为 Reporting Services 无论如何都做不到这一点,至少在 SQL 2005 中做不到)。
优点:无需安装 Office,除了 SDK 外不需要安装任何东西,不需要 Reporting Services。
编辑:
2008 确实渲染了 Word 并且我没有读到任何内容 Express 版本支持所有格式。 另一个轻量级选项可能是 2008 Report Viewer Control,它显然也可以呈现 Word 文档。
Unless you have existing reports that need to be rendered in Word format, the Open XML Format SDK may be a better choice than Reporting Services (which I don't think can do that anyways, at least not in SQL 2005).
Advantages: no Office installation needed, nothing to install but the SDK, no Reporting Services needed.
Edit:
2008 does render Word and I did not read anything about not all formats being supported in the Express edition. Another light-weight option may be the 2008 Report Viewer Control, which apparently can render Word documents as well.
我正在运行 SQL Server 2008R2,其 2007 Office System Driver 已安装。 我可以从 xls 导入并创建输出到 Word 的报告,而无需安装 Office 或支付 Aspose 费用。 如果您想从 Word 文档创建 rdl 报告,这就是 Aspose 赚钱的地方。
I'm running SQL Server 2008R2 with the 2007 Office System Driver installed. I'm able to import from xls and create reports that output into word without having office installed or paying for Aspose. If you want to create rdl reports from word documents, that's where Aspose makes their money.
我怀疑 SQL Server Express 本身是否可以做到这一点,但您绝对可以购买商业工具来做到这一点。 作为示例,请查看 Aspose Words.NET 示例。
I doubt that SQL Server Express itself can do that but you can definitely purchase a commercial tool to do so. As an example take a look Aspose Words.NET for example.
我们在生产系统中使用了 Aspose,要求最终文档采用韩语格式。 它就像一个魅力。
We have used Aspose in production systems that required the final documents to be formatted in Korean. It worked like a charm.