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.