PDA

Click to See Complete Forum and Search --> : [RESOLVED] modified stored procedures


dino624
Oct 12th, 2007, 07:46 AM
I am using crystal 10 and I have a report that has a stored procedure linked to it. I have changed the stored procedure to remove one field and add another. I would like to modify the report to reflect this change. How do I do this without redoing the entire report.
The only I can figure to change the stored procedure in the report is to remove and re-add the procedure which in turn removes the fields from the report. I really do not want to redo the report this way. There must be a better way of doing this that I have missed.

Asgorath
Oct 12th, 2007, 08:04 AM
If you are using Visual Studio, just open the report and select 'Verify Database'.

dino624
Oct 12th, 2007, 09:27 AM
Thanks, that did the trick.