哪种报告技术? [英] Which Reporting technology?
问题描述
哪种报告技术最适合产品的最佳情况/类型?我现在正在考虑 3 项技术:
Which reporting technology would fit for the best situation/type of product? I am now thinking of 3 technologies:
- 嵌入式报告(Crystal Reports；MS 报告服务)
- 服务器报告(MS Reporting Services)
- OLAP 数据库(MS 分析服务)
对于现成产品，您会使用哪种报告技术?是否可以从现成的产品中获得基于 OLAP 类型的报告方面的内容?
Which report technology would you use for an off the shelf product? Is it possible to have a OLAP type based reporting side of things from a off the shelf product?
哪种技术最适合历史数据?我猜这里 OLAP 数据库会更快，但这取决于数据库的大小，因为我认为您也可以使用嵌入式报表来获取历史数据.
Which technology is best suited for historical data? I would guess here OLAP database would be quicker, but that would depend the size of the database, because I reckon you could also use Embedded Reports for historical data.
哪种技术最适合定制软件解决方案?
Which technology would be best for custom software solutions?
我喜欢在服务器上进行报告的想法，用户可以在其中登录并像使用 MS 报告服务一样运行报告.并且实际上只有诸如发票、账单、客户信息表等内容的报告作为嵌入式报告.并且还提供基于 OLAP 数据库的报告服务以获取历史数据.
I like the idea of having reporting on the server where a user can go log in and run reports like with MS Reporting services. And really only have reports for stuff like invoices, bills, customer information sheet etc as Embedded reports. And also have Reporting services over an OLAP database for historical data.
不幸的是，管理层没有看到这种布局，而是想要一个现成的产品，在应用程序中直接使用 olap 报告和所有其他报告.
Unfortunelaty does management not see this layout and wants a off the shelf product, with olap reporting right inside the application with all other reports.
推荐答案
OLAP 不是报告平台，它位于数据库层.
OLAP isn't a reporting platform, it's in the database layer.
如果您要收集一系列预先计划好的预设报告，那么 Crystal 或 RS 是最佳创意.就我个人而言，我更喜欢 Crystal，但开发报告可能会非常痛苦 - 但是当它们获得批准时，Crystal 是一个稳定的平台.(我们将 Crystal 与 .NET 应用程序集成.)
If you're going to have a collection of pre-planned, canned reports, then Crystal or RS are the best ideas. Personally I prefer Crystal but it can be quite a pain to develop reports - but when they're approved, Crystal is a rock steady platform. (We integrate Crystal with .NET apps.)
RS 集成得很好，但您必须维护服务器.它们的一大优势是动态/反应式菜单，但它们在不太完美的情况下同样难以开发和维护.
RS integrates just as nicely, but you do have to maintain the server. Their big advantage is dynamic/reactive menuing, but they are just as tricky to develop and maintain when not quite perfect.
OLAP 是一项非常强大的技术 - 但如果您没有本地知识，那么准确部署它是一个非常具有挑战性的产品.但是，同样，它不是报告产品 - 但它上面有一些有趣的层(例如 ProClarity、Excel 插件).
OLAP is a really powerful technology - but if you've not got local knowledge, it's a really challenging product to deploy accurately. But, again, it's not a reporting product - but there are some interesting layers on top of it (e.g. ProClarity, Excel plug-in).
这篇关于哪种报告技术?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
