O'Reilly logo

SQL Server 2016 Reporting Services Cookbook by Robert C. Cain, Dinesh Priyankara

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8. Reporting Solutions for BI – Integration

Although most reporting solutions are designed for handling OLTP solutions, reports play a major role in Business Intelligence (BI) solutions as well. Generally, Production Reports or Formal Reports (sometimes called Paginated Reports) are the ones we create for OLTP solutions, whereas Analytical Reports, Dashboard Reports, and Mashup Reports are created for Business Intelligence solutions.

Reporting Services 2016 is an enterprise reporting platform that is rich enough to address requirements related to both OLTP and BI solutions. Its capabilities allow us to make reports suitable for BI solutions. It also enhances the user experience with its features providing both ad-hoc reporting and self-service ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required