We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

Medium Priority
542 Views
Last Modified: 2012-06-21
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!
David
Comment
Watch Question

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thanks UnifiedIS!  That worked perfectly.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.