Packt+ | Advance your knowledge in tech

0

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

SQL Server 2016 Reporting Services Cookbook

You're reading from SQL Server 2016 Reporting Services Cookbook Your one-stop guide to operational reporting and mobile dashboards using SSRS 2016

Product type Paperback

Published in Nov 2016

Publisher Packt

ISBN-13 9781786461810

Length 596 pages

Edition 1st Edition

Languages

SQL

Tools

SQL Server

Concepts

Business Intelligence

Authors (2):

Priyankara

Robert Cain

View More author details

Table of Contents (18) Chapters

SQL Server 2016 Reporting Services Cookbook

Credits

About the Authors

About the Reviewers

www.Packtpub.com

Preface

1. Getting It Ready – Configuring Reporting Services FREE CHAPTER

2. Authoring Reports with SQL Server Data Tools

3. Advanced Report Authoring with SQL Server Data Tools

4. Authoring Reports with Report Builder

5. Improving User Experience – New Designing and Visualization Enhancements

6. Authoring Reports with the Mobile Report Publisher

7. Consuming Reports – Report Access Enhancement

8. Reporting Solutions for BI – Integration

9. SharePoint Integration

10. Administering and Managing Reporting Services

11. Securing Reports in Reporting Services

12. Custom Programming and Integration to .NET Applications

Integrating R with Reporting Services

Without a doubt, R is the most popular language among data statisticians and data miners for statistical computing and graphics. It is an open-source language and it provides highly extensible statistical and graphical techniques such as time series analysis, classifications and clustering for data analysis. R is not a new language; its history goes back to 1992. However, the beta version was released in 2000 but R became more popular with a high demand in recent years.

Realizing the importance of R, Microsoft introduced SQL Server R Services with SQL Server 2016. It extends the SQL Server platform, integrating R language with SQL Server, allowing us to analyse data in the database using richest and powerful R language without taking data outside the database. This integration makes it possible to use TSQL and call the R runtime using packages created by the community for data analysis, prediction and for making visuals.

We are talking about Reporting...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $15.99/month. Cancel anytime

Authors (2)

Priyankara

Priyankara

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.

See other products by Priyankara

Robert Cain

Robert Cain

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.

See other products by Robert Cain

Personalised recommendations for you

Based on your interests and search pattern

Mathematics of Machine Learning

Mathematics of Machine Learning

Deepen your theoretical knowledge and enhance your ability to solve complex machine learning problems with structured guidance. Gain the confidence to engage with advanced ML literature and tailor algorithms to meet your project requirements.

May 2025 24h 20m

Generative AI with Python and PyTorch

Generative AI with Python and PyTorch

Learn how to create images and text using VAEs, GANs, LSTMs, and transformers. Implement applications in natural language processing and computer vision through practical tutorials.

Mar 2025 15h 0m

Practical Generative AI with ChatGPT

Practical Generative AI with ChatGPT

This book helps you unlock ChatGPT's potential to make your working life better. From prompt engineering to creating custom GPTs, you'll enhance your productivity, creativity, and efficiency with practical insights and advanced techniques.

Apr 2025 12h 52m

Generative AI with LangChain

Generative AI with LangChain

Gain a solid foundation in LangChain, agentic AI, and LangGraph, and learn to build production-ready systems with multi-agent architectures, advanced RAG pipelines, Tree of Thought reasoning, agent handoffs, and fine-grained error handling.

May 2025 15h 52m

Architecting Power BI Solutions in Microsoft Fabric

Architecting Power BI Solutions in Microsoft Fabric

Power BI provides several options to solve common data problems, and designing the correct solution for each scenario can be a daunting task. This book makes it easier by guiding you through designing optimal solutions using Power BI.

Apr 2025 14h 16m

Microsoft Identity and Access Administrator SC-300 Exam Guide

Microsoft Identity and Access Administrator SC-300 Exam Guide

This comprehensive guide covers key topics such as Microsoft Entra ID implementation, authentication and access management, external user management, and hybrid identity solutions, providing practical insights and techniques for SC-300 exam success.

Mar 2025 19h 48m

LLM Design Patterns

LLM Design Patterns

This book helps you gain practical skills to develop and deploy LLMs. You'll learn data prep, training, pruning, quantization, and evaluation, as well as explore RAG, advanced prompting, and optimization to build robust, scalable language models.

May 2025 17h 48m

Tableau Cookbook for Experienced Professionals

Tableau Cookbook for Experienced Professionals

Advance your Tableau knowledge beyond the basics, streamline dashboard performance, tackle advanced geospatial challenges, and unlock API potential while fortifying your corporate data infrastructure with proven best practices.

Apr 2025 12h 24m

Time Series Analysis with Spark

Time Series Analysis with Spark

This book offers a complete guide to time series analysis with Apache Spark and Databricks, covering essential concepts and advanced techniques including Generative AI to equip readers with skills for real-world challenges across industries.

Mar 2025 9h 56m

Hands-On Artificial Intelligence for IoT

Hands-On Artificial Intelligence for IoT

Transform IoT systems with the power of artificial intelligence using this hands-on guide. Dive into practical techniques and expert insights to innovate and optimize your IoT devices, making them smarter and more efficient.

May 2025 15h 44m