新项目:SSRS与水晶报表?
我对报告世界本质上是全新的,我负责创建一系列报告,我想知道如何最好的开始。因为我们是微软的商店,现在使用VS 2005,Crystal Reports和SSRS都看起来像可能的候选人。但我想提高我的机会,选择一个赢家出门,所以我在这里问。
I'm essentially brand new to the reporting world, and I've been tasked with creating a series of reports, and I'm trying to figure out how to best start. Since we're a Microsoft shop, using VS 2005 right now, Crystal Reports and SSRS both look like possible candidates. But I'd like to improve my chances for picking a winner out of the gate, so I'm asking here.
我可以想到的关键要素,offhand :
The key elements that I can think of, offhand:
- 报告由网站驱动。
- 报告必须灵活,用户可以要求不同的日期范围,某些列上有特定的过滤器等。
- 数据最初将来自AS400。我们可以有一个中间过程来按摩数据,但是从AS400直接获取数据的能力将是一个加分。
- 其中一些报告需要重复计划
- 这些报告应该可以在网络上查看(html),或者可以下载为Excel或PDF格式。
- EDIT:我们需要为这些报告进行国际化/本地化。
- The reports will be driven by a website. People will be able to create them on demand.
- The reports must be flexible, where the user can ask for different date ranges, specific filters on some columns, etc.
- The data will initially be coming from an AS400. We can have an intermediary process to massage the data, but the ability to take it directly from the AS400 would be a plus.
- Some of these reports will need to be scheduled on a repeating basis, and automatically generated at certain intervals.
- The reports should be viewable on the web (html), or downloadable as Excel or PDF.
- We'll be using C# for the code.
- We need to be able to have internationalization/localization for these reports.
最后,关键问题:
如果两者都可以工作,那么其中一个比另一个更容易或更灵活吗? >
任何帮助(即使只是指向其他网站,指出其中的一个或两个的优点或限制)。
Any help (even if it's just to point me other sites that point out advantages or limitations of one or both of them) would be greatly appreciated.
我认为大多数SO倾向于SSRS而不是水晶报表。
I think most of SO leans towards SSRS over Crystal Reports.
请参阅... 将SQL Server Reporting Services与Crystal Reports比较
我喜欢他们,但我同意他们说SSRS可能更好方式。
I like them both, but I'll agree with them to say that SSRS is probably the better way to go.