Professional SQL Server Reporting Services (eBook)

Paul Turley is an instructor for Netdesk Corporation inSeattle. As a consultant, he has worked with Microsoft ConsultingServices on enterprise-scale development projects and has createdreporting solutions using Crystal Reports, Active Reports, andAccess. Since 1988, he has managed IT projects, designed andprogrammed applications using Visual Basic 3, 4, 5, 6, ASP.NET,ADO.NET, and SQL Server. He obtained his MCSD certification in1996. Other certifications include MCDBA, IT Project+ and MicrosoftSolutions Framework (MSF) Practitioner.He designed and maintains www.Scout-Master.com, a web-based servicethat enables Boy Scout units to manage their membership andadvancement records online using ASP.NET, SQL Server 2000, andReporting Services. Paul has been a contributing author on booksand articles including Professional Access 2000 Programming,Beginning Access 2002 VBA, and SQL Server DataWarehousing with Analysis Services from WROX Press.Paul Turley contributed Chapters 1, 3, 4, 5, 10, 14, and AppendicesD and E to this book.Todd Bryant has been creating custom data-focusedapplications and reporting solutions since the early eighties. Hebegan using Microsoft technologies in 1998 and the love affairbegan. Todd has been contract programming, teaching, and developingcustom courseware every since. He is currently working as a trainerat Netdesk Corporation, where he concentrates on EnterpriseSolutions, Com+ Services, and Object Oriented Programming usingboth VB.NET and C#. His certifications include the MCSD, MCSE,MCDBA, and MCT certifications from Microsoft, the CNA certificationfrom Novell, and both CompTIA's A+ and CTT+.Todd Bryant contributed Chapters 11 and 12 and Appendix C to thisbook.James Counihan started working with databases andreporting applications when doing research for the government backin 1979. Since then his program management and developmentexperience has been primarily in the retail and energy industries.He's been teaching development courses at Netdesk Corporation inSeattle for the past three years, focusing on integrating LOBapplications using Microsoft application servers and webservices.James Counihan contributed Chapters 6 and 8 and Appendix B to thisbook.George McKee is a Solution Developer for Avanade Inc., aSeattle-based integrator for Microsoft technology that's a jointventure between Accenture Ltd. and Microsoft. George specializes inthe inhouse financial systems of Avanade. He has a degree inChemical Engineering from Brigham Young University and has beenusing computers and databases to resolve technical and businessproblems for 25 years. George has MCAD and MCSD certifications.When not sitting in front of a computer, George likes to be foundin backcountry skiing in the Washington Cascade Mountains. He canbe reached via email at georgem@avanade.com.George McKee contributed Chapter 13 and Appendix A to thisbook.Dave DuVarney is a Senior Consultant at Aspirity, LLCwhere he provides consulting and training services in the fields ofbusiness intelligence and software development. He brings over 5years of finance, programming, and development methodologiesexperience to high technology business intelligence solutions.Prior to joining Aspirity, Dave was a development instructorteaching a wide range of Microsoft technologies. Dave also spenthis early career working for a Seattle-based CPA firm.When Dave is not working, he enjoys running. At the time ofpublishing, he is training for his first full marathon.Dave DuVarney contributed Chapters 2 and 9 to this book.

Introduction.Chapter 1: Getting Started with Reporting Services.Chapter 2: Reporting Services Architecture.Chapter 3: Designing Reports.Chapter 4: Designing Data Access.Chapter 5: Advanced Report Design.Chapter 6: Managing Reports Using the Report Manager.Chapter 7: Managing Reports Using Program Code.Chapter 8: Report Scripting.Chapter 9: URL Access and Programmatic Rendering.Chapter 10: Report Caching and Subscriptions.Chapter 11: Report Definition Language.Chapter 12: Extending Reporting Services.Chapter 13: Deployment Strategies.Chapter 14: Designing Business Intelligence ReportingSolutions.Appendix A: Troubleshooting.Appendix B: Migrating Access Reports.Appendix C: Reporting Services Object Model.Appendix D: Transact SQL Query Functions and Expressions.Appendix E: Configuration Files.