Print Page | Close Window

Changing Datasource from View to StoredProc

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1293
Printed Date: 06 May 2024 at 6:53pm


Topic: Changing Datasource from View to StoredProc
Posted By: ckapilla
Subject: Changing Datasource from View to StoredProc
Date Posted: 09 Sep 2007 at 5:26pm
Hi,
 
I have created a report based on a view for testing/development. Now that it is working and formatted correctly, I want to change the datasource to a stored procedure (with identical fieldnames).  If I use the 'Set Datasource Location' dialog box, it lets me specifiy what I want to do, but when I click on 'Update' nothing happens (except that the Update button gets grayed out').  Is there any way to point an existing field to a different datasource? I sure don't want to start over again and re-populate every field in the report!
 
thanks
 
Chris


Replies:
Posted By: rnareshk
Date Posted: 18 Sep 2007 at 1:50am
Hi,
 
What you have done is correct. To change the datasource from View to Stored Procedure, it is enough to use "Set DataSource Location".


-------------
Thank You,
Naresh.


Print Page | Close Window