Professional SQL Server Reporting Services (eBook)

Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney (Autoren)

eBook Download: PDF

2004 | 1. Auflage
624 Seiten
John Wiley & Sons (Verlag)
978-0-7645-7694-2 (ISBN)

Infos

What is this book about?SQL Server Reporting Services is the customizable reportingsolution for report designers and programmers. This hands-on guidewill get you up to speed quickly. You can create powerful reportswithout programming knowledge and extend reporting solutions usingVB, C#, and ASP.NET.Packed with detailed examples of building reports, designingreport solutions, and developing deployment strategies forinteracting with various platforms, this book prepares you to takefull advantage of a revolutionary new tool.What does this book cover?Here are just some of the things you'll learn in this book:* Details of programming reports and report scripting* Advanced report design, including drill-down reports, nestedlists, drill-through, links, and dynamic content* How to manage reports using Report Manager or program code* High-level strategies for business support systems* Rendering reports using .NET code, .NET IO namespace classes,and URL rendering* Deployment strategies to handle hardware, software, andplatform considerations, licensing issues, and scaling optionsWho is this book for?This book is for developers and report designers using VB, C#,and ASP.NET who need to tie into SQL Server to build customizedreports or to integrate reports into Windows or Web-basedapplications.

Autor

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 [e-mail] 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.

Inhalt

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.

Produkt-Details

• Erscheint lt. Verlag: 26.4.2004
• Sprache: englisch
• Themenwelt: Mathematik / Informatik ► Informatik ► Datenbanken
• Themenwelt: Mathematik / Informatik ► Informatik ► Netzwerke
• Schlagworte: Client-server-Konzept • Client-Server-Modell • Client/Server-Technologie • Client/Server Technologies • Computer Science • Database & Data Warehousing Technologies • Datenbanken u. Data Warehousing • Informatik • SQL Server
• ISBN-10: 0-7645-7694-1 / 0764576941
• ISBN-13: 978-0-7645-7694-2 / 9780764576942