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
• 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 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.
• 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.