JDCam
asked on
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.
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.
peter57r
Database>Set Datasource location
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER
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,
Thanks,