I am using a SQL stored procedure as a data source in a Crystal Report (2008). After I linked the stored proc, I changed the datetime parameters to date parameters. Crystal Reports recognized the change when I used the Verify Database function. In the course of designing the report, I found the need to modify the stored proc. I modified one field without changing the name (just trimmed some leading zeroes) and added a new field. The Verify Database function did not pick up the changes.
I started a new report and linked to the stored proc and still could not see the changes. I created a new stored procedure and linked to it and could not see the changes. I even tried to link the stored proc to Excel and couldn't see the changes.
And yes, I have checked to make sure I am connecting to the correct database. As I indicated above, my first change was recognized.
Any ideas would be greatly appreciated.
I started a new report and linked to the stored proc and still could not see the changes. I created a new stored procedure and linked to it and could not see the changes. I even tried to link the stored proc to Excel and couldn't see the changes.
And yes, I have checked to make sure I am connecting to the correct database. As I indicated above, my first change was recognized.
Any ideas would be greatly appreciated.