I modified a procedure in SSMS. For simplicity, lets say I was originally returning: CustomerID, JoinDate, and OrderID.
I ran a alter proc statement to return:
CustomerID, JoinDate, OrderID, and CancelDate.
I've tested and validated that the cancel date is being returned after executing the proc.
SSRS
The reports rdl file in Visual Studio uses a shared dataset that references the proc that I've altered. I've refreshed the fields on the shared dataset as well as for the dataset for the RDL. When I execute the report in Visual Studio I get results for the canceldate.
Browser
When the report is run in IE the browser. The 3 original columns return populated. The canceldate however, is left un-populated on all rows.
What I have tried:
I've altered the proc. I've refreshed the shared dataset. I've refreshed the dataset for the rdl.