Learning SQL Server 2008 Reporting Services
|Also available on:|
- Everything you need to create and deliver data-rich reports with SQL Server 2008 Reporting Services as quickly as possible
- Packed with hands-on-examples to learn and improve your skills
- Connect and report from databases, spreadsheets, XML Data, and more
- No experience of SQL Server Reporting Services required
Book DetailsLanguage : English
Paperback : 512 pages [ 235mm x 191mm ]
Release Date : March 2009
ISBN : 1847196187
ISBN 13 : 9781847196187
Author(s) : Jayaram Krishnaswamy
Topics and Technologies : All Books, Enterprise Products and Platforms, Microsoft Servers, Enterprise, Microsoft, Microsoft SQL Server
Table of Contents
Chapter 1: Overview of SQL Server Reporting Services 2008
Chapter 2: Overview of SSRS 2008 Architecture and Tools
Chapter 3: Report Integration with Microsoft ReportViewer Controls
Chapter 4: Visual Studio 2008 Business Intelligence Template Projects
Chapter 5: Working with the Report Manager
Chapter 6: Working with the Report Builder
Chapter 7: Report Authoring with Report Builder 2.0
Chapter 8: Programming Interfaces to Reporting Services
Chapter 9: Crystal Reports 2008 in Visual Studio 2008
Chapter 10: On Programmatically Creating an SSRS Report
Appendix A: Queries and Datasets in SSRS 2008
Appendix B: Converting Reports between RDL and RDLC
Appendix C: Command line utilities
Appendix D: Notes and References
Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.
Errata- 7 submitted: last submission 06 Nov 2013
Page 40 | Errata type: Typo
In Step 2, it should be Planning instead of Planing.
Page 73 | Errata type: Typo
In item 1, it should be Report instead of Repot.
Page 68 | Errata type: Typo
In the first paragraph it should be SQL Server 2008 instead of SQ Server 2008.
Page 74 | Errata type: Typo
It should be Report server instead of Report Server.
Page 53 | Errata type: Language
This line "The Northwind database file should be in its default location on." should be read as "The Northwind database file should be in its default location. " The word "on" should be omitted .
Page 75 | Errata type: Typo
In the list, item 2 should be Built-in instead of BUITIN .
Page 79 | Errata type: Language
It should be 'in chapter 6' instead of 'in a chapter 6'.
What you will learn from this book
- Install SQL Server 2008 and configure the SQL Server Reporting Services
- Learn the various components and tools that enable end-to-end support for all reporting activities
- Use the report viewer control to get started with the essentials of retrieving and displaying data
- Create a Report Model using the Visual Studio 2008 Template
- Learn to modify reports on a report server and create linked files with report manager
- Embed Microsoft Report Viewer Controls in web and Windows applications
- Create interactive reports with charts and gauges using Report Builder
- Create several kinds of reports with Report Builder 2.0
- Create server reports and report models and deploy them
- Get the full details of available programming interfaces and their usage
- Learn to work with Crystal Reports 2008
- Import reports created using MS Access
- Learn how to use the Programming API, convert Report file types, use command-line utilities and more
Chapter 1 – An overview detailing the requirements and major highlights of the Reporting Services.
Chapter 2 – Presents the salient architectural details and describes the details of how the different elements of the reporting services fit together to deliver end-to-end support for reporting.
Chapter 3 – Discusses details regarding the usage of Report Viewer Controls, covering both web and Windows forms applications.
Chapter 4 – Discusses the built-in features in Visual Studio 2008 to generate server-based reports and report models. It also describes importing MS Access reports.
Chapter 5 – Describes Report Manager and some of the basic tasks that can be carried out with this tool as well as Email, File Share, and Data Driven subscriptions.
Chapter 6 – This chapter describes the Report Builder 2.0 interface together with the new features that are incorporated into this version. It also describes charts and gauges and their inclusion in reports.
Chapter 7 – This chapter describes the various kinds of reports that one can build using the standalone tool Report Builder 2.0. It also describes data originating in SQL Server, SQL Analysis Server and Report Models.
Chapter 8 – This chapter describes a number of programming interfaces available to work with the SQL Server Reporting Services. Using these interfaces facilitates integration and maintenance of reports into web and Windows applications and configuring reporting services.
Chapter 9 – This chapter describes Crystal Report 2008 and its integration with SQL Server Reporting Services 2008 using a number of examples.
Chapter 10 – Programmatic generation of reports is always a very useful feature as it draws upon the complete API. This chapter deals with creating a report using code that calls the API procedures and also presents an introduction to the.
Appendix A – This appendix describes the different sources of data that are used in Reporting Services. It also describes the differences between SQL Queries, MDX, and Semantic queries and presents how each of them is supported in the Query Designer.
Appendix B – This appendix describes the conversion of RDL to RDLC and RDLC to RDL. Presently this is limited to only RDLC to RDL conversion.
Appendix C – This appendix describes the rs.exe command-line and also describes the tools rsconfig and rskeymgmt.
Appendix D – This appendix details some of the major references and links to online references.
Microsoft SQL Server Reporting Services 2008 is the third generation Microsoft reporting software that is more tightly integrated with SQL Server 2008 than ever before. It provides a complete server-based platform that is designed to support a wide variety of reporting needs, including managed enterprise reporting, special purpose reporting, embedded reporting, and web-based reporting.
Ideal for beginners who need to create reports as quickly as possible, this book will lead you through practical examples to teach you a full range of skills for reporting with SQL Server 2008 Reporting Services. A series of carefully picked exercises help you practice the most important aspects of report creation. By the end of the book, you will have the confidence to take on the most complex of reports, and be producing reports that will make you the envy of your organization.
Learn to create and deliver attractive, data-rich reports with SQL Server 2008 Reporting Services
With clear instructions and plenty of screenshots, this book provides all the support and guidance you will need as you begin to generate reports with SQL Server 2008 Reporting Services.
Who this book is for
This book is for anyone who is new to SQL Server 2008 Reporting Services and needs to create and deploy reports. The book is suitable for report developers, data analysts, and report server database administrators.
You will need to know the basic concepts of SQL Server, but not necessarily be very familiar with SQL Server 2008.