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.
5.2. Creating Your First Report
Now that you have the database and BIDS (see Chapter 4), you are ready to create your first report. There are two primary ways to create reports: using the Report Wizard or from scratch. You will learn to create a report from scratch in the next chapter. However, in order to introduce you to the concepts involved in creating any report, this chapter will use the wizard. Hopefully, by the end of Chapters 5 and 6, you will have a pretty good idea of the differences between both approaches and be able to decide which method to use for your own reporting needs.
And, with that, it's time to start your report.
5.2.1. Creating the Dataset
A report is essentially a representation of data, right? Well, at least in the world of Reporting Services this is true. You are creating a way of looking at data that will help those using the report to understand it and use it to make business decisions. If they looked at business data sitting in a SQL table, the data wouldn't make much sense. However, with Reporting Services, you are taking raw data and putting it in a form that non-technical people can understand. The key to all of this is the data. You must have a set of data to feed the report, or the report is useless.
As discussed previously in this chapter, these reports all use the Adventure Works databases freely available from Microsoft. However, you will still need to generate a dataset for your report to use. This can be done in several different ways. ...
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.