As you know, a dataset is the direct input component for SQL Server Reporting Services. These datasets are part of rdl files. Reports can use the datasets as an embedded dataset or shared dataset.
But in a real time, we mostly used embedded dataset for reports. Now, shared dataset is the mandatory option for SQL Server 2016 Reporting Services mobile reports.
There are plenty of articles available to show how to use the Shared Dataset for mobile report publisher. This article explains to you that how to create a shared dataset.
Shared dataset can be created any of the following tools.
Let us see the steps to create a shared dataset in Visual Studio Data Tools.
Let us discuss another scenario.
Scenario: Need to pass the parameter in shared dataset.
Follow the below steps,
Where <columnname> = @<parametername>
In the above syntax, you can pass any condition as like regular T-SQL script. Instead of value pass parameter name with @ symbol.
Share your comments below.