SQL Server 2016 Reporting Services Cookbook
Your one-stop guide to operational reporting and mobile dashboards using SSRS 2016
1. Auflage
Erschienen am 13. Januar 2025
596 Seiten
978-1-78646-799-7 (ISBN)
Beschreibung
No detailed description available for "SQL Server 2016 Reporting Services Cookbook".
Alle Preise
Weitere Details
Personen
Priyankara Dinesh :
Dinesh Priyankara is an experienced professional and database enthusiast with skills in database management systems and business intelligence, especially on the Microsoft SQL Server product suite. Possessing over 16 years of experience on data related technologies, he does training, consulting, and is a top contributor to the local SQL Server community. In recognition of his contributions and expertise he has demonstrated, he was awarded the Microsoft Most Valuable Professional (MVP) award for SQL Server for 11 consecutive years since 2006. Dinesh is the Founder/Principal Architect of dinesQL (Pvt) Ltd (http://dinesql.com), a company that provides services on database, business intelligence, and training. In his spare time, he runs a blog at http://dinesql.blogspot.com with a follower base of over 100,000 from around the world and is a co-organizer of SQL Server Sri Lanka User Group (http://www.meetup.com/ssslug/). Even though he has written many articles on the database area, this is his first official book as a co-author.Cain Robert :
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Pluralsight, with over 11 courses to his credit. Robert is a team mate at Linchpin People, and co-author of four books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, IT/Dev Connections, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years' experience in the IT industry, working in a variety of fields including manufacturing, insurance, telecommunications and nuclear power.
Dinesh Priyankara is an experienced professional and database enthusiast with skills in database management systems and business intelligence, especially on the Microsoft SQL Server product suite. Possessing over 16 years of experience on data related technologies, he does training, consulting, and is a top contributor to the local SQL Server community. In recognition of his contributions and expertise he has demonstrated, he was awarded the Microsoft Most Valuable Professional (MVP) award for SQL Server for 11 consecutive years since 2006. Dinesh is the Founder/Principal Architect of dinesQL (Pvt) Ltd (http://dinesql.com), a company that provides services on database, business intelligence, and training. In his spare time, he runs a blog at http://dinesql.blogspot.com with a follower base of over 100,000 from around the world and is a co-organizer of SQL Server Sri Lanka User Group (http://www.meetup.com/ssslug/). Even though he has written many articles on the database area, this is his first official book as a co-author.Cain Robert :
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Pluralsight, with over 11 courses to his credit. Robert is a team mate at Linchpin People, and co-author of four books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, IT/Dev Connections, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years' experience in the IT industry, working in a variety of fields including manufacturing, insurance, telecommunications and nuclear power.
Inhalt
- Cover
- Copyright
- Credits
- About the Authors
- About the Reviewers
- www.Packtpub.com
- Table of Contents
- Preface
- Chapter 1: Getting It Ready - Configuring Reporting Services
- Introduction
- Selecting the edition
- Getting ready
- How to do it.
- How it works.
- See also
- Installing Reporting Services with default configurations
- Getting ready
- How to do it.
- How it works.
- There's more.
- See also
- Installing Reporting Services-related tools
- Getting ready
- How to do it.
- How it works.
- There's more.
- See also
- Accessing Reporting Services Configuration Manager
- Getting ready
- How to do it.
- How it works.
- There's more.
- See also
- Configuring the service account of Reporting Services
- Getting ready
- How to do it.
- How it works.
- There's more.
- Configuring Reporting Services URLs
- Getting ready
- How to do it.
- How it works.
- There's more.
- Configuring the Reporting Services database
- Getting ready
- How to do it.
- How it works.
- There's more.
- See also
- Executing post-installation tasks
- Getting ready
- How to do it.
- How it works.
- There's more.
- Chapter 2: Authoring Reports with SQL Server Data Tools
- Introduction
- The designer tool - exploring SSDT
- Getting ready
- How to do it.
- How it works.
- Visual Studio 2015 support
- Getting ready
- How to do it.
- How it works.
- Creating reports with a table data region
- Getting ready.
- How to do it.
- How it works.
- There's more.
- Creating reports with a matrix data region
- Getting ready
- How to do it.
- How it works.
- Creating reports with a chart data region
- Getting ready
- How to do it.
- How it works.
- There's more..
- Managing and configuring parameters
- Getting ready
- How to do it.
- How it works.
- Chapter 3: Advanced Report Authoring with SQL Server Data Tools
- Introduction
- Creating reports with multiple axis charts
- Getting ready
- How to do it.
- How it works.
- Creating reports with multiple data regions
- Getting ready
- How to do it.
- How it works.
- Creating reports with nested data regions
- Getting ready
- How to do it.
- How it works.
- Creating reports with a map data region
- Getting ready
- How to do it.
- How it works.
- Creating reports with cascading parameters
- Getting ready
- How to do it..
- How it works.
- Creating reports with dynamic datasets
- Getting ready
- How to do it.
- How it works.
- How to publish reports
- Getting ready
- How to do it.
- How it works.
- How to view the XML code related to reports
- Getting ready
- How to do it.
- How it works.
- Chapter 4: Authoring Reports with Report Builder
- Introduction
- Is this for a developer or business user?
- Getting ready.
- How to do it.
- How it works.
- Enhancements to Report Builder
- Getting ready.
- How to do it.
- How it works.
- Connecting Report Builder to Reporting Services
- Getting ready
- How to do it.
- How it works.
- How to design reports with the wizard
- Getting ready
- How to do it.
- How it works.
- There's more.
- How to design reports manually
- Getting ready.
- How to do it.
- How it works.
- Working with published data sources
- Getting ready
- How to do it.
- How it works.
- Working with published datasets
- Getting ready
- How to do it.
- How it works.
- How to publish reports to Reporting Services
- Getting ready
- How to do it.
- How it works.
- Working with published report parts
- Getting ready
- How to do it.
- How it works.
- Changing reports published in Reporting Services
- Getting ready
- How to do it.
- How it works.
- Chapter 5: Improving User Experience - New Designing and Visualization Enhancements
- Introduction
- Positioning parameters
- Getting ready
- How to do it.
- How it works.
- Visualizing data with modern styles
- Getting ready
- How to do it.
- How it works.
- There's more.
- Visualizing data with the TreeMap data region
- Getting ready
- How to do it.
- How it works.
- Visualizing data with the Sunburst data region
- Getting ready
- How to do it.
- How it works.
- There's more.
- Integrating R with Reporting Services
- Getting ready
- How to do it.
- How it works.
- There's more.
- See also
- Chapter 6: Authoring Reports with the Mobile Report Publisher
- Introduction
- Understanding the new Mobile Report Publisher
- Getting ready
- How to do it.
- How it works.
- How to create a mobile report
- Getting ready
- How to do it.
- How it works.
- Using simulated data
- Getting ready
- How to do it.
- How it works.
- Setting up data sources
- Getting ready
- How to do it..
- How it works.
- How to use datasets for mobile reporting
- Getting ready
- How to do it.
- How it works.
- Understanding mobile report graphical elements
- Getting ready
- How to do it.
- How it works.
- Understanding the mobile report layout
- Getting ready
- How to do it.
- How it works.
- Configuring navigators
- Getting ready
- How to do it.
- How it works.
- Configuring parameters for drill-through reports
- Getting ready
- How to do it.
- How it works.
- Chapter 7: Consuming Reports - Report Access Enhancement
- Introduction
- Exploring the new Web Portal
- Getting ready
- How to do it.
- How it works.
- There's more.
- Managing reports with the Web Portal
- Getting ready
- How to do it.
- How it works.
- There's more.
- Viewing reports on any web browser
- Getting ready
- How to do it.
- How it works.
- There's more.
- Caching the report
- Getting ready
- How to do it.
- How it works.
- There's more.
- Refreshing the cache
- Getting ready
- How to do it.
- How it works.
- There's more.
- Creating a KPI with predefined values
- Getting ready
- How to do it.
- How it works.
- There's more.
- Creating a KPI with shared datasets
- Getting ready
- How to do it.
- How it works.
- There's more.
- Customizing the look-and-feel of the Web Portal
- Getting ready
- How to do it.
- How it works.
- There's more.
- Printing reports with the PDF rendering extension
- Getting ready
- How to do it.
- How it works.
- There's more.
- Embedding reports in other applications
- Getting ready
- How to do it.
- How it works.
- There's more.
- See also
- Chapter 8: Reporting Solutions for BI - Integration
- Introduction
- Making Reporting Services as a part of BI
- Getting ready
- How to do it.
- How it works.
- There's more.
- See also
- Creating a report using Multidimensional models
- Getting ready
- How to do it.
- How it works.
- There's more.
- Getting formatting from the Multidimensional model
- Getting ready
- How to do it.
- How it works.
- There's more.
- Getting aggregated values from the Multidimensional model
- Getting ready
- How to do it.
- How it works.
- There's more.
- Creating a report using Tabular models
- Getting ready
- How to do it.
- How it works.
- Connecting to the HDInsight cluster and getting unstructured data
- Getting ready
- How to do it.
- How it works.
- There's more.
- See also
- Chapter 9: SharePoint Integration
- Introduction
- Configuring SharePoint for Reporting Services
- Getting ready
- How to do it.
- How it works.
- Handling security with SharePoint
- Getting ready
- How to do it.
- Adding a user to your SharePoint site
- Altering permissions to a document library
- Altering permissions to a specific report item
- Removing a user's permissions from a report
- How it works.
- There's more.
- Creating dashboards using Reporting Services
- Getting ready
- How to do it.
- How it works.
- Configuring e-mail with SharePoint
- Getting ready
- How to do it.
- How it works.
- There's more.
- Configuring subscriptions
- Getting ready
- How to do it.
- How it works.
- Configuring data alerts
- Getting ready
- How to do it.
- How it works.
- Chapter 10: Administering and Managing Reporting Services
- Introduction
- Managing data sources
- Getting ready
- How to do it.
- How it works.
- There's more.
- Assigning configured data sources to published reports
- Getting ready
- How to do it.
- How it works.
- There's more.
- Caching reports
- Getting ready
- How to do it.
- How it works.
- There's more.
- Creating snapshots of reports
- Getting ready
- How to do it.
- How it works.
- Backing up Reporting Services
- Getting ready
- How to do it.
- How it works.
- There's more.
- Monitoring Reporting Services
- Getting ready
- How to do it.
- How it works.
- There's more.
- Chapter 11: Securing Reports in Reporting Services
- Introduction
- Authenticating users for Reporting Services
- Getting ready
- How to do it.
- How it works.
- Becoming a Report Portal System Administrator
- Getting ready
- How to do it.
- How it works.
- Authorizing users for accessing reports via SSRS roles
- Getting ready
- How to do it.
- How it works.
- There's more.
- Creating new roles in Reporting Services
- Getting ready
- How to do it.
- How it works.
- Editing existing roles in Reporting Services
- Getting ready
- How to do it.
- How it works.
- Filtering data for the current user
- Getting ready
- How to do it.
- How it works.
- There's more.
- Handling security on shared data sources
- Getting ready
- How to do it.
- How it works.
- There's more.
- Securing the channel using certificates
- Getting ready
- How to do it.
- How it works.
- Chapter 12: Custom Programming and Integration to .NET Applications
- Introduction
- Adding embedded codes to reports
- Getting ready
- How to do it.
- How it works.
- There's more.
- Referencing external .NET assemblies
- Getting ready
- How to do it.
- How it works.
- Opening reports using URL access
- Getting ready
- How to do it.
- How it works.
- There's more.
- Using ReportViewer control for accessing reports
- Getting ready
- How to do it.
- How it works.
- There's more.
- Index
