September 2009
Intermediate to advanced
476 pages
11h 39m
English
book
Professional Microsoft® SharePoint® Server 2007 Reporting with SQL Server 2008 Reporting Services
by Coskun Cavusoglu, Jacob Sanford, Reza Alirezaei
Content preview from Professional Microsoft® SharePoint® Server 2007 Reporting with SQL Server 2008 Reporting Services
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
1.1. What Is SQL Server Reporting Services (SSRS)?
SQL Server Reporting Services (SSRS) is a server-based reporting platform that allows you to deploy professional-looking and powerful reports fairly easily (once everything is set up). You get the drag-and-drop functionality that you may be familiar with if you have used any version of Visual Studio over the years. You can literally drop a chart onto your report, drag some data fields to the chart, and then deploy the report. You can also do more powerful things such as create pie charts where each pie segment, when clicked, takes the user to a related matrix of data where they can drill down even further to find more detail.
One of the nicer details about SSRS is that it will allow you, as a developer, to access a variety of data sources to feed the report. Of course, since it is a SQL Server product, you can easily tie into your SQL Server database. But beyond that, you can connect to a whole slew of other data objects, as seen in the following table (obtained from http://msdn.microsoft.com/en-us/library/ms159219.aspx):
| Source of Report Data | Reporting Services Data Source Type | Version of Data Source |
|---|---|---|
| SQL Server relational database | Microsoft SQL Server | SQL Server 2008
SQL Server 2005 SQL Server 2000 SQL Server 7.0 |
| SQL Server relational database | OLEDB | SQL Server 2008
SQL Server 2005 SQL Server 2000 SQL Server 7.0 |
| SQL Server relational database | ODBC | SQL Server 2008
SQL Server 2005 SQL Server 2000 SQL Server 7.0 |
| Analysis Services multidimensional ... |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.