(Ebook) SQL Server 2005 Reporting Services in Action by Bret Updegraff ISBN 9781932394764, 1932394761

(Ebook) SQL Server 2005 Reporting Services in Action by Bret Updegraff ISBN 9781932394764, 1932394761

"A great resource to help you unlock the hidden gems in SQL Server Reporting Services.Brian WelckerGroup Program ManagerMicrosoft SQL Server Reporting ServicesWith Microsoft SQL Server 2005 you can structure and store terabytes of data-but how do you make sense of that much information? Reporting Services transforms raw data into meaningful reports and puts your valuable information to work.SQL Server 2005 Reporting Services in Action shows you how to build effective Windows and Web-based reporting solutions using SQL Server 2005. Using this example-driven book, you'll build Reporting Services-centric solutions, including report forecasting, RSS feeds, ASP.NET web controls for server-side report generation, extending Reporting Services to report on ADO.NET datasets, delivering reports to Web services, authenticating users, performance testing, and capacity planning.You'll quickly move beyond canned reports and put the Report Designer through its paces. The book will show you how to add interactive features to your tabular reports and how to improve performance by using external images without taking up valuable database real estate.When you have large systems, efficiency is key to productivity. Author Bret Updegraff shows you how to avoid doing the same tasks twice. You'll see a nifty sales forecast that uses embedded code to create reusable utility functions that you can call from multiple places your reports. As well, you'll find fundamentals like employing XSLT to create XML reports and advanced techniques such as accessing custom code in an external .NET assembly.Reporting Services 2005 lets you give users greater control over their reporting needs. SQL Server 2005 Reporting Services in Action will help you provide safe, user-friendly reporting options to your users and free up your time for more important tasks. This book shows you how to set up ad hoc reporting through Report Builder so business users can get the information you need from the database without your help! You won't stop with the basics, though. You'll also learn how to apply advanced filters and security practices to protect your data from unwelcome or misguided queries.Of course, this new edition is thoroughly updated to include coverage of all the new features introduced with SQL Server 2005. You'll see:# Direct Client Printing: Send a report directly to a printer without having to export to printable format first# End User Sort: Let the end user to re-sort data within the report# Multi Valued Parameters: Use multiple values for parameters# Custom Report Items: Build and embed custom server controlsYou'll also work with the improved Report Designer, Report Builder, and Analysis Services Query Builder. You'll learn about SharePoint WebParts and the Report Viewer Controls for WinForms and ASP.NET, as well.what's inside* How to build reporting solutions, instead of just walking through product features.* What you need to know before deciding whether to buy a third-party tool or invent a homegrown solution.* Code samples showcase many aspects of programming with Reporting Services and teach the reader best development practices.* Report Builder and ReportViewer.* Ad-hoc reporting and client-side sorting.* ASP.NET web control for server-side report generation.* Create reports off ADO.NET datasets.about the readerWritten for developers with a solid foundation in .NET and SQL Server.about the authorBret Updegraff holds the MCSD, MCAD, and MCDBA certifications, and is a 2006 Microsoft Server System MVP. Bret is the president of the Indianapolis Professional Association of SQL Server (PASS) users group.