Learning SQL Server 2008 Reporting Services

A step-by-step book and eBook to getting the most of Microsoft SQL Server Reporting Services 2008
Code Files

Learning SQL Server 2008 Reporting Services

Jayaram Krishnaswamy

A step-by-step book and eBook to getting the most of Microsoft SQL Server Reporting Services 2008
Mapt Subscription
FREE
$30.00/m after trial
eBook
$21.00
RRP $29.99
Save 29%
Print + eBook
$49.99
RRP $49.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$21.00
$49.99
$29.99 p/m after trial
RRP $29.99
RRP $49.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


Learning SQL Server 2008 Reporting Services Book Cover
Learning SQL Server 2008 Reporting Services
$ 29.99
$ 21.00
Mastering SQL Queries for SAP Business One Book Cover
Mastering SQL Queries for SAP Business One
$ 32.99
$ 23.10
Buy 2 for $35.00
Save $27.98
Add to Cart

Book Details

ISBN 139781847196187
Paperback536 pages

Book Description

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.

Table of Contents

What You Will Learn

  • 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.

Authors

Table of Contents

Book Details

ISBN 139781847196187
Paperback536 pages
Read More

Read More Reviews

Recommended for You

Mastering SQL Queries for SAP Business One Book Cover
Mastering SQL Queries for SAP Business One
$ 32.99
$ 23.10
Zenoss Core 3.x Network and System Monitoring Book Cover
Zenoss Core 3.x Network and System Monitoring
$ 29.99
$ 21.00
Joomla! E-Commerce with VirtueMart Book Cover
Joomla! E-Commerce with VirtueMart
$ 29.99
$ 21.00
GlassFish Administration Book Cover
GlassFish Administration
$ 26.99
$ 18.90
Object-Oriented Programming in ColdFusion Book Cover
Object-Oriented Programming in ColdFusion
$ 23.99
$ 16.80
Small Business Server 2008 - Installation, Migration, and Configuration Book Cover
Small Business Server 2008 - Installation, Migration, and Configuration
$ 23.99
$ 16.80