How to Change Database using Crystal Report Design [Solved]

How to Change Database using Crystal Report Design

Let me give you step in detail :

1. Open up your crystal report

2 . Set databaseĀ  source

3 .Create a new connection

4 . Locate stored procedure or view (whatever you are using ) from database

5 .Select your previous stored procedure and select new stored procedure (having same name is better)at bottom screen(where you create new connection )

6 .Update .

It will take some timeĀ  and close that database source window .

You are good now with new connection . Refresh the report .

Crystal Report

How to Change Database using Crystal Report Design

Credit: http://scn.sap.com/thread/1309361