How can I change the data source in a Crystal Report?

Question

I have an existing Crystal Report that is working. It calls a stored procedure in a SQL Server database. I am trying to add a new input parameter to the stored procedure, but the Crystal Report will not "fix up" the database. Usually if I add a field to a stored procedure and call Verify Database it will tell me the database has changed and ask me if I want to "fix up" the database. It is not doing that now. Is it not possible to change the parameters in a stored procedure being used by a Crystal Report? Do I have to create an entirely new Crystal Report or is there some shortcut to revising my existing report?

To DT: It looks like that will work. I will have to add the fields back to the report but at least the headers stay in place.

Thanks for your quick reply.

Answer 1

Database->Remove and remove the current DB

Then Database->Add database

Have you checked the ODBC connections?