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

Working with published datasets

In simple terms, a published dataset is nothing more than a SQL statement that has been stored in the Report Portal. This can be extremely valuable as business users often lack the ability to write even simple SQL queries.

In addition, this allows experienced SQL developers to write complex SQL queries and make them available to business users so that they can write reports from them. It also allows queries that are used over and over to be stored, saving users from having to rewrite them every time they wish to write a report.

Getting ready

Unlike published data sources, it is possible to create a published dataset from Report Builder.

Prior to creating the dataset, we will need a place to store it in the Report Portal. ...

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