Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Professional Microsoft SharePoint 2007 Reporting with SQL Server 2008 Reporting Services [Paperback]

Coskun Cavusoglu , Jacob J. Sanford , Reza Alirezaei

List Price: CDN$ 71.99
Price: CDN$ 45.35 & FREE Shipping. Details
You Save: CDN$ 26.64 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Usually ships within 2 to 4 weeks.
Ships from and sold by Amazon.ca. Gift-wrap available.
Join Amazon Student in Canada


Book Description

Sept. 22 2009 Wrox Programmer to Programmer
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.


Customers Who Bought This Item Also Bought


Product Details


Product Description

From the Back Cover

SharePoint is first and foremost a web portal full of reportable data that offers numerous possibilities within an organization. With SQL Server Reporting Services (SSRS), Microsoft offers its own server-based report generation software that is tightly integrated within the SQL Server infrastructure. Integrating SharePoint with SSRS allows the two technologies to create awe-inspiring reports that actively provide information to those who need it. This book walks you through the various challenges of combining SharePoint 2007 with SSRS 2008, and provides you with tips and tricks for handling the obstacles that you may face when attempting to develop reports in your SharePoint environment.

You'll discover the new features of SSRS 2008 while also learning helpful techniques for creating quick and engaging reports when using it. The author team explains special considerations you'll need to take into account when setting up SSRS to run in SharePoint integration mode with WSS 3.0 or MOSS 2007. From the beginning stages of creating an environment that supports SSRS in SharePoint integration mode to the process of planning, developing, and deploying reports to a SharePoint site, this book clearly explains why SharePoint integration mode is ideal for SSRS when dealing with a SharePoint environment.

What you will learn from this book

  • The best way to set up SQL Server Reporting Services for SharePoint 2007

  • Best practices for effectively developing and deploying reports in SharePoint

  • Tips for creating your first report

  • Ways to configure reporting services to run in SharePoint integration mode

  • Various advanced reporting and deployment techniques

  • How to manage reports in SharePoint and use gauges in SharePoint dashboards

Who this book is for

This book is for SharePoint developers who want to know the new features of Microsoft SQL Server 2008 Reporting Services so they can develop and deploy reports in SharePoint.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

About the Author

Coskun Cavusoglu is the Director of Consulting Services and the Chief Solution Architect of Captaré Consulting, LLC. He has been architecting and implementing technology solutions for more than 10 years in both large, enterprise organizations and fast - growth midmarket firms. As a Software Engineer specializing in the .NET Framework and the Office Server System, specifically Windows SharePoint Services and Microsoft Office SharePoint Server, he has extensive experience designing, implementing, and supporting Internet solutions using Microsoft technologies. Coskun is a technology writer, blogger, and published author on Microsoft server products. His latest book which he co - authored with fellow SharePoint experts is Professional Microsoft SharePoint 2007 Design by Wrox Publishing. He also is a speaker who attends various community events both locally and internationally where he talks about SharePoint topics and his past and future engagements can be found at his blog, www.Share-PointCoskun.com . Coskun is a Microsoft Certified Professional and is also an MCTS for SharePoint Portal Server 2003 and Microsoft Office SharePoint Server 2007.

Jacob J. Sanford is a senior consultant with Resolute Solutions Corporation, a Microsoft Gold Certified Partner and a National Systems Integrator. He has been working with web application development using Microsoft technologies for more than 10 years, specializing in .NET solutions since the 1.0/1.1 Framework. Jacob is a frequent speaker at local and regional .NET and SharePoint events and is the creator of the Tallahassee SharePoint Experts Exchange for Developers (SPEED), a SharePoint User Group in Tallahassee, FL. He has written two previous books for Wrox Press: ASP.NET 2.0 Design (September 2007) and Professional Microsoft SharePoint 2007 Design (September 2008). Jacob is a Microsoft Certified Technology Specialist in the .NET Framework 2.0 (Web Applications) and a Microsoft Certified Technology Specialist (Microsoft Dynamics CRM 4.0 Customization and Configuration).

Reza Alirezaei is an independent consultant and Microsoft Office SharePoint Server MVP with a focus on developing custom solutions with SharePoint, Office, Reporting Services, and the .NET platform. As a technical leader with more than 10 years of experience in software, he has helped many development teams architect and build large - scale, mission - critical applications. This former SQL Server Reporting Services MVP has been also nominated and awarded three times as one of the Top 20 Contributors to the Microsoft Developer Network (MSDN) Wiki since 2006. In addition to consulting, Reza is a SharePoint instructor and speaker. He speaks at many local and international conferences. Reza frequently blogs at http://blogs.devhorizon.com/reza and can be reached at reza@devhorizon.com .


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

There are no customer reviews yet on Amazon.ca
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 5.0 out of 5 stars  4 reviews
2 of 2 people found the following review helpful
5.0 out of 5 stars An excellent "must own" book on SRSS and SharePoint Nov. 3 2009
By Michael Drips - Published on Amazon.com
Format:Paperback|Verified Purchase
As a leading SharePoint expert, I make it a point to own all books on SharePoint and this particular title is one of the few titles I would list as a "must have" for one's SharePoint library. This literally is the ONLY book on utilizing SSRS with SharePoint. The knowledge contained and shared within this book is not information that you can readily find on the Internet (unlike many other technical books).

The authors focus on SQL Server 2008 is spot on. There will always be people that are behind the technical curve ball running older versions of software. It's not like there is such a radical difference between SQL 2008 and prior versions that a reader couldn't bridge the information gap for utilizing this book's information.

Setting up SSRS with SharePoint 2007 (MOSS for you purists out there) is worth the price of the book alone. Deploying reports to SharePoint is very well written although there are several other nuances one might use in said deployment.

The coverage of BI within SSRS and SharePoint is yet another great reason for owning this book. Once again it has details that one will not easily find outside of one's own user experience. Gauges on SharePoint dashboards is yet another area of coverage on a feature that pleases clients, providing a rich visual environment for BI.

There's no need to cover scalability, availability or recovery in this book as any experienced SQL Server or SharePoint administrator will be able to handle those areas within their current environment. All in all, this book is an absolutely excellent resource for SharePoint architects, developers and consultants.

I would highly recommend this book to anyone who has a serious role with SharePoint.
4 of 5 people found the following review helpful
5.0 out of 5 stars Unique book for SharePoint Integrated SSRS Space.. Oct. 2 2009
By Nikunj Patel - Published on Amazon.com
Format:Paperback|Verified Purchase
In general, I think it's really nice book in the SharePoint-SSRS space and extremely good companion to SQL Server 2008 Books Online. It focuses only on the SQL Server Reporting Services 2008 Integration with WSS 3.0 and MOSS 2007. It does not cover the SSRS 2005. Many folks still working on the SSRS 2005 might feel overlooked but I would still read this book for lots of other SharePoint Integrated SSRS topics.

In general, if you would like to learn MOSS 2007 or WSS 3.0, do not pick up this book. There are lots of other books focusing solely on the SharePoint in the Wrox Series. If you are new to SSRS 2008, this book does really good job on explaining the SSRS technologies. There are 50% of chapters focusing on the SSRS 2008. Again if you want to learn only SSRS, look for other great books out there.

Chapter 1, 3, 4, and 5 are focused on the SSRS 2008 - These chapters provides SSRS 2008 and BIDS 2008 overviews, how to plan your report project, creating the first SSRS report, and advance reporting techniques. If you know your SSRS, you can easily skip these chapters.

For guys like me who know both technologies very well and would like to focus only on the SSRS integration with SharePoint, there are 7 wonderfully written chapters with some outstanding tips and screenshots.

Chapter 2: Setting up the SQL Server Reporting Services for SharePoint 2007 provides step by step installation and configuration of SharePoint Integrated SSRS environment. It has wealth of tips with wonderful indepth screenshots. I would definitely keep this handy if I am configuring the environment first time.

Chapter 6 and 7: Consuming the SharePoint Lists in the SSRS reports - This is a great reference if you need to consume the SharePoint lists in the SSRS. It talks about the limitations of the SharePoint List Web Service and how you can build the custom web service to consume the multiple SharePoint Lists data. A brilliant chapters in general.

Chapter 8: Deploying Reports to the SharePoint. This is excellent chapter demonstrating how to prepare SharePoint environment to host the SSRS reports and how to deploy the reports from the BIDS 2008. This chapter is great companion of the Chapter 2 for the initial configuration.

Chapter 9: Advanced Deployment Techniques. This chapter is unique. If you want to automate the SSRS report deployment to the SharePoint, you must buy this book. I am yet to find good blog or online article on this subject and authors have done great job automating deployment through power shell scripts and SharePoint features and solution framework.

Chapter 10: Displaying your reports in SharePoint Integrated Mode. This is another gem. It talks about the how to use Report Viewer Web Part and how to customize the report display using various techniques like connecting through WCF service or creating the SharePoint application pages. Again, I would simply buy this book for Chapter 9 and 10.

Chapter 11: Managing Reports - There are mix of SSRS and MOSS information in this chapter. Some of the highlights of this chapter are advance configurations like reports subscription, report execution configuration.

Chapter 12: Using Gauges in SharePoint Dashboards - This chapter does really nice job adding gauges in the SSRS reports and SharePoint Dashboards. I have overlooked this chapter but would keep it handy if I ever need them for any client needs.

Finally - Are there any criticisms? - Only criticism I have for this book is it has lot more chapters focusing on the SSRS 2008. I wish there are specific chapters focused on the Report Server Scaled Out deployment. In real world, most of the MOSS Integrated SSRS farm needs to take care of high availability, redundancy, and disaster recovery requirements. If Authors have dedicated a specific chapter for the MOSS Integrated SSRS scaled-out deployment, this would one gem of the books for me.

Regardless of this criticism, overall, it is a really nice book to have for the SharePoint Integrated SSRS administrators.

On the side note - I had a wonderful time discussing scaled out deployment scenario with Reza Alirezaei, one of the Authors of the book. He was very generous to exchange series of emails while I was designing the scaled out MOSS Integrated SSRS environment. Thanks Reza for the help.
5.0 out of 5 stars I wish I had this book a year ago May 7 2010
By T. Anderson - Published on Amazon.com
Format:Paperback|Verified Purchase
I wish I had this book a year ago. It does an excellent job of describing the Reporting Services configuration steps to set up SharePoint Integration mode. It can be pretty confusing the first time.

It does not have any information on the Report Viewer web parts that come with SQL Server that can be installed and used to run against a Report Manager instance. The last place we tried to set up SharePoint Integration mode we could not get it done because Kerberos had everything hosed up. We ended up just using the web parts that come with SQL Server.

The book has several chapters on using Business Intelligence Design Studio (BIDS). The chapters span beginner to advanced techniques.

I have been working with Reporting Services for 5 - 6 years now and have had to learn the hard way that you should plan your report projects. It may be tempting to skip the chapter on planning report projects, but don't, there is a lot of good advice in it.

The authors also include a nice chapter on advanced deployment techniques. It is nice when you can just use BIDS to deploy, but often you need more options, especially in a production environment.

They also include a nice chapter on using the gauges. Nowadays everyone wants a dashboard, and throwing in a gauge or two to wow the business owners never hurts.

All in all I highly recommend this book for anyone getting into using Reporting Services with SharePoint.
5.0 out of 5 stars Easy to get started May 14 2011
By Gary Brunner - Published on Amazon.com
Format:Paperback|Verified Purchase
Easy to read, you can dive right into the samples and practice what you have read. Broken down nicely to enable you to only perfect the specific tasks you are needing to accomplish.

Look for similar items by category


Feedback