Too many argument error when I add a column in stored procedure to display in my SSRS report

Question

I have added a new column to my table and I want the same to reflect in my SSRS report which takes values from a stored procedure.But when I run my report I am getting 'Too many arguments in my stored procedure' error. Please help.

Answer 1

The error you are getting means the stored procedure is expecting fewer arguments than are configured for the dataset. Open the dataset configuration and click Refresh Fields. You might need to clean up now-unused parameters and or perhaps update the SProc. Also, you will need to alter your SProc anyway in order to add new fields. Refresh Fields will take care of that too.