Bill Anton,James Serra

Reporting with Microsoft SQL Server 2012

In DetailReporting with Microsoft SQL Server 2012 will cover all the features of SSRS and Power View and will provide a step-by-step lab activity to help you develop reports very quickly.
Starting with the difference between standard and self- service reporting, this book covers the main features and functionality offered in SQL Server Reporting Services 2012 including a breakdown of the report components, development experience, extensibility, and security. You will also learn to set up and use Power View within Excel and SharePoint and connect to a tabular model as well as a multidimensional model. The book provides real-life reporting scenarios that help to clarify when those scenarios are discussing standard reporting, in which case SSRS is the best choice, and when they are discussing self-service reporting, in which case Power View is the best choice.
This book will have you creating reports in SSRS and Power View in no time!
ApproachThis is a step-by-step tutorial that deals with Microsoft Server 2012 reporting tools:SSRS and Power View.
Who this book is forIf you are a BI developer, consultant, or architect who wishes to learn how to use SSRS and Power View, and want to understand the best use for each tool, then this book will get you up and running quickly. No prior experience is required with either tool!
208 printed pages



    How did you like the book?

    Sign in or Register


    Ивайло Ламбревhas quotedlast year
    table (left) versus a matrix (right)
    Ивайло Ламбревhas quotedlast year
    list of the report items available
    Ивайло Ламбревhas quotedlast year
    Textbox: This is a basic freeform text object that can be placed anywhere on the report body as well as the header and footer areas. The text value displayed can be static or the result of an expression.
    Line: This is just a graphic for aesthetic purposes.
    Table: This is one of the primary report items most commonly used to display data from a dataset in the standard two-dimensional table format. Cells of the table typically contain text but can also contain a variety of other report items, such as data bars, sparklines, charts, and many others.
    Matrix: This report item is based on the same underlying structure as a table except that it comes with a row group and column group already defined. Use this component when you want to display data pivoted on columns as with crosstab reports.

On the bookshelves

    • 46
Drag & drop your files (not more than 5 at once)