2

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.

Community
  • 1
  • 1
The Faan
  • 33
  • 6
  • I am experiencing the same thing (I am using SSRS-2014; everything else is the same). I get the same issue whether my data source is 2008-R2 or 2014. I suspect this is an issue with VS rather than SSRS. Are you able to deploy your reports, and if so, will they work from the server? – yelxe Jun 23 '16 at 17:16
  • I just upgraded to from the Preview version of SSDT to the current version and the issue persists. – yelxe Jun 23 '16 at 19:18
  • Its turns out that the Name attribute of the shared dataset was missing as per @yelxe. After implementing his workaround, it worked fine. – The Faan Jun 25 '16 at 11:17

1 Answers1

1

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.

yelxe
  • 186
  • 1
  • 7