关于生成可打印报告/发票的建议？
我有一个 ASP.NET 网站，用户自己可以从中生成自定义报告并（可能）打印它们。我的问题是您会推荐什么方法（以及为什么）：
- 使用 Microsoft Report Viewer 或 Crystal Reports 等报告软件生成报告。
- 使用简单的 ASP.NET 页面并使用 CSS 格式化页面以进行打印。
- 使用任何 PDF 生成框架生成 PDF 文件，并将打印工作留给 PDF 阅读器。
- 还有其他选择吗？
请注意，用户将具有选择控件来相应地生成和过滤报告。
编辑：我使用 NHibernate 作为 ORM 并连接到 Oracle 数据库，因此 SQL Server 特定的解决方案将不起作用。
谢谢。
I have an ASP.NET website from which the users themselves will generate custom reports and (possibly) print them. My question is what approach would you recommend (and why):
- Generate the report using reporting software like Microsoft Report Viewer or Crystal Reports.
- Use simple ASP.NET pages and format the page for printing using CSS.
- Generate PDF files using any PDF-generating framework out there and leave the printing to the PDF reader.
- Any other choice?
Do note that the user will have selection controls to generate and filter the report accordingly.
Edit: I am using NHibernate as an ORM and connecting to an Oracle database, so SQL Server specific solutions will not work.
Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
只需使用 ASP.NET 页面即可。
我们在我以前的雇主那里制作了一个应用程序，它做了非常相似的事情。我们制定了一个视图来关联给定应用程序/程序/报告的所有可用属性。用户有一个列表可以从中选择属性，然后相应地过滤这些属性。每个属性类型都是一个单独的对象，具有“经理”可以为其用户设置的不同可过滤属性。
选择他们想要查看/过滤的列后，单击“开始”，我们生成 SQL 并一次将 15/30 个结果放回到分页网格视图中。
如果他们想查看更多内容，可以下载 Excel CSV 导出文件。
对于大型、过滤较少的查询，我们将行返回计数限制为不会超时的合理值。
它不是最优雅的，但它非常多才多艺，几乎让每个人都满意。
澄清一下 - 这个报告系统本身就是我们构建的一个应用程序（OOP、NHibernate 等）来支持和简化这个过程。
Just use ASP.NET pages.
We made an app at my previous employer that did a very similar thing. We made a view to relate all the available properties for a given application/program/report. The users had a list to select properties from, and then filtered those properties accordingly. Each property type was a separate object with different filterable properties that the 'manager' could setup for their users.
After selected what columns they wanted to view/filter, the clicked go, we generated SQL and placed 15/30 results at a time back into a paging gridview.
If they wanted to see more than that they could download an Excel CSV export file.
For large, less filtered queries, we restricted the row return count to something reasonable that wouldn't time-out.
It isn't the most elegant, but it was VERY versatile and made almost everyone happy.
To Clarify - this reporting system in and of itself was an app we built (OOP, NHibernate, etc.) to support and simplify this process.
SQL Server 报告服务。
Sql Server Reporting Services.
在过去的项目中，我使用了 Microsoft Report Viewer 和 Crystal Reports。它们都可以将报告输出为 PDF，然后您可以将其下载给用户。
On past projects I've used both Microsoft Report Viewer and Crystal Reports. They can both output reports as PDFs which you can then serve as a download to the user.