SQL Server 2012 Reporting Services Blueprints

SQL Server 2012 Reporting Services Blueprints
eBook: $29.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $79.98    Print cover: $49.99
save 6%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • Detailed coverage of the various reporting options available
  • Build end-to-end report solutions based on SSRS
  • Learn from realistic situations to offer outstanding solutions

Book Details

Language : English
Paperback : 246 pages [ 235mm x 191mm ]
Release Date : October 2013
ISBN : 1849685088
ISBN 13 : 9781849685085
Author(s) : Marlon Ribunal, Mickey Stuewe
Topics and Technologies : All Books, Enterprise Products and Platforms, Enterprise

Table of Contents

Chapter 1: Let's Breakdown the Numbers
Chapter 2: Making a Good Impression
Chapter 3: Getting Some Actions
Chapter 4: Everything Looks Better with Charts
Chapter 5: Location, Location, Locations!
Chapter 6: Let's Get Analytical!
Chapter 7: Sir, We're Ready to Deploy!
Chapter 8: Beyond the Horizon!
Appendix A: SSRS Best Practices
Appendix B: Transactional Replication for Reporting Services
  • 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 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
      • Chapter 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
        • 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 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
              • 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
                  • 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
                • Chapter 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
                  • Appendix A: SSRS Best Practices
                    • Location of SSRS database installation
                    • Utilizing the SSRS execution logs
                    • Report management
                    • Standardizing queries
                    • Report standards
                    • Testing reports

                      Marlon Ribunal

                      Marlon Ribunal is passionate about SQL Server. He loves learning about the technology. Mostly, he is a sponge—the learner—but he loves sharing the knowledge he has accumulated. He is introvert by nature but loves connecting to people in various avenues, through technical communities' events such as the SQL Saturday, social networks, on his blog, and other forums. His purpose is to help people in their pursuit of growth and development; and, thereby, help himself realize his full potential as a professional, husband, father, Christian, and human being. When he's not busy, he blogs at www.marlonribunal.com—his technical blog. You can follow him on Twitter as @MarlonRibunal. And if you're interested in topics related to Productivity and Getting Things Done (GTD), you can follow his other blog at www.productivitybits.com.

                      Mickey Stuewe

                      Mickey Stuewe is a senior SQL database developer with close to twenty years of experience using Microsoft products. She has been working with SQL Server since 1996, and has used all versions of Reporting Services. Her focus is on query optimization, report design, and report creation using SQL Server and Reporting services. She keeps a blog at http://mickeystuewe.com/ and frequently writes articles for http://www.mssqltips.com/. She is a speaker at Dev Connections and SQL in the city, and is a regular speaker at SQL Saturday events and user group meetings throughout the year. She currently lives in Southern California with her two daughters and husband. You can follow her on Twitter: @SQLMickey.
                      Sorry, we don't have any reviews for this title yet.

                      Code Downloads

                      Download the code and support files for this book.

                      Submit Errata

                      Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                      Sample chapters

                      You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                      Frequently bought together

                      SQL Server 2012 Reporting Services Blueprints +    Microsoft BizTalk 2010: Line of Business Systems Integration =
                      50% Off
                      the second eBook
                      Price for both: $45.60

                      Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                      What you will learn from this book

                      • Fully understand the structure and properties of your reports
                      • Add interactive elements to your reports
                      • Use parameters effectively in different scenarios
                      • Utilize a range of advanced graphs
                      • Make use of geospatial data and maps
                      • Use OLAP Cubes in your reports
                      • Deploy your SSRS projects
                      • Integrate SharePoint, PowerPivot, and Power View into your reports

                      In Detail

                      SQL Server 2012 accounts for a huge share of the database market, and more and more companies are implementing SSRS as part of their BI implementation. Its Reporting Services offers a comprehensive, highly scalable solution that enables real-time decision making.

                      SQL Server 2012 Reporting Services Blueprints is intended to be just that, a series of Blueprints – things that work straight out of the box and that mirror what a real job requires real report developers to do. You will not be bored with an “Introduction to X” or “What’s under the hood of Y”. We go straight to the practical development of reporting skills, explaining actions as they are taken.

                      This book is a step-by-step, task-driven tutorial. It provides enterprise reporting blueprints that address your day-to-day issues and requirements. Right from the very start, you’ll learn SSRS beyond the basics, giving you the skills to create the best reports for any task. Explore the possibilities, master your options, and choose the best tool for the job.


                      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.

                      Who this book is for

                      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.

                      Code Download and Errata
                      Packt Anytime, Anywhere
                      Register Books
                      Print Upgrades
                      eBook Downloads
                      Video Support
                      Contact Us
                      Awards Voting Nominations Previous Winners
                      Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                      Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software