Professional Microsoft® SharePoint® Server 2007 Reporting with SQL Server 2008 Reporting Services

Professional Microsoft® SharePoint® Server 2007 Reporting with SQL Server 2008 Reporting Services

by Coskun Cavusoglu, Jacob Sanford, Reza Alirezaei
Released September 2009
Publisher(s): Wrox
ISBN: 9780470481899

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Essential guide to developing and deploying high-profile reports in SharePoint

Build customized reports quickly and efficiently with SQL Server 2008 Reporting Services for SharePoint sites and this unique guide. Developers, you'll learn report development and deployment; SharePoint or SQL Server Reporting Services administrators, you'll see how to leverage SharePoint to use SQL Server Reporting Services in SharePoint Integrated Mode.

This valuable book walks users through the entire process: planning, developing, and deploying reports. You'll discover techniques, tricks, and workarounds that allow you to produce great-looking charts and reports for your SharePoint sites.

  • SQL Server Reporting Services (SSRS) is the customizable reporting solution for any developer using VB, C#, or ASP.NET who ties into SQL Server to build reports or generate data analysis; SharePoint is Microsoft's portal development platform and is central to the Microsoft Office and developer platform

  • This book from an expert author team of Microsoft SharePoint 2007 developers covers not only topics relevant to developers, it also goes into the specific nuances of using these reports in a SharePoint environments, such as what to consider when setting up SSRS to run specifically in SharePoint integration mode with WSS 3.0 or MOSS 2007

  • Topics include introduction to SQL Server Reporting Services, setting up SQL Server Reporting Services for SharePoint 2007, planning your report project, an overview of Business Intelligence Design Studio (BIDS) 2008, intermediate and advanced reporting techniques, deploying to SharePoint 2007, displaying reports, and more

    • Discover new, efficient ways to leverage your core investment in SharePoint 2007 with this one-of-a-kind guide.

    Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

    Table of contents

    1. Copyright
    2. Dedication
    3. About the Authors
    4. Credits
    5. Acknowledgments
    6. Introduction
    7. An Introduction to SQL Server Reporting Services
      1. What Is SQL Server Reporting Services (SSRS)?
      2. SSRS Deployment
      3. Summary
    8. Setting up SQL Server Reporting Services for SharePoint 2007
      1. Why SharePoint Integrated Mode?
      2. Planning for SharePoint Integration
      3. Installing Reporting Services in SharePoint Integrated Mode
      4. Summary
    9. Planning Your Report Project
      1. Educating Your Clients about SSRS Reports
      2. Gathering Requirements for Reports
      3. Summary
    10. Overview of Business Intelligence Design Studio (BIDS) 2008
      1. Introduction to BIDS 2008
      2. Using BIDS 2008 on Your Machine
      3. Creating Report Projects Using BIDS
      4. Summary
    11. Creating Your First Report
      1. Creating Your Data Backend
      2. Creating Your First Report
      3. Summary
    12. Intermediate Reporting Techniques
      1. Creating a Linked Report
      2. Accessing a SharePoint List
      3. Summary
    13. Advanced Reporting Techniques
      1. Creating a Custom Solution
      2. Summary
    14. Deploying Reports to SharePoint
      1. Preparing Your SharePoint Environment
      2. Deploying Reports with Business Intelligence Design Studio (BIDS)
      3. Deploying Reports with Report Builder 2.0
      4. Setting Permissions on Report Items on a SharePoint Site
      5. Summary
    15. Advanced Deployment Techniques
      1. Understanding the Publishing Process
      2. Automating Report Deployment
      3. Deploying in More of a SharePoint Way
      4. Summary
    16. Displaying Your Reports in SharePoint Integrated Mode
      1. The Out-of-the-Box UI Experience
      2. The Connectable Report Viewer Web Part
      3. Reporting against SharePoint Lists
      4. Displaying Your Reports Your Way
      5. Summary
    17. Managing Reports
      1. Client Tools for Management
      2. Scalability Planning
      3. Managing Data Sources
      4. Understanding On-Demand Report Execution
      5. Report Processing Options
      6. Static and Data-Driven Subscriptions
      7. Summary
    18. Using Gauges in SharePoint Dashboards
      1. Adding a Gauge to an Existing Report
      2. Customizing the Appearance of a Gauge
      3. Creating Gauges that Use SharePoint Data
      4. Summary
    19. Index

    Product information

    • Title: Professional Microsoft® SharePoint® Server 2007 Reporting with SQL Server 2008 Reporting Services
    • Author(s): Coskun Cavusoglu, Jacob Sanford, Reza Alirezaei
    • Release date: September 2009
    • Publisher(s): Wrox
    • ISBN: 9780470481899