Pro SQL Server Reporting Services

Rating:
Summary: Reporting Services, Soup to Nuts.
Review: SQL Server Reporting Services is relatively new to the scene but the authors have experience building real world applications with it. They share that real world experience, not just theory, with us in this book.
For example, they not only show how to create an advanced query for one of the samples they show you how to test the performance with Query Analyzer. There is something here for everyone. Those just getting started might find creating a report with the Report Wizard the place to start. Others might benefit from accessing .Net assemblies from embedded code. This book covers every aspect of Reporting Services, deployment, rendering, security, management, use with business intelligence such as Analysis Services, and even a look at the future, Reporting Services with SQL Server 2005. Great book, good read, good value.


Rating:
Summary: Excellent reference
Review: This book takes you from the basics to very advanced activities. Anyone who is serious about creating custom report solutions should implement SQL RS and use this book. It will help you through step-by-step "how-to" to create an extremely professional result. Reporting Services is fairly new to the public. Only now are books of this nature becoming available. This one is the best!

Rating:
Summary: Step by step end-user guide
Review: This is a clear and concise step-by-step guide to the end-user side of the SQL Server reporting services. It's well written and has numerous (maybe too many) screenshots. The walkthroughs are explained in an easy-to-read and follow step by step manner. There is some C# code and SQL that describe, for example, how to integrate the reporting engine into a .NET application.

I recommend this book for anyone looking at developing with SQL Server Reports. It's definitely worth the look.

Rating:
Summary: easy programming
Review: To increase the attractiveness of its SQL Server, Microsoft recently released Reporting Services. These help you generate management level summaries of data stored in SQL Server.

The authors show how Microsoft has implemented this in a tight integration with its .NET platform. There are numerous screen captures of the wizard UIs that generate reports. Nice. In parallel with these diagrams are often listings of the corresponding XML data that describe what the diagrams show. The book assumes a reasonable familiarity with XML. But even if you are new to it, the verbosity of XML tags should make the examples self documenting.

One thing is clear from this book. The Reporting Services need a programmer to use them. The wizard helps somewhat to reduce the need for explicit coding. But if you have any nontrivial customisation needs, you will need to program. Though the code examples are not that intricate.

Which also means that if you are casting around for some programming expertise to develop, as job security perhaps, then do not settle on Reporting Services. If you can, find something more intricate that you can handle. It is a greater barrier to entry.

Rating:
Summary: Practical, authoratative.
Review: Way back in the days when Microsoft Access was the latest thing in databases (and the earth was flat, and it was three miles to school, uphill both directions) it included quite a nice report generating package.

Then we all moved to higher performance data bases, and we lost that functionality unless we bought a separate package like Crystal Reports.

Now Microsoft has given us that functionality back and in an expanded manner that incorporates a lot of web presentation capability.

This book is on the capabilities of the reporting system now built into SQL Server. If you're familiar with other graphically based reporting systems, or if you've worked in a .NET environment, you should be able to read this book in an afternoon and begin doing reports.

After your first few reports you'll find that you want to go back to check on fancier capabilities, but you'll have the basics down.

The nice thing about this book is that it was written while the authors were in the process of converting some 200 reports to actually use the software. That way you find out how it really works as opposed to the way the manuals say. Good job.