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. ...
Get SQL Server 2016 Reporting Services Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
