SQL 您选择的报告工具是什么？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/18952/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is your reporting tool of choice?
提问by jason saldo
Every project invariably needs some type of reporting functionality. From a foreach loop in your language of choice to a full blow BI platform.
每个项目总是需要某种类型的报告功能。从您选择的语言中的 foreach 循环到完整的 BI 平台。
To get the job done what tools, widgets, platforms has the group used with success, frustration and failure?
为了完成工作，团队使用了哪些工具、小部件和平台，成功、挫折和失败？
回答by Guy
For knocking out fairly "run of the mill" reports, SQL Reporting Services is really quite impressive.
对于淘汰相当“普通”的报告，SQL Reporting Services 确实令人印象深刻。
For complicated analysis, loading the data (maybe pre-aggregated) into an Excel Pivot table is usually adequate for most users.
对于复杂的分析，将数据（可能是预先聚合的）加载到 Excel 数据透视表中通常对大多数用户来说就足够了。
I've found you can spend a lot of time (and money) building a comprehensive "ad-hoc" reporting suite and after the first month or two of "wow factor", 99% of the reports generated will be the same report with minor differences in a fixed set of parameters.
我发现您可以花费大量时间（和金钱）构建一个全面的“临时”报告套件，并且在“令人惊叹的因素”的第一个月或两个月之后，生成的报告的 99% 将是相同的报告一组固定参数的细微差别。
Don't accept when a user says they want "ad-hoc" reports without specifying what goals and targets their looking for. They are just fishing and they need to actually spend as much time on THINKING about THEIR reporting requirements as YOU would have to spend BUILDING their solution.
不要接受当用户说他们想要“临时”报告而没有指定他们寻找的目标和目标时。他们只是在钓鱼，他们实际上需要花尽可能多的时间来思考他们的报告要求，就像您必须花费在构建他们的解决方案上一样。
I've spent too much time building the "the system that can report everything" and for it to become out of date or out of favour before it was finished. Much better to get the quick wins out of the way as quick as possible and then spend time "systemising" the most important reports.
我花了太多时间来构建“可以报告一切的系统”，结果在它完成之前就已经过时或失宠。尽可能快地获得快速胜利，然后花时间“系统化”最重要的报告要好得多。
回答by Martynnw
I've used Reporting Services and Crystal fairly extensively, and I'm writing a few reports using Excel(ick) at the moment.
我已经相当广泛地使用了 Reporting Services 和 Crystal，目前我正在使用 Excel(ick) 编写一些报告。
Reporting Services is pretty good for simple reports but as soon as you need total control over formatting,complex formulas and charts etc. Crystal is a long way ahead. I also find Crystal to be far more usable; being able to change things within the report preview is invaluable (it may be possible in later versions of RS?).
Reporting Services 非常适合简单的报告，但一旦您需要完全控制格式、复杂的公式和图表等，Crystal 就遥遥领先。我还发现 Crystal 更有用；能够在报告预览中更改内容是无价的（在更高版本的 RS 中可能有可能？）。
RS also needs to be deployed to a web server which limits it's usefulness if you are writing applications that need to be deployed externally.
RS 还需要部署到 Web 服务器，如果您正在编写需要在外部部署的应用程序，这会限制它的实用性。
Older versions of Crystal were very buggy but the latest ones are much better, it's much more mature than Reporting Services.
旧版本的 Crystal 有很多问题，但最新版本要好得多，它比 Reporting Services 成熟得多。
回答by Vaibhav
For a lot of projects we use ActiveReports.
对于很多项目，我们使用 ActiveReports。
回答by Scott Rosenbaum
I am a committer on the BIRT project, so I am biased. BIRT provides a very well thought out report object model (ROM) and appropriate API for the various design and deploy function that is needed. In addition, BIRT provides the best multi-language support and the ability to separate development from design through the use of CSS.
我是 BIRT 项目的提交者，所以我有偏见。BIRT 为各种所需的设计和部署功能提供了一个经过深思熟虑的报告对象模型 (ROM) 和适当的 API。此外，BIRT 提供了最好的多语言支持和通过使用 CSS 将开发与设计分离的能力。
BIRT can be embedded into your application for no license cost through the REAPI or it can be purchased through a couple of commercial offerings.
BIRT 可以通过 REAPI 嵌入到您的应用程序中，无需许可成本，也可以通过一些商业产品购买。
回答by Scott Rosenbaum
Cognos is a robust suite of tools (we use it as a front-end for an Oracle back-end), but there's a pronounced lack of documentation on how to accomplish complex reporting tasks -- mostly, you end up banging on it until you get something to work.
Cognos 是一套强大的工具（我们将其用作 Oracle 后端的前端），但是明显缺乏有关如何完成复杂报告任务的文档——大多数情况下，您最终会一直使用它，直到您得到一些工作。
I wouldn't discount the usefulness of using Microsoft Access as a reporting front-end. It doesn't have that useful Web-enabled functionality, but for in-house reports it's very versatile and surprisingly powerful.
我不会低估使用 Microsoft Access 作为报告前端的有用性。它没有那么有用的启用 Web 的功能，但对于内部报告，它非常通用且功能强大。
回答by Horcrux7
We use i-net Clear Reportsfor our reporting (seeing as how we "eat our own dog food"). ;)
我们使用i-net Clear Reports进行报告（视为我们如何“吃自己的狗粮”）。;)
- It is like Crystal Reports,
- can read Crystal Reports templates,
- the API is more useful,
- costs less than Crystal Reports (and if you factor in support costs, costs less than open source)
- is platform independent because written in Java.
- we offer a free and fully functional report designer
回答by Dave K
We've been using BIRT which had a steep learning curve for me until I realized how many WYSIWIG features it had (I started editing the xml source code direct, which I don't recommend.) There are some output specific tricks (like using a 0 left margin to not get a blank A column when outputting to XLS format) but for the most part it's quick and easy to use, edit and preview.
我们一直在使用 BIRT，它对我来说有一个陡峭的学习曲线，直到我意识到它有多少 WYSIWIG 功能（我开始直接编辑 xml 源代码，我不推荐。）有一些特定于输出的技巧（比如使用0 左边距以在输出为 XLS 格式时不会出现空白 A 列）但在大多数情况下，它的使用、编辑和预览都非常快捷。
I have also been impressed on how easy it is to intermix different datasets in a single report. While not a silver bullet, its a better all around tool than 99.999% of people are going to build on their own.
在单个报告中混合不同的数据集是多么容易，这也给我留下了深刻的印象。虽然不是灵丹妙药，但它是一个比 99.999% 的人要自己构建更好的全能工具。
回答by SLoret
"Give them data and they will love you for it"
“给他们数据，他们会因此而爱你”
Out of the methods and tools I've used in the past, I would rank them in the following order based on abilities/versatility/usability/speed to deploy. I'm leaving cost out of it because while it is always a factor it is a different factor for everyone.
在我过去使用的方法和工具中，我会根据能力/多功能性/可用性/部署速度按以下顺序对它们进行排名。我不考虑成本，因为虽然它总是一个因素，但对每个人来说都是不同的因素。
1 is Cognos (version 8)
1 是 Cognos（版本 8）
2 is SQL Server Reporting
2 是 SQL Server 报告
3 is Crystal Reports
3 是水晶报表
4 is Custom written code
4 是自定义编写的代码
I haven't used any of the other tools mentioned. Cognos 8 is nothing short of awesome. While pricey, you are only limited by your imagination. It can do anything.
我没有使用任何提到的其他工具。Cognos 8 简直太棒了。虽然价格昂贵，但您只会受到想象力的限制。它可以做任何事情。
回答by JosephStyons
Crystal Reports, because it is easy to take the same exact report file and
Crystal Reports，因为它很容易获取完全相同的报告文件和
1 - Post it on the intranet
1 - 将其发布到内部网上
2 - Embed it in an application
2 - 将其嵌入到应用程序中
3 - Schedule it to be emailed as an Excel output every so often to whoever needs it
3 - 安排它每隔一段时间作为 Excel 输出通过电子邮件发送给需要它的人
Also (as I already suggested), it exports easily to Excel, PDF, and other formats.
此外（正如我已经建议的），它可以轻松导出为 Excel、PDF 和其他格式。
