SQL Server 2012 Reporting Services Blueprints : Use Real-World Situations to Develop Real-World Solutions /: Use Real-World Situations to Develop Real-World Solutions. (2013)
- Record Type:
- Book
- Title:
- SQL Server 2012 Reporting Services Blueprints : Use Real-World Situations to Develop Real-World Solutions /: Use Real-World Situations to Develop Real-World Solutions. (2013)
- Main Title:
- SQL Server 2012 Reporting Services Blueprints : Use Real-World Situations to Develop Real-World Solutions
- Further Information:
- Note: Marlon, Ribunal, Mickey Stuewe.
- Other Names:
- Ribunal, Marlon
Stuewe, Mickey - Contents:
- 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 dataCover; 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. … (more)
- Publisher Details:
- Birmingham : Packt Publishing
- Publication Date:
- 2013
- Extent:
- 1 online resource, illustrations
- Subjects:
- 005.75/85
COMPUTERS -- Enterprise Applications -- Business Intelligence Tools
Client/server computing
Client/server computing
COMPUTERS -- Data Processing
Client/server computing
COMPUTERS -- General
Electronic books - Languages:
- English
- ISBNs:
- 9781461949312
1461949319
1306065046
9781306065047
9781849685092
1849685096 - Related ISBNs:
- 9781849685085
1849685088 - Notes:
- Note: Print version record.
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.91405
- Ingest File:
- 01_091.xml