Can someone explain me about SQL Server Reporting Service and using it in ASP.net?
有人可以向我解释一下SQL Server Reporting Service并在ASP.net中使用它吗?
Typically I design my reports by Crystal Report, assign the data source to crystal report an produce my report.
通常我会通过Crystal Report设计我的报告,将数据源分配给crystal report并生成我的报告。
What is the benefits of using SQL Server Reporting Service and how to use it?
使用SQL Server Reporting Service有什么好处以及如何使用它?
4 个解决方案
#1
11
SQL Server Reporting Services (SSRS) is a competitor to Crystal Reports. It's a way of defining reports, just like Crystal Reports, and an engine for running those reports.
SQL Server Reporting Services(SSRS)是Crystal Reports的竞争对手。这是一种定义报表的方式,就像Crystal Reports一样,以及运行这些报表的引擎。
SSRS itself is a website that hosts these reports and can serve them to users through a web interface, or can schedule them for delivery over e-mail.
SSRS本身是一个托管这些报告的网站,可以通过Web界面为用户提供服务,也可以安排它们通过电子邮件发送。
As a programmer, I prefer SSRS over Crystal due, among many other things, to the fact that it's more stable and uses an XML-based report file format, unlike Crystal's old binary format. That means that certain design tasks can be done simply by editing XML if it comes down to it.
作为程序员,我更喜欢SSRS而不是Crystal,因为它更稳定并且使用基于XML的报告文件格式,这与Crystal的旧二进制格式不同。这意味着某些设计任务只需编辑XML即可完成。
#2
2
Read all about it in the SQL Server Books Online.
在SQL Server联机丛书中阅读所有相关内容。
It's more or less the same thing as Crystal Reports - a reporting engine and designer. The SSRS has some benefits over Crystal: it's server-based, e.g. you can have your reports be handled and prepared on the server (e.g. on a nightly schedule, and distribute them by e-mail or something) - but also allows local execution of reports.
它与Crystal Reports(报告引擎和设计师)或多或少相同。 SSRS比Crystal有一些好处:它是基于服务器的,例如您可以在服务器上处理和准备报告(例如,按照每晚的时间表,通过电子邮件或其他方式分发) - 但也允许本地执行报告。
Due to the fact it's a Microsoft product, it's more tightly integrated with SQL Server and Windows than Crystal Reports.
由于它是微软的产品,它与SQL Server和Windows的集成程度比Crystal Reports更紧密。
And if you have a valid SQL Server license, you have Reporting Services - it's a free add-on to SQL Server.
如果您拥有有效的SQL Server许可证,则可以使用Reporting Services - 它是SQL Server的免费附加组件。
#3
1
It's the reporting solution offered by Microsoft. You get it included if you have a MS SQL server license. Wiki gives more detail: http://en.wikipedia.org/wiki/SQL_Server_Reporting_Services
这是微软提供的报告解决方案。如果您拥有MS SQL Server许可证,则可以获得它。 Wiki提供了更多细节:http://en.wikipedia.org/wiki/SQL_Server_Reporting_Services
And here's more info from Microsoft: http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspx
以下是来自Microsoft的更多信息:http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspx
Basically, you install the Report Server software, which runs a website and webservices that you can then use to host reports. The reports themselves are built using Visual Studio, and quite easy to create. Saying that, you CAN make very complex reports by using multiple queries and scripting.
基本上,您安装报表服务器软件,该软件运行网站和Web服务,然后您可以使用它们来托管报表。报告本身是使用Visual Studio构建的,非常容易创建。这样说,您可以通过使用多个查询和脚本来制作非常复杂的报表。
As Dave mentioned, it's got pretty good integration with the whole Microsoft Stack.
正如Dave所说,它与整个Microsoft Stack集成得非常好。
HTH, Lance
#4
1
This link is helpful and explains how to use it http://www.simple-talk.com/sql/reporting-services/beginning-sql-server-2005-reporting-services-part-1/
这个链接很有用,并解释了如何使用它http://www.simple-talk.com/sql/reporting-services/beginning-sql-server-2005-reporting-services-part-1/
#1
11
SQL Server Reporting Services (SSRS) is a competitor to Crystal Reports. It's a way of defining reports, just like Crystal Reports, and an engine for running those reports.
SQL Server Reporting Services(SSRS)是Crystal Reports的竞争对手。这是一种定义报表的方式,就像Crystal Reports一样,以及运行这些报表的引擎。
SSRS itself is a website that hosts these reports and can serve them to users through a web interface, or can schedule them for delivery over e-mail.
SSRS本身是一个托管这些报告的网站,可以通过Web界面为用户提供服务,也可以安排它们通过电子邮件发送。
As a programmer, I prefer SSRS over Crystal due, among many other things, to the fact that it's more stable and uses an XML-based report file format, unlike Crystal's old binary format. That means that certain design tasks can be done simply by editing XML if it comes down to it.
作为程序员,我更喜欢SSRS而不是Crystal,因为它更稳定并且使用基于XML的报告文件格式,这与Crystal的旧二进制格式不同。这意味着某些设计任务只需编辑XML即可完成。
#2
2
Read all about it in the SQL Server Books Online.
在SQL Server联机丛书中阅读所有相关内容。
It's more or less the same thing as Crystal Reports - a reporting engine and designer. The SSRS has some benefits over Crystal: it's server-based, e.g. you can have your reports be handled and prepared on the server (e.g. on a nightly schedule, and distribute them by e-mail or something) - but also allows local execution of reports.
它与Crystal Reports(报告引擎和设计师)或多或少相同。 SSRS比Crystal有一些好处:它是基于服务器的,例如您可以在服务器上处理和准备报告(例如,按照每晚的时间表,通过电子邮件或其他方式分发) - 但也允许本地执行报告。
Due to the fact it's a Microsoft product, it's more tightly integrated with SQL Server and Windows than Crystal Reports.
由于它是微软的产品,它与SQL Server和Windows的集成程度比Crystal Reports更紧密。
And if you have a valid SQL Server license, you have Reporting Services - it's a free add-on to SQL Server.
如果您拥有有效的SQL Server许可证,则可以使用Reporting Services - 它是SQL Server的免费附加组件。
#3
1
It's the reporting solution offered by Microsoft. You get it included if you have a MS SQL server license. Wiki gives more detail: http://en.wikipedia.org/wiki/SQL_Server_Reporting_Services
这是微软提供的报告解决方案。如果您拥有MS SQL Server许可证,则可以获得它。 Wiki提供了更多细节:http://en.wikipedia.org/wiki/SQL_Server_Reporting_Services
And here's more info from Microsoft: http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspx
以下是来自Microsoft的更多信息:http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspx
Basically, you install the Report Server software, which runs a website and webservices that you can then use to host reports. The reports themselves are built using Visual Studio, and quite easy to create. Saying that, you CAN make very complex reports by using multiple queries and scripting.
基本上,您安装报表服务器软件,该软件运行网站和Web服务,然后您可以使用它们来托管报表。报告本身是使用Visual Studio构建的,非常容易创建。这样说,您可以通过使用多个查询和脚本来制作非常复杂的报表。
As Dave mentioned, it's got pretty good integration with the whole Microsoft Stack.
正如Dave所说,它与整个Microsoft Stack集成得非常好。
HTH, Lance
#4
1
This link is helpful and explains how to use it http://www.simple-talk.com/sql/reporting-services/beginning-sql-server-2005-reporting-services-part-1/
这个链接很有用,并解释了如何使用它http://www.simple-talk.com/sql/reporting-services/beginning-sql-server-2005-reporting-services-part-1/