Professional SQL Server 2005 Reporting Services [Paperback]

Paul Turley (Author), Todd Bryant (Author), James Counihan (Author), Dave DuVarney (Author)

Book Description

Publication Date: March 6, 2006 | ISBN-10: 0764584979 | ISBN-13: 978-0764584978 | Edition: 2nd

From the Back Cover: SQL Server reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly so you can design, deploy, manage, and even customize reporting solutions. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET. Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of this revolutionary tool. Plus, you'll learn how to extend practically every feature of Reporting Services by implementing your own security architecture or adding custom data access.

--This text refers to the Kindle Edition edition.

Editorial Reviews

Review

What you will learn from this book: * Details of programming reports and report scripting * Advanced report design, including drill-down reports, nested lists, drill-through, links and dynamic content * High-level strategies for business and support systems * Rendering reports using .NET code, .NET 10 namespace classes, and URL rendering deployment strategies to handle hardware, software, and platform considerations, licensing issues, and scaling options * How to design reports for mobile services * Various tools used to define data sources and semantic metadata models Who this book is for: This book is for report designers, developers, administrators, and business professionals interested in learning the advanced functionality, report,server administration, and security issues of SQL Server 2005 Reporting Services. --This text refers to the Kindle Edition edition.

From the Back Cover

SQL Server reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly so you can design, deploy, manage, and even customize reporting solutions. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET.

Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of this revolutionary tool. Plus, you'll learn how to extend practically every feature of Reporting Services by implementing your own security architecture or adding custom data access.

What you will learn from this book

• Details of programming reports and report scripting
• Advanced report design, including drill-down reports, nested lists, drill-through, links and dynamic content
• High-level strategies for business and support systems
• Rendering reports using .NET code, .NET 10 namespace classes, and URL rendering deployment strategies to handle hardware, software, and platform considerations, licensing issues, and scaling options
• How to design reports for mobile services
• Various tools used to define data sources and semantic metadata models
• How to use parameters and expressions to define creative report solutions
• Advanced object-oriented programming techniques, with examples in C# and VB 2005.

Who this book is for

This book is for report designers, developers, administrators, and business professionals interested in learning the advanced functionality, report,server administration, and security issues of SQL Server 2005 Reporting Services.

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 issue 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.

See all Editorial Reviews

Product Details

• Paperback: 722 pages
• Publisher: Wrox; 2nd edition (March 6, 2006)
• Language: English
• ISBN-10: 0764584979
• ISBN-13: 978-0764584978
• Product Dimensions: 9.3 x 7.5 x 1.5 inches
• Shipping Weight: 2.3 pounds (View shipping rates and policies)
• Average Customer Review: 3.3 out of 5 stars  See all reviews (19 customer reviews)
• Amazon Best Sellers Rank: #546,062 in Books (See Top 100 in Books)

More About the Author

Paul Turley (Vancouver, WA) is a Manager of Specialized Services for Hitachi Consulting External Education Services. Paul manages the Business Intelligence training team and teaches classes for companies throughout the world on Microsoft SQL Server technologies. He works with companies to architect and build BI and reporting solutions.
He has been developing business database solutions since 1991 for companies like Microsoft, Disney, Nike and Hewlett-Packard. He has been a Microsoft Certified Trainer since 1996 and holds several industry certifications including MCTS and MCITP for BI, MCSD, MCDBA, MSF Practitioner and IT Project+.
Paul has authored and co-authored several books and courses on database, business intelligence and application development technologies. He is the lead courseware developer for the Hitachi Consulting courses: SQL Server 2008 Business Intelligence Solutions and SQL Server 2008 Reporting Services Solutions. Books include Professional SQL Server 2008 Reporting Services, Professional SQL Server 2005 Reporting Services, Professional SQL Server Reporting Services (SQL Server 2000,) Beginning Transact-SQL with SQL Server 2000 and 2005, Beginning SQL Server 2005 Administration, Beginning Access 2002 VBA, Data Warehousing with SQL Server 2000 Analysis Services, and Professional Access 2000 Programming ' from Wrox Press. He is also a contributing author for SQL Server 2005 Integration Services Step by Step from Microsoft Press.

Customer Reviews

Most Helpful Customer Reviews

16 of 17 people found the following review helpful:

2.0 out of 5 stars Tough to get through, April 12, 2007

By 

Levi (Reston, VA, United States) - See all my reviews
(VINE VOICE)    (REAL NAME)   

This review is from: Professional SQL Server 2005 Reporting Services (Paperback)

This will probably be an ok reference for some things in ssrs, but otherwise it has been a real pain to get through. There seems to be a huge amount of repetitive informatin in the first three chapters before we actually get to start writing reports.

Unfortunately, once writing reports, it seems like the authors have ADD. They start talking about a walk through exercise but never actually have the walk through. They do have a couple of exercises where they show you how to go step by step, but these are not explained well.

I think the writing, other than being repetative, is sometimes unecessarily chatty, but at other times way to terse for beginners.

I have managed to glean some value from the book, but it's been tough. I would definitely recommend if you haven't touched SSRS yet to go through the tutorials on MSDN first. They do a better job of introducing you to basics, giving you plain instructions, and not overloading you with commentary that isn't all helpful in just getting you up to speed on how to create reports. Luckily I did this before I bought the book. I think if I was completely new to reporting and SSRS, I would have thrown this book down in disgust after the first 100 pages or so...

16 of 17 people found the following review helpful:

2.0 out of 5 stars Surprisingly Disappointed, April 9, 2007

By 

A. Abrams "Senior Reporting Application Devel... (Cleveland, Ohio) - See all my reviews
(REAL NAME)   

This review is from: Professional SQL Server 2005 Reporting Services (Paperback)

This is the fifth book that I have purchased from Wiley Publishing (WROX), and I must say that I have been very pleased so far by the overall quality of the publications until now. I read through the other four and still use each one of them as a relevant reference source.

I am half way thru this book and the experience has not been pleasant to say the least. The inconsistencies between the text, figure's and examples are to numerous to be overlooked. And, to be honest, this is one of the most confusing approaches that I have come across in quite some time. He is obvious very knowledge about SSRS, but during many of his explanations he orphans the examples or doesn't tie what he is explaining back to the example. This makes it very difficult to reproduce in the actual development environment. You're just left confused!

I am a twelve year veteran of Crystal Reports, Application Development and Database Design and I find this book very difficult to follow. So unfortunately, I would not recommend this particular book to others ... I am just surprisingly disappointed.

18 of 21 people found the following review helpful:

5.0 out of 5 stars Excellent Book, March 29, 2006

By 

urpalshu "urpalshu" (USA) - See all my reviews

This review is from: Professional SQL Server 2005 Reporting Services (Paperback)

Till today I never found a good book in SQL Server Reporting Services. This book covers a lot of features, to get you ready to work on Complex Reports. Very good step by step instructions with working examples. It starts from a beginner level and proceeds with Advanced Report Design.The best part I liked was the explanation about Rendering reports using .NET code, .NET IO namespace classes, and URL rendering deployment strategies to handle hardware, software, and platform considerations, licensing issues, and scaling options.
I highly recomend this as a very important source to learn Reporting Services