Home Forums Reporting Services Reporting Services 2008 Development ssrs error variable name '@pCNum' has already been declared. variable names must be unique within a query batch or stored procedure. " RE: ssrs error variable name '@pCNum' has already been declared. variable names must be unique within a query batch or stored procedure. "
Gazareth
One Orange Chip
Points: 27737
More actions
August 11, 2014 at 3:23 am
#1736739
Are you declaring @pCNum in the dataset code?
In SSRS you don't declare the parameter in code. That's how BIDS determines it's a report parameter.