CODEWITHSUNDEEP
visual-studio-2015sql-server-2008-r2ssrs-2016
The Faan
The Faan

Reputation: 33

VS2015 - SSRS 2016 Shared Dataset

I am having an issue with VS2015 using SSDT to build new reports (SSRS 2016). When using a Shared Dataset and referencing that in the report, it does not work and gives a very vague error. I am connecting to a SQL 2008 R2 database for the dataset.

An error occurred during local report processing.

The definition of the report '/Dataset1' is invalid.

As soon as I change the dataset to be an embedded dataset, it works perfectly fine.

Upvotes: 2

Views: 725

Answers (1)

yelxe
yelxe

Reputation: 176

Have a look at the XML for your shared dataset. Does it have a Name attribute? If not, try this workaround:

Replace

<DataSet>

with

<DataSet Name="Dataset1">

Rebuild your solution and try to preview the report.

IMPORTANT: If you make any changes to the dataset using Visual Studio, the attribute will be removed.

Hopefully this will do until Microsoft releases a fix.

If you wish, you can add a PowerShell script to your solution that will fix your files for you. You will need the following command for each shared dataset:

(Get-Content MyProject\MySharedDataset.rsd).Replace('<DataSet>', '<DataSet Name="MySharedDataset">') | Set-Content MyProject\MySharedDataset.rsd

Make sure you have PowerShell Tools for VS 2015.

Upvotes: 1

Related Questions