عنوان

SQL Server 2012 Reporting Services Blueprints.

(Number (ISBN

1849685088

(Number (ISBN

1849685096

(Number (ISBN

9781849685085

(Number (ISBN

9781849685092

Number

b587493

Title Proper

SQL Server 2012 Reporting Services Blueprints.

General Material Designation

[Book]

First Statement of Responsibility

Marlon Ribunal

Edition Statement

Online-ausg

Place of Publication, Distribution, etc.

Birmingham

Name of Publisher, Distributor, etc.

Packt Publishing

Date of Publication, Distribution, etc.

2013

Specific Material Designation and Extent of Item

((246 Seiten)).

Series Title

EBL-Schweitzer

Text of Note

Cover; Copyright; Credits; About the Authors; Acknowledgments; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Let's Breakdown the Numbers; Defining a data source for the project; Defining the dataset for the project; Creating the report file; Creating a parameterized report; Creating a radio button parameter; Making a parameter optional; Populating a drop-down parameter with a dataset; Creating a multivalued parameter; Creating a cascading parameter; Creating a cascading multivalued parameter; Sales details report in action!; Summary.Chapter 2: Making a Good ImpressionReport page setup; Formatting expression; Adding report objects; Formatting literals in an expression; Creating a row group; Implementing Drilldown with row visibility; Adding subtotals for each group; Adding the grand total; Adding a page header; Adding an image in the header; Adding a page footer; Adding a page number; Alternating row colors; Creating a report template; Using a custom report template; Summary; Chapter 3: Getting Some Actions; Creating the main report; Creating a detail report; Adding a subreport; Creating a drillthrough or linked report.The ALL parameterAdding a hyperlink (go to URL); Adding a tool tip; Interactive sorting; Adding a Document Map; Creating a bookmark; Summary; Chapter 4: Everything Looks Better with Charts; Creating a simple chart; Adding data to a chart; Formatting the chart; Adding a tool tip; Embedding data bars in a tablix; Showing a data label; Setting the bar color conditionally; Adding sparklines in the tablix; Aligning axes in the sparkline; Using gauge in a tablix; Configuring the pointer of a gauge; Adding a scale for the gauge; Defining a range of the gauge; Adding an Indicator; Summary.Chapter 5: Location, Location, Locations!Creating a map (polygon) visualization; Options for spatial and data views; Options for theme and data visualization; Formatting the map; Changing the color rules; Adding center points; Customizing distribution options; Using a shapefile; Removing empty center points; Adding a random point layer; Adding a line layer; Adding a tile layer; Additional Formatting; Summary; Chapter 6: Let's Get Analytical!; Checking the TCP port of Analysis Services; Creating a new inbound rule for Analysis Services; Changing the deployment setting for Analysis Services.Deploying the multidimensional modelCreating the data source for the report; Adding a dataset based on the multidimensional model; Working with the query designer; Building a dataset using the query designer; Using the dataset on the report designer; Adding a filter in the dataset; Adding a parameter in the dataset; Creating a calculated member; Summary; Chapter 7: Sir, We're Ready to Deploy!; Deployment configurations; Development to production migration; User security; Shared schedules; Cached reports; Snapshots; Subscriptions - e-mail delivery / scheduled delivery.Subscriptions - data-driven subscription.Follow the fictional John Kirkland through a series of real-world reporting challenges based on actual business conditions. Use his detailed blueprints to develop your own reports for every requirement. This book is for report developers, data analysts, and database administrators struggling to master the complex world of effective reporting in SQL Server 2012. Knowledge of how data sources and data sets work will greatly help readers to speed through the tutorials.

Client/server computing.

Relational databases.

SQL server.

Class number

Book number

Marlon Ribunal

Marlon Ribunal

Mickey Stuewe

Electronic name

[Book]

Y