Solved: Mapping Stored Procedures in Crystal Reports 8.5

Create Account

Microsoft SQL Server

Questions

Followers

Top Experts

RUA Volunteer2?🇺🇸

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.

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

SOLUTION

Mike McCracken

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

SOLUTION

Mike McCracken

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

ASKER CERTIFIED SOLUTION

RUA Volunteer2?🇺🇸

ASKER

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

RUA Volunteer2?🇺🇸

ASKER

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.....?

RUA Volunteer2?🇺🇸

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

RUA Volunteer2?🇺🇸

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.

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Microsoft SQL Server

Questions

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.