RUA Volunteer2?
asked on
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
SetLocationFails-inCrystalReport.png
ASKER
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.
ASKER
Rpt_SalesSummaryAdopted_sp
and this
Rpt_SalesSummaryAdopted_sp
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.....?