什么是你可以使用报告工具？ [英] What is the reporting tool that you would use?

问题描述

我需要一个工具，同时处理屏幕和打印报告，通过我的C＃应用​​程序。

I need a tool that handle both on-screen and printed reports, via my C# application.

我在寻找简单，标准，功能强大。

I'm looking for simple, standard and powerful.

我需要能够让用户选择要显示的列的能力，格式等..我自己的GUI和动态地构建基于报告他们的选择。水晶这里不适合该法案，因为该列不能在飞行中添加（和列宽不能动态调整）。

I need to be able to give the user the ability to select which columns to display, formatting, etc... with my own GUI and dynamically build the report based upon their choices. Crystal does not fit the bill here because the columns cannot be added on the fly (and the column widths can not be adjusted on the fly).

我在想使用HTML，在我的应用程序WebBrowser控件，但我将拥有打印和打印预览很难控制。

I'm thinking of using HTML with the WebBrowser control in my app, but I will have very little control over printing and print preview.

另一种选择是去.NET 3.5（我使用2.0），并使用带流量的文档XAML。

Another option is go to .NET 3.5 (I'm using 2.0) and use XAML with Flow Documents.

你会用什么？

推荐答案

我们使用SQL报告服务。 HTML报告有其重要性，但你没有得到过的格式非常多的控制。

We use SQL reporting services. HTML reports have their place but you dont get very much controlling over formatting.

SQL Reporting Services的总结：

SQL reporting services summary:

优点：

Basic版本附带SQL免费

表达

许多导出选项PDF，HTML，CSV等

可以使用许多不同的数据源

Webservice的暴露出

SQL标准的Editon包括报表生成器组件，允许用户创建和共享他们自己的报告
$的特征b $ b阄查询格式化等
$ b $各种方法b调度选项

扩展进口的.NET Framework的DLL实现自定义功能

熟悉的Microsoft环境




缺点：

额外的东西应用和报表服务器之间建立

无缝认证可以根据您的设置

虽然它不算一个学习曲线的一点点痛很难拿起

报表模型的创建者需要一些工作和犯规自动AZ域




我听说过DevXpress好的东西，可能是值得的寻找到。

Advantages:
Basic version is free
Included with SQL express
Many exporting options pdf, html, csv etc
Can use many different datasources
Webservice which exposes various methods
SQL standard editon includes a report builder component to allow users create and share their own reports
Lots of features for querying formatting etc
Scheduling options
Extensibility import .net framework dlls for custom functionality
Familiar microsoft environment


Disadvantages:
An extra thing to setup
Seemless authentication between application and report server can be a pain depending on your setup
A little bit of a learning curve although its not too hard to pick up
Report model creator needs some work and doesnt automatically a-z fields


I have heard good things about DevXpress so may be worth looking into.

我用水晶大约5年前，记住它是一个痛苦的设置，是明智的昂贵的许可证。

I used Crystal about 5 years ago and remember it being a pain to setup and was costly licence wise.

这篇关于什么是你可以使用报告工具？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！