Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

Change Sproc name in crystal 10

Hello,
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.


0
JDCam
Asked:
JDCam
  • 3
  • 2
1 Solution
 
peter57rCommented:
Database>Set Datasource location
0
 
JDCamAuthor Commented:
peter57r,
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.
0
 
peter57rCommented:
Don't know.

It suggests there is something about the 'new' sp that makes it unavailable. Permissions? Does it return records?
0
 
JDCamAuthor Commented:
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.
0
 
JDCamAuthor Commented:
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.

Thanks,
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now