- Paperback: 767 pages
- Publisher: McGraw-Hill Education; 2 edition (January 2, 2006)
- Language: English
- ISBN-10: 0072262397
- ISBN-13: 978-0072262391
- Product Dimensions: 7.4 x 1.6 x 9.2 inches
- Shipping Weight: 2.8 pounds (View shipping rates and policies)
- Average Customer Review: 3.9 out of 5 stars See all reviews (58 customer reviews)
- Amazon Best Sellers Rank: #1,769,435 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Microsoft SQL Server 2005 Reporting Services 2nd Edition
Use the Amazon App to scan ISBNs and compare prices.
There is a newer edition of this item:
What other items do customers buy after viewing this item?
From the Back Cover
Generate and distribute comprehensive, integrated reports
Transform disparate corporate data into business intelligence with help from this hands-on guide. Microsoft SQL Server 2005 Reporting Services explains how to create, manage, and deliver traditional and interactive reports with this powerful server-based reporting solution. Written by a member of the Reporting Services development team, the book covers the entire report-building and distribution process and offers complete details on all the product's integrated features. Improve business decision-making in your organization by getting the right information to the right people at the right time.
ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS
- Install and set up SQL Server 2005 Reporting Services
- Use the SELECT query to extract report data from your data sources
- Add charts, images, and other graphics
- Generate reports using the Report Wizard and from scratch
- Maintain a secure, managed environment
- Integrate reports with desktop and web applications
- Enable end-user access to reports via the Report Server and its Report Manager web interface
- Export reports to other presentation and data exchange rendering formats
About the Author
Brian Larson (Arden Hills, MN), MCSD, served as a member of the Reporting Services development team on a contract basis, and has contributed to the code base. He is the Chief of Technology (COT) for Superior Consulting Services (SCS) in the Twin Cities. SCS is a Microsoft Certified Partner and is currently developing a client solution that uses Microsoft Reporting Services for report production and distribution.
Brian has been invited to speak on Reporting Services at several conferences including SQL Server Magazine Connections (both in Vegas and Orlando), has been interviewed as a subject matter expert by Microsoft TechNet, .NET Rocks, and others and has written articles for SQL Server Magazine.
Browse award-winning titles. See more
If you are a seller for this product, would you like to suggest updates through seller support?
Top customer reviews
I am familiar with SQL Server and Crystal Reports so I was looking for a book that didn't spend too much time on stuff I already knew. This book spent the first three chapters discussing database basics so I skipped them.
I started reading the book in earnest at chapter four which discusses the report wizards. This is a quick way to throw reports together in Visual Studio and Brian Larson presents the information logically and clearly. It became quickly clear that I was reading an exceptional book. I'm guessing Brian had an experienced editor because the book is largely free of the gramatical errors that have been plaguing technical books recently. What impresses me even more is that all the examples worked flawlessly and were meaningful exercises that I will refer back to as I start to implement Reporting Services.
The book references a database you need to download from the Osborne website. The instructions to do so are very clear and I had no problems whatsoever downloading and installing it. The only problem I had was that the user id in the examples (GalacticReporting) does not have access to the stored procedures. You need to give GalRep the 'Reporting' role. Minor problem.
Brian, correctly, doesn't spend much time on the wizards and quickly gets into the meat of the application guiding the reader through successively more complex reporting scenarios. At first tasks are performed using point-and-click methods, then using quicker but more advanced methods. Finally Brian started taking shortcuts such as providing stored procedures. I saw Brian using this technique all through the book and I liked it.
The first real problem I encountered with the book in is chapter 10 in the section on deploying custom assemblies. This is an area that Reporting Services is very weak and I hope to see Microsoft improve in future releases. You have two options - alter the config file or deploy via the GAC. Brian only mentions the first option and very poorly. He doesn't mention the GAC at all whereas I think the GAC is the better option. But in the next section on security Brian is back to his old form and does a splendid job of explaining a subject I normally have a very hard time with.
The explanation of report caching, snapshots, and subscriptions is exceptionally good and does a great job of explaining these potentially confusing subjects. Again, his examples are well thought out and very simple to follow. As they occur after the section on security he points out what security tasks/roles are required to perform these function which was a great idea.
I wish Brian had spent a little more time explaining the logging mechanism in chapter 11. He refers the reader to the Microsoft documentation which is actually wrong. The book could have spent half a page explaining how to create and populate the logging database and implementing the sample reports. It would have saved me a lot of trouble.
The only other issue I have with the book is late in chapter 12 where Brian explains how to implement a custom, forms-based, security model. The example works well especially considering how complex it is, but I could not get the debugger to attach to the authentication dll even though I followed Brian's instructions to the letter. However, having Googled the problem it seems many, many people have problems attaching the Visual Studio debugger to already running threads so I suspect Bill should take some of the blame at least.
Overall Brian Larson should be very pleased with his work. It's well worth the money and he has done us all a great service. He should buy his editor a beer too.
The bad reviews came from people that were looking for more of a reference type book. While this book is not a bad reference it does fall short as a reference book. For example, one reviewer brought up that the ability to shade alternating detail rows of a report does not appear to be easy to find in this book. I would agree with that. I was unable to go into the index and find a quick solution in this book.
If you want a better reference book try the WROX book, Professional SQL Server 2005 Reporting Services. That book is not as good as this book from a step-by-step standpoint but it is a better reference when you need a quick solutions. For example, page 272 has code on how to shade alternating rows - they call it Greenbar Reports. It was not easy to find in this book either. How many people would look up "Greenbar Reports" in the reference? I was looking into "shading alternative rows". I just happened to stumble upon it.
I bought both books together. Of course there is lots of overlap but between the two that is all you will need to become a pro at Reporting Services.
Reporting Services could use a COOKBOOK-style text like they have for Access and other programming languages. Those types of books have served me well over the years. Until then this book and the WROX book should do the trick!
Most recent customer reviews
Googling the Internet and reading posted reviews indicates that many people having problem find download of the "Galactic"...Read more