I have a report that connects to SQL Server and runs a stored procedure. Everything worked. I went in and renamed my stored procedure in SQL and then edited the dataset in AR Designer 11 changing to the new procedure name. It took it, but then cleared all the fields. I tried manually typing in all the fields but it’s still not working.
I even tried making a new dataset from this same stored procedure but the field names won’t come in. I also tried the exec procedure with params as text and while it ran and returned data in the editor, the field names never repopulated.
All I did was change the stored procedures name!