Home Page Icon
Home Page
Table of Contents for
Table of Contents
Close
Table of Contents
by Mickey Stuewe, Marlon Ribunal
SQL Server 2012 Reporting Services Blueprints
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover
Next
Next Chapter
SQL Server 2012 Reporting Services Blueprints
Table of Contents
SQL Server 2012 Reporting Services Blueprints
Credits
About the Authors
Acknowledgments
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers and more
Why Subscribe?
Free Access for Packt account holders
Instant Updates on New Packt Books
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
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
2. Making a Good Impression
Report 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
3. Getting Some Actions
Creating the main report
Creating a detail report
Adding a subreport
Creating a drillthrough or linked report
The ALL parameter
Adding a hyperlink (go to URL)
Adding a tool tip
Interactive sorting
Adding a Document Map
Creating a bookmark
Summary
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
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
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 model
Creating 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
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
Step 1 – specify the type of data-driven subscription
Step 2 – select the location of the shared data source
Step 3 – set up the SQL statement or stored procedure that will return the data-driven property data.
Step 4 – set up the delivery properties
Step 5 – set up the parameter values
Step 6 – set up the schedule for the subscription
Summary
8. Beyond the Horizon!
Integrating SSRS with SharePoint
Creating Reporting Service Application
Provisioning subscriptions and alerts
Creating a web application
Creating a site collection
Deploying SSRS projects to SharePoint
Getting introduced to Power View
Understanding PowerPivot
Adding a data source to a model
Creating a Power View report in SharePoint
Summary
A. SSRS Best Practices
Location of SSRS database installation
Utilizing the SSRS execution logs
Report management
Standardizing queries
Report standards
Testing reports
B. Transactional Replication for Reporting Services
Options for report delivery
Transactional replication to the rescue
Implementing transactional replication
Setting up the distributor
Configuring the publication
Getting the subscription ready
Summary
Index
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset