Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports [Paperback]

Paul Turley (Author), Robert M. Bruckner (Author)

Book Description

Publication Date: April 5, 2010 | ISBN-10: 0470563117 | ISBN-13: 978-0470563113 | Edition: 1

Learn to design more effective and sophisticated business reports

While most users of SQL Server Reporting Services are now comfortable designing and building simple reports, business today demands increasingly complex reporting. In this book, top Reporting Services design experts have contributed step-by-step recipes for creating various types of reports.

Written by well-known SQL Server Reporting Services experts, this book gives you the tools to meet your clients' needs

Editorial Reviews

From the Back Cover

Step-by-step instructions show you how to create expert reports

Have you mastered the "how-tos" of Reporting Services? Can you confidently design simple reports—but now you need help with meeting the demands of more complex and advanced types of reports? If so, this is the ideal resource for you. Packed with proven design practices, this book serves as a collection of recipes for solving design problems so that you don't have to reinvent the wheel with each challenge you face. Organized by specific types of reports, the book covers grouped reports, charts, composite reports, dashboards, forms and labels, interactive reports, and more. Step-by-step instructions allow you to implement these best practices immediately so that you can solve your own design hurdles quickly.

SQL Server Reporting Services Recipes:

• Reviews basic report design concepts and components

• Covers localization, data sorting and filtering, handling dynamic data sources, and more

• Presents design solutions that can work with any release of SQL Server Reporting Services, including specific recipes for 2008 R2

• Shows how to aggregate semi-additive measures in a report

• Features a companion web site that provides finished report examples and data you need to design each recipe in the book

Programmer Forums
Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.

Code Downloads
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.

Read More
Find articles, ebooks, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

wrox.com

About the Author

Paul Turley is a business intelligence solution architect and manager for Hitachi Consulting. He is a Microsoft MVP and Certified Trainer. He designs solutions and teaches classes on SQL Server technologies to companies around the world. Paul is the author of several books, including Professional SQL Server Reporting Services (2000/2005/2008).

Robert M. Bruckner is a technical lead with the Microsoft SQL Server product team. His core area of responsibility is the development of the report processing engine of Reporting Services. Robert frequently shares Reporting Services tips on his popular blog at http://blogs.msdn.com/robertbruckner.

Product Details

• Paperback: 648 pages
• Publisher: Wrox; 1 edition (April 5, 2010)
• Language: English
• ISBN-10: 0470563117
• ISBN-13: 978-0470563113
• Product Dimensions: 7.4 x 1.3 x 9.3 inches
• Shipping Weight: 2.4 pounds
• Average Customer Review: 3.6 out of 5 stars  See all reviews (13 customer reviews)
• Amazon Best Sellers Rank: #396,453 in Books (See Top 100 in Books)

More About the Author

Paul is a Mentor for SolidQ and a Microsoft Most Valuable Professional (MVP) for SQL Server and BI. He's an active member of the SQL Server community and Director of the Oregon SQL user group. He has authored and co-authored 12 books including the Wrox Press series for Reporting Services and books and other BI and database reporting topics. He has been architecting, managing and developing applications and business intelligence solutions for since 1992. He teaches, develops training courseware, speaks at industry conferences. He speaks at Microsoft Tech-Ed and has presented at the Professional Association for SQL Server (PASS) global summit since 2004. He is an MSDN forum moderator for SQL Server Reporting Services and has been a Microsoft Certified Trainer and MCP since 1996, holding MCITP, MCTS, MCSD & MCDBA certifications.

Paul has authored or co-authored the following:

Professional SQL Server 2012 Reporting Services (Wrox Press) - in production
SQL Server MVP Deep Dives vol. 2 (Manning Press)
Reporting Services Recipes for Expert Reports (Wrox Press)
Beginning T-SQL for SQL Server 2005 and 2008 (Wrox Press)
Beginning Transact-SQL for SQL Server 2000 and 2005 (Wrox Press)
Professional SQL Server 2008 Reporting Services (Wrox Press)
Professional SQL Server 2005 Reporting Services (Wrox Press)
Professional SQL Server Reporting Services (2000) (Wrox Press)
SQL Server 2005 Integration Services Step by Step (Microsoft Press)
Beginning SQL Server 2005 Administration (Wrox Press)
Professional SQL Server 2000 Data Warehousing with Analysis Services (Wrox Press)
Professional Access 2000 Programming (Wrox Press)

Most Helpful Customer Reviews

9 of 9 people found the following review helpful

3.0 out of 5 stars Got some useful things from it August 30, 2011

By ThePocketDBA

Format:Paperback|Amazon Verified Purchase

Pro:

For those of us always looking for ways to keep sharpening our SSRS skills, there is value to be found here. Patience is needed. Sometimes it just needs a little thought and fiddling to figure out the author's intent. This applies especially to the SSAS reports.

If you have the patience, you are going to be hard pressed to find another book that will help you dig into the topic of building "expert" reports. So many other books give an overview of SSRS and do not spend enough time with the ins and outs of actual SSRS report writing. At least with any depth.

Con:

I do not think this book needs to be slammed with a one star to make the point that the editing could have been better but I do think the review by Mr. Zucker deserves a better response from Mr. Turley than it got.

It is not our job, Mr. Turley, to spend OUR time editing YOUR book. You are supposed to be the expert that knows more than us and, thus, can either do a better job of reviewing your own work or finding someone who you feel is on your level who can do it for you and has the time. Your response to Mr. Zucker seemed to imply that we should send you money for your book so we can edit it for you.

The reviews written after Mr. Zucker's also seemed to go to the other extreme, almost sounding like friends of the author reacting to the negative comments of Mr. Zucker or, perhaps, as people who are already expert enough to recognize the value in the content of the book but not really needing it themselves. Such people would care far less about any of the things in the book that were of primary concern to Mr. Zucker or anyone else trying to learn new things.

5 of 5 people found the following review helpful

4.0 out of 5 stars This book saved me days! September 20, 2010

By Michael J. Lynott

Format:Paperback

MS SQL Server Reporting tools do not easily allow you to create "horizontal" reports--where the next item to be reported appears to the right, rather than below. I needed to create such a report. And I couldn't figure out how to do so until I found the example titled "Horizontal Reports" in this book. I literally tried for days to find a solution on my own without success. Did I have to work around some of the directions in the book? Yes. But I note also that there's an on-line forum where concerns and frustrations are being answered. And many of the recipes reference an online entry that inspired the article. I'll be recommending this book to my colleagues, since MS SQL Server Reporting tools are our corporate standard. (Note--I don't know the authors, I'm not related to any of them, and I don't work for any of the companies involved.)

4 of 4 people found the following review helpful

5.0 out of 5 stars Advance your SSRS skills September 28, 2010

By kmtdf

Format:Paperback

This book is excellent for someone like myself, looking to grow basic to intermediate Reporting Services skills. There are a lot of resources out there which point at advanced features/functionality of the product, but few approach the material from a practical and real-world example-driven approach like this one. For anyone looking to discover and unleash the capabilities of SSRS, this is the book for you.