|
" SQL Server 2012 Reporting Services Blueprints. "
Marlon Ribunal
| Document Type
|
:
|
BL
|
| Record Number
|
:
|
767509
|
| Doc. No
|
:
|
b587493
|
| Main Entry
|
:
|
Marlon Ribunal
|
| Title & Author
|
:
|
SQL Server 2012 Reporting Services Blueprints.\ Marlon Ribunal
|
| Edition Statement
|
:
|
Online-ausg
|
| Publication Statement
|
:
|
Birmingham : Packt Publishing, 2013
|
| Series Statement
|
:
|
EBL-Schweitzer
|
| Page. NO
|
:
|
((246 Seiten)).
|
| ISBN
|
:
|
1849685088
|
|
|
:
|
: 1849685096
|
|
|
:
|
: 9781849685085
|
|
|
:
|
: 9781849685092
|
| Abstract
|
:
|
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.
|
| Subject
|
:
|
Client/server computing.
|
| Subject
|
:
|
Relational databases.
|
| Subject
|
:
|
SQL server.
|
| LC Classification
|
:
|
QA76.9.C55M375 2013
|
| Added Entry
|
:
|
Marlon Ribunal
|
|
|
:
|
Mickey Stuewe
|
| |