Crystal Reports XI sub report will not update stored procedure
Posted on 2011-03-01
I have a report, that fires a sub report. The sub report's datasource is a stored procedure on a SQL Server 2008 database. It works fine.
Then I realize I need the stored proc to return additional data elements. So I add the new fields to the result set of the stored proc, and alter the stored proc in the database. I can run the stored proc in the database directly (via management studio). it works fine.
So I attempt to refresh the datasource, using the usual methods, and I just cant get the sub report's datasource to see the new columns.
In "normal Crystal", when I modify a table, and rerun, I get the "table XYZ has changed! Proceding to fix the report!" I can't get this to happen in this scenario.
Aside from rewriting the whole damn thing, what am I missing?