CODEWITHSUNDEEP
visual-studio-2013reporting-servicessql-server-2008-r2ssrs-2008-r2
Our Man in Bananas
Our Man in Bananas

Reputation: 5979

Cannot add new shared dataset to report

I have a summary report with about 20 datasets, linking to 20 detail sub-reports.

I have added datasets based on stored procedures for each of the detail reports.

Now when I try to add another one I get an error message

Could not create a list of fields for the query. Verify that you can connect to the data source and that your query syntax us correct.

and in the details it states:

An item with the same key has already been added.

So I have executed the stored procedure in SQL Server, no problems. I have executed the stored procedure in the Query Designer in SSRS, and it works fine.

I have restarted VS 2013, and reloaded the project. The project rebuilds with no errors. The report(s) deploy to the report server with no issues or errors.

Is there something else I can do to clean out the project file? I need to be able to include these extra datasets.

Upvotes: 1

Views: 869

Answers (1)

Joao Leal
Joao Leal

Reputation: 5542

The most likely reason for this error is that your stored procedure returns a table which has duplicated field names.

Just double check that all the field names are unique, and it should work.

Upvotes: 2

Related Questions