Learning SQL Server 2008 Reporting Services

A step-by-step guide to getting the most of Microsoft SQL Server Reporting Services 2008

• 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

In Detail

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.

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

Approach

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