I have this stored procedure that I have been testing and i finally got it working. Left the name of the Stored Proc with my initials tagged at the end. Then realized I could not leave them there but at the same time could not make a copy of the Stored Procedure with my initials off and map the Crystal Report to the new Stored procedure. There are hundreds of forumulas that would have to be redesigned with the new SP name etc etc. Is there a way to map from SP to SP.
I also made a change to the SP with the addition of a field and Crystal Was not able to accept the mapping to the report. Surely I will not have to rebuild every report over and over if a change is made to the stored procedure.