oracle 除了oracle报告构建器之外，还有其他工具可以用于构建oracle报告吗？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4307490/
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
Is there another tool out there for building oracle reports other then oracle reports builder?
提问by spaghetticowboy
I cant stand oracle reports builder. Its constantly crashing and sucking in general. Copying and pasting stuff only sometimes works. Elements visualy look selected after you unselect them. AARRRRRRRRGGHHHHHHHHHHHH!!! I need another tool. Are their any alternatives for designing the report jsps?
我受不了 oracle 报告生成器。它不断崩溃和吸吮一般。复制和粘贴东西只是有时有效。取消选择后，元素在视觉上看起来已被选中。啊啊啊啊啊啊啊啊啊啊！！！我需要另一个工具。他们是否有设计报告jsps的任何替代方案？
采纳答案by Jon Heller
Don't bother switching tools, you'll probably only be disappointed. I've used many reporting tools and all of them have significant issues. No matter which tool you use you'll probably end up fighting it and gradually move more and more of your logic into the database. The more SQL tricks you learn the less you'll have to rely on poorly designed reporting tools.
不要费心切换工具，你可能只会失望。我使用过许多报告工具，但它们都存在重大问题。无论您使用哪种工具，您最终都可能会与它作斗争，并逐渐将越来越多的逻辑移入数据库。您学习的 SQL 技巧越多，您对设计不良的报告工具的依赖就越少。
回答by Manish
This is an old thread but here my take on it. For experienced developers (I should point out that I am one), Oracle Reports is unbelievably productive tool. For new developers, it can be baffling and frustrating. I have been in the "market" for an Oracle Reports alternative for some time now and have yet to find a tool that can do what Oracle Reports can do for me. The tools I have looked at:
这是一个旧线程，但这里是我的看法。对于有经验的开发人员（我应该指出我就是其中之一），Oracle Reports 是令人难以置信的高效工具。对于新开发人员来说，这可能令人困惑和沮丧。一段时间以来，我一直在“市场”中寻找 Oracle Reports 替代方案，但尚未找到可以完成 Oracle Reports 为我做的事情的工具。我看过的工具：
Oracle BI Publisher: Officially, this is the successor to Oracle Reports. One day it will be as good as Oracle Reports...right now it primarily uses MS Word as the report designer. Its not fun to to wrestle with Word (nested) tables (which replaces frames). I would prefer Reports Frames any day.
Pentaho: I looked at this with minor interest, it's commercial open source and I thought did a pretty good job. Not sure how it scales and like all open source projects, is at the mercy of an active community.
MicroStrategy: This is again a very seasoned product. BI is their bread and butter and so I would expect that its pretty good. I had a vendor do a POC and they replicated one of my most complex "Form" type reports (a business document, bill-of-lading). The price however it at enterprise level (read: very pricy). Although for departmental deployments they have a 'free' version.
Microsoft Reporting: This one has good promise but it is sold primarily with MS SQL Server and I being an Oracle-guy has felt internal resistance to this tool. One of these days I will overcome it when the Reports Builder has crashed one too many times.
Oracle BI Publisher：正式地说，这是 Oracle Reports 的继任者。总有一天它会和 Oracle Reports 一样好......现在它主要使用 MS Word 作为报表设计器。与 Word（嵌套）表格（取代框架）搏斗并不有趣。我更喜欢任何一天的报告框架。
Pentaho：我略感兴趣地看着这个，它是商业开源，我认为做得很好。不确定它是如何扩展的，就像所有开源项目一样，受活跃社区的支配。
MicroStrategy：这又是一个非常老练的产品。BI 是他们的面包和黄油，所以我希望它相当不错。我让一个供应商做一个 POC，他们复制了我最复杂的“表格”类型的报告之一（商业文件、提单）。然而它在企业级别的价格（阅读：非常昂贵）。虽然对于部门部署，他们有一个“免费”版本。
微软报告：这个有很好的前景，但它主要与 MS SQL Server 一起销售，我是一名 Oracle 专家，我对这个工具感到内部抵制。有一天，当 Reports Builder 崩溃太多次时，我会克服它。
There are scores of others like JasperReports, Actuate, Business Objects (Crystal), Information Builders etc.
还有很多其他的，比如 JasperReports、Actuate、Business Objects (Crystal)、Information Builders 等。
回答by kayhan yüksel
Microstrategy or Business Objects. You may develop a custom software as erbsock has told, like a lightweight BO, create views from the selected fields by users, name them as reports and schedule a job to send them as a CSV file or in a jsp file , whatever the view part is. Also in Oracle Reports Builder, if you are not mentioning the old 6i interfaced tool, try to build one big query and try to build the XML using the publisher. I am outdated about it , but remember something like that. I will ask about it to an expert friend of mine.
微观战略或业务对象。您可以像 erbsock 所说的那样开发自定义软件，例如轻量级 BO，从用户选择的字段创建视图，将它们命名为报告并安排作业以 CSV 文件或 jsp 文件的形式发送它们，无论视图部分如何是。同样在 Oracle Reports Builder 中，如果您没有提到旧的 6i 接口工具，请尝试构建一个大查询并尝试使用发布者构建 XML。我对此已经过时了，但请记住类似的事情。我会向我的一位专家朋友询问此事。
Best Regards,
此致，
Kayhan YüKSEL
凯汉·尤克塞尔
回答by erbsock
Use SQL and understand your data model and plug it into an excel spreadsheet using ODBC?
使用 SQL 并了解您的数据模型并使用 ODBC 将其插入到 Excel 电子表格中？
回答by user2705124
After using the tool for a year, we are familiar than past. We still have challenges that implementations worked fine in TOAD, but the code does not work in Oracle Report. After crashing several time, we have done CTR+Sbefore run the project. Plus, we save every hours as a previous draft. It help us to lost our works but we need more space for them.
使用该工具一年后，我们比过去熟悉了。我们仍然面临着实现在 TOAD 中运行良好的挑战，但代码在 Oracle Report 中不起作用。几次崩溃后，我们在运行项目之前完成了 CTR+ S。另外，我们将每个小时都保存为以前的草稿。它帮助我们丢失了我们的作品，但我们需要更多的空间来放置它们。
