Book Image

Learning SQL Server Reporting Services 2012

By : Jayaram Krishnaswamy
Book Image

Learning SQL Server Reporting Services 2012

By: Jayaram Krishnaswamy

Overview of this book

<p>In the present day information-centric world we live in, the success of an enterprise depends enormously on how its information is generated, handled, and disseminated. With ample screenshots and over 65 hands-on exercises, this book will guide you effortlessly through creating cutting edge reports using SQL Server Reporting Services 2012, native and fully integrated with SharePoint Server 2010 including new features like Power View and Data Alerts.</p> <p>"Learning SQL Server Reporting Services 2012" will get you started right from installation and then move on to configuration of SQL Server Reporting Services 2012. Start learning right from Chapter 1 and build your skill to create reports using the latest tools and deploy them to the latest servers, both Native and SharePoint. No guessing; you will learn all—Power View, Data Alerts, SQL Azure Reporting,the latest Reporting Services Gadgets, and more.</p> <p>"Learning SQL Server Reporting Services 2012" is a definitive guide to a step-by-step, metered approach to get a jump start on the latest features in SQL Server Reporting Services.Reporting Services in Microsoft SQL Server 2012 is more tightly integrated not only with the Microsoft Business Stack but also with SharePoint, Windows Azure, and the Visual Studio suite of products, with many new features.</p> <p>You will install and configure the toolset to work with SSRS 2012 integrated with SharePoint 2010. Using SQL Server Data Tools, you will author reports and deploy. You will learn about security to work with Report Manager and Central Administration in SharePoint. Using Report Builder, you will learn about authoring cutting edge reports. You will create Tabular Models and begin experiencing the thrill of creating Power View Reports.</p>
Table of Contents (17 chapters)
Learning SQL Server Reporting Services 2012
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Report authoring


Report writing starts with planning like most of the other activities. Some of the key considerations are:

  • Audience

  • Report structure

  • Look and feel of report

  • Report visibility related to security

  • Report delivery format

  • Canned or AD_HOC

  • Web or desktop

  • Internet, Intranet, or hard copy

Although these considerations are separately listed, they are interconnected. Once some of these requirements are defi ned then one begins to come up with a more detailed plan that needs the source of data (local, SQL Server, cloud, or third party), the connectivity issues, the delivery type (desktop, Intranet, download, Internet, cloud application, and so on), the delivery format for hard copies, Web access via Intranet IIS or through SharePoint, and a multitude of others that are too numerous to enumerate.

This chapter is not about planning but about using the Report Builder 3.0 tool to author reports of different kinds that are normally encountered. Of course, there are others that require custom treatment...