How do I fix an SSRS report that returns data in visual studio but doesn't in the browser?

See more:

Visual-Studio

SSRS

, +

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.