Solved

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

Posted on 2009-06-29
2
523 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
0
Comment
Question by:dking_wri
2 Comments
 
LVL 18

Accepted Solution

by:
UnifiedIS earned 500 total points
ID: 24739550
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).  
0
 

Author Closing Comment

by:dking_wri
ID: 31598113
Thanks UnifiedIS!  That worked perfectly.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to query LOCK_ESCALATION 4 41
Date is within the current week in Crystal Reports 2 61
Urgent help needed! Unable to to paste in query designer 29 44
SQL Error - Query 6 26
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

809 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