The Issue
After modifying a report and on running it, Report Builder 2.0 returns the following error:
An error occurred during local report processing.The Quick Fix
An error has occurred during report processing.
Query execution failed for dataset 'DataSet1'.
The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure.
-
Return to the Design interface of Report Builder 2.0 for the problematic report:
-
Right-click on the reported DataSet (in my case: DataSet1) and select 'Dataset Properties'
-
Select 'Parameters' and click on the duplicated field
-
Click on the 'Delete' button and you should be left with just:
- Test and run your report :c)