SSRS Report Builder 2.0 - Error during processing

The Issue

After modifying a report and on running it, Report Builder 2.0 returns the following error:

alt

An error occurred during local report processing.
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.
The Quick Fix
  1. Return to the Design interface of Report Builder 2.0 for the problematic report:alt



     
  2. Right-click on the reported DataSet (in my case: DataSet1) and select 'Dataset Properties' alt



     
  3. Select 'Parameters' and click on the duplicated field alt



     
  4. Click on the 'Delete' button and you should be left with just:alt



     
  5. Test and run your report :c)
Category: SQL Server Reporting Services :: Article: 259

Add comment

Your rating:

Submit

Credit where Credit is Due:


Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

Please publish modules in offcanvas position.