Change Sproc name in crystal 10

Posted on 2009-02-17
Last Modified: 2012-05-06
I have a Crystal report that uses a stored procedure to return most of the data. At the database level (SQL Server)  I have altered the stored procedure slightly under a new name. At the database level, both procedures exist and function as desired.

In Crystal, without having to redo from start, how do I change the report to point to the new version of the stored procedure. In Database expert, I do not see the new one, only the old. Why can't Crystal see it? permissions for both are the same and owner is dbo.

Question by:JDCam
    LVL 77

    Expert Comment

    Database>Set Datasource location

    Author Comment

    when I goto 'Set Datasource Location' the new sproc does not appear on the bottom half of the screen, only the original.

    I have logged off/on to try to get it to refresh the list but no luck so far.
    LVL 77

    Accepted Solution

    Don't know.

    It suggests there is something about the 'new' sp that makes it unavailable. Permissions? Does it return records?

    Author Comment

    Partial Sucess !!
    it was permissions. I found on the original there was a user 'db_executor', when added to the new version it immediatly became visible in Crystal

    now, how to change it in crystal..  Set data location dosent appear to change it. Maybe it only works on proper tables.

    Author Comment

    Actually, it looks like it does work. It updates the procedure, just fails to update the name. A simple right click rename and everything is good.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now