Mapping Stored Procedures in Crystal Reports 8.5

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.
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
YOu should be able to make a copy of the SP with the appropriate name then through SET DATA LOCATION map the report to the new SP

mlmcc
0
mlmccCommented:
For the new field, did you do a VERIFY DATABASE to get the change?

mlmcc
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Did not do the Verify Database that may be the ticket. Dont know why I forgot that one.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
It still does not work. I used SET LOCATION. Pointed adn selected the new Stored Procedure the difference of this
Rpt_SalesSummaryAdopted_sproc_MAC_RAMS_RB .......the one I was testing with...
and this
Rpt_SalesSummaryAdopted_sproc_MAC_RAMS.......the one I want to go to....

Then I went to Verify Database on refresh.....it prompted me for some parameters.....then it said the database is up to date. I go back to look to see if the Set Location held its position it did not. It is still pointing to the original SP it was built off of.

It looks like more and more I am going to have to rebuild every report from scratch for every change made to the Stored Procedure....God I hope not. I have just rebuilt this one 5 times.....any other advice.....?
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Even after I have set location and done a verify database......still no luck. I am inquiring withing IT departments here to get help as well. Let me know if you think of anything.
SetLocationFails-inCrystalReport.png
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Now I am finding out that I have a permissions issue that was not there last week and is now. I cannot get to the datasources through crystal.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.