I have a report that has been made in Visual Studio off of 3 stored procedures from SSRS, those stored procedures come with pre-set parameters that populate the parameter section in Visual Studio, which up until yesterday had worked perfectly well!
Yesterday our database managers renamed a View. So I went to update the stored procedure according, only fixing the one view name. And then when I went back to Visual Studio to refresh it, it gave me a text box I have never seen before and when I canceled it, it takes away my columns?
here is the new text box when I try to refresh
I have double checked but all the parameter names remain the same as that was not part of the update.
for example this is the procedure I am attempting to refresh
I have no idea what or why that box is popping up as my parameter types are set in the SSRS procedure (as varchar) and I am not passing nulls, so I ignore it and hit cancel (I have tried all sorts of variation of different combinations of clicking on it.)
But ultimately it refreshes like this and breaks my report As you can see no columns4
I am able to Ctrl-Z and get my column list back but I am honestly baffled.
I have cross checked all parameters are spelled the same, I deleted and re attached the saved procedures and data sets, all parameter types are varchar...
When you get the prompt for parameters, just fill them in with anything valid so the SP can run. The values you type will not be used after this so it does not matter what they are.
SSRS is normally just trying to re-evaluate your SP. If you pass valid parameters in one of two things will happen.
