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.
11.6. Static and Data-Driven Subscriptions
Rather than allowing users to connect to a SharePoint site to view reports, it is often required that reports be delivered to them in various ways other than browser-based access. None of the report-processing techniques (cached instances and snapshots) covered in this chapter so far offer an automated way of delivering a report to end users.
As previously discussed, on-demand report execution requires that users actively request reports each time they want to view them, which may introduce some performance overhead. Thankfully, Reporting Services offers subscriptions that can be used to schedule and then automate the delivery of reports via email, to a network folder, or even through periodic dumps in a SharePoint document library where users have set up alerts to get notified when a new item is added.
In this section, you learn how to work with static and data-driven subscriptions to provide a more flexible report-delivery mechanism that runs in the background.
11.6.1. Understanding Delivery Extensions
Once a report is published to SharePoint, it can be executed on demand, or the execution output can be delivered to various locations on a designated schedule. A report server instance configured for SharePoint integration includes four delivery extensions that enable you to distribute reports within your organization to various locations. Delivery extensions are the heart of subscription. For now, let's just take a brief look at what ...
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.