• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 532
  • Last Modified:

Swap MS SQL Stored Procedure used as datasource in Crystal XI report

I have a SQL 2005 stored procedure I've used as the datasource in Crystal XI report. I also have a second SQL 2005 test stored procedure on the same server that I want to "swap" with the original stored procedure.

I'm attempting this in the Set Datasource Location window in Crystal XI. First, I create a new ODBC connection in the bottom half of this screen and navigate to StoredProcedure#2. I then select StoredProcedure#1 (current datasource) in the the top half of the screen and click "Update". When I test the results it seems to in fact be using the new code from StoredProcedure#2 however "StoredProcedure#1" continues to display as the current data source. Any ideas how to get this description to update?

Thanks for your help!
1 Solution
If you expand the values in the top of set datasource location,  you should see your new proc listed, the alias is what shows up more prominently.
Use Data Expert to change the alias used by Crystal (F2).  
dking_wriAuthor Commented:
Thanks UnifiedIS!  That worked perfectly.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

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