MS SQL Reporting Services - Revision history

Gityerfix at 03:26, 27 July 2008

2008-07-27T03:26:27Z

Gityerfix at 06:43, 26 July 2008

2008-07-26T06:43:14Z

Gityerfix at 15:49, 18 July 2008

2008-07-18T15:49:07Z

Gityerfix at 15:45, 18 July 2008

2008-07-18T15:45:34Z

Gityerfix at 01:33, 3 March 2008

2008-03-03T01:33:15Z

Edison234 at 16:19, 28 February 2008

2008-02-28T16:19:12Z

Gregg at 06:05, 23 February 2008

2008-02-23T06:05:16Z

Gregg: New page: Microsoft SQL Reporting Services is a free add-on to MS SQL Server. It was first introduced for SQL Server 2000 as an additional install CD. With SQL Server 2005, it is now included as a...

2008-02-22T08:10:08Z

New page: Microsoft SQL Reporting Services is a free add-on to MS SQL Server. It was first introduced for SQL Server 2000 as an additional install CD. With SQL Server 2005, it is now included as a...

New page

Microsoft SQL Reporting Services is a free add-on to MS SQL Server. It was first introduced for SQL Server 2000 as an additional install CD. With SQL Server 2005, it is now included as an option during a typical install. If it is installed on an existing SQL Server machine, then the only additional cost is for one or more copies of Visual Studio, the development environment for creating the reports.

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Reporting]]
-<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+{{Global Header}}
-To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>
+{{Global Announcement}}
 == Overview ==

@@ Line 1: / Line 1: @@
 [[Category:Reporting]]
-__NOTOC__
+<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
-== What is Reporting Services? ==
+To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>
 Microsoft SQL Reporting Services (SRS) is a free add-on to MS SQL Server.  It was first introduced for SQL Server 2000 as an additional install CD.  With SQL Server 2005, it is now included as an option during a typical install. Depending on the edition you use, you can develop your reports using the Business Intelligence Development Studio (BIDS). BIDS is a full integrated development environment for building and debugging data integration, OLAP, data mining, and reporting solutions.
@@ Line 10: / Line 12: @@
 Using Report Builder, you can create table, matrix, or chart reports. To get started, select a report layout template and then simply drag and drop the fields that you want into the design area. You can then manipulate your data by filtering, grouping and sorting, or working with formulas. Save your report to the report server, and then you can manage it just like any other report on the server. Or, if you want, you can export the report to your local computer as a different file type, such as a TIFF, PDF, Excel, or HTML file.
 == Service Desk and Reporting Services ==
 If you are familiar with developing Service Desk Reports in Crystal or (especially) Access you will feel comfortable in Reporting Services.
 CA provided the DLLs to convert Unixtime to human readable format. This type of conversion is not included with Reporting Services. However, Reporting Services uses Visual Studio as the base for development - this is good, just remember that reports need to make time & date format conversion - for queries and results as well as time zone adjustments.
 Reporting Services provides a historical snapshot feature on your reports. If used in conjuction with Service Desk data purge/archive, this feature creates a long lasting archives of data, formatted in the manner that you wish. Depending on your situation, this can come in handy for SOX compliance & audit. Historical snapshots are scheduled by you and you define the format (PDF? CSV? etc.)
 == Service Desk Data Security ==
 When developing reports, take consideration of your target audience and Service Desk data security.
 Reporting Services can connect to many types of data sources. You can retrieve Service Data via ODBC or Web Services.
@@ Line 30: / Line 26: @@
 Connecting to Service Desk via Web Services will maintain data partitions and access type restrictions. Your report needs to send Service Desk login data and will need to store the Session ID (SID) for the user. After this has been accomplished Reporting Services will need send the query, so it is a bit more complex.
 == External Links ==
 [http://www.microsoft.com/sql/technologies/reporting/default.mspx Microsoft SQL Server]

@@ Line 1: / Line 1: @@
 [[Category:Reporting]]
 == What is Reporting Services? ==
@@ Line 10: / Line 11: @@
 Using Report Builder, you can create table, matrix, or chart reports. To get started, select a report layout template and then simply drag and drop the fields that you want into the design area. You can then manipulate your data by filtering, grouping and sorting, or working with formulas. Save your report to the report server, and then you can manage it just like any other report on the server. Or, if you want, you can export the report to your local computer as a different file type, such as a TIFF, PDF, Excel, or HTML file.
-Click here for more information about Reporting Services[http://www.microsoft.com/sql/technologies/reporting/default.mspx].
 == Service Desk and Reporting Services ==
@@ Line 18: / Line 19: @@
 Reporting Services provides a historical snapshot feature on your reports. If used in conjuction with Service Desk data purge/archive, this feature creates a long lasting archives of data, formatted in the manner that you wish. Depending on your situation, this can come in handy for SOX compliance & audit. Historical snapshots are scheduled by you and you define the format (PDF? CSV? etc.)
 == Service Desk Data Security ==
@@ Line 30: / Line 33: @@
+== External Links ==
+[http://www.microsoft.com/sql/technologies/reporting/default.mspx Microsoft SQL Server]

← Older revision		Revision as of 15:45, 18 July 2008
Line 27:		Line 27:

	Connecting to Service Desk via Web Services will maintain data partitions and access type restrictions. Your report needs to send Service Desk login data and will need to store the Session ID (SID) for the user. After this has been accomplished Reporting Services will need send the query, so it is a bit more complex.		Connecting to Service Desk via Web Services will maintain data partitions and access type restrictions. Your report needs to send Service Desk login data and will need to store the Session ID (SID) for the user. After this has been accomplished Reporting Services will need send the query, so it is a bit more complex.
		+
		+
		+
		+
		+
		+
		+
		+
		+
		+	----
		+	<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
		+	To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>

← Older revision		Revision as of 01:33, 3 March 2008
Line 1:		Line 1:
		+	[[Category:Reporting]]
	== What is Reporting Services? ==		== What is Reporting Services? ==

@@ Line 1: / Line 1: @@
-Microsoft SQL Reporting Services (SRS) is a free add-on to MS SQL Server.  It was first introduced for SQL Server 2000 as an additional install CD.  With SQL Server 2005, it is now included as an option during a typical install.  If it is installed on an existing SQL Server machine, then the only additional cost is for one or more copies of Visual Studio, the development environment for creating the reports.
+== What is Reporting Services? ==
-In many aspects, developing reports in SRS is like developing reports in MS Access.  The interface is similar.  The underlying programming capabilities is similar.  But where SRS really shines is on the server side.  After creating a report in Visual Studio, the report is published to the SRS server.  That report is now available via the reporting web interface or via any application that makes the correct call to the SRS server.  From the web interface, users can either run the reports interactively, or schedule to have a report delivered via email on a recurring basis.
+Microsoft SQL Reporting Services (SRS) is a free add-on to MS SQL Server.  It was first introduced for SQL Server 2000 as an additional install CD.  With SQL Server 2005, it is now included as an option during a typical install. Depending on the edition you use, you can develop your reports using the Business Intelligence Development Studio (BIDS). BIDS is a full integrated development environment for building and debugging data integration, OLAP, data mining, and reporting solutions.
-Starting with SQL Server 2005, SRS includes an ad-hoc reporting feature in the web interface.  A relationships in complex database schema are modeled in the reporting tool to allow end users to quickly create their own reports without having to completely understand the underlying database.
+In many aspects, developing reports in SRS is like developing reports in MS Access.  The interface is similar.  The underlying programming capabilities is similar.  But where SRS really shines is on the server side.  After creating a report in Business Intelligence Development Studio, the report is published to the SRS server.  That report is now available via the reporting web interface or via any application that makes the correct call to the SRS server.  From the web interface, users can either run the reports interactively, or schedule to have a report delivered via email on a recurring basis.

← Older revision		Revision as of 06:05, 23 February 2008
Line 1:		Line 1:
−	Microsoft SQL Reporting Services is a free add-on to MS SQL Server. It was first introduced for SQL Server 2000 as an additional install CD. With SQL Server 2005, it is now included as an option during a typical install. If it is installed on an existing SQL Server machine, then the only additional cost is for one or more copies of Visual Studio, the development environment for creating the reports.	+	Microsoft SQL Reporting Services (SRS) is a free add-on to MS SQL Server. It was first introduced for SQL Server 2000 as an additional install CD. With SQL Server 2005, it is now included as an option during a typical install. If it is installed on an existing SQL Server machine, then the only additional cost is for one or more copies of Visual Studio, the development environment for creating the reports.
		+
		+	In many aspects, developing reports in SRS is like developing reports in MS Access. The interface is similar. The underlying programming capabilities is similar. But where SRS really shines is on the server side. After creating a report in Visual Studio, the report is published to the SRS server. That report is now available via the reporting web interface or via any application that makes the correct call to the SRS server. From the web interface, users can either run the reports interactively, or schedule to have a report delivered via email on a recurring basis.
		+
		+	Starting with SQL Server 2005, SRS includes an ad-hoc reporting feature in the web interface. A relationships in complex database schema are modeled in the reporting tool to allow end users to quickly create their own reports without having to completely understand the underlying database.