CRW 3.0--Transferring Crystal Reports from one Database to 
         another:
 
 
There are basically two methods for transferring a Crystal Report
from one database to another.  The first one involves the ODBC 
Administrator.  The other involves the "Set Location" option
under the "Databases" menu.  Option 1 is the easiest.  When using
either method, it is only necessary for the destination database
to exist.
 
Method 1
 
1)  Ensure the new source database is installed in the ODBC 
    Administrator and the old database is removed.  If the old
    database is allowed to remain in the ODBC Administrator,
    the report will attempt to connect the old database.
 
2)  Start Crystal Reports, then Choose Databases|Log Off Server 
    and log off all databases.
 
3)  Open the report and choose File|Print Preview.  If saved data exists, 
    a dialog box will be displayed giving the option to print with
    saved data or refreshed data.  Choose refreshed data or
    Crystal Reports will use data stored with the report.  
    Since the datasource on which the report was based is missing, a
    list of current datasources will be displayed.  If the list
    of datasources from the ODBC Administrator does not display,
    you know that the source database is still listed there.
 
4)  Choose the new datasource from the ODBC Administrator and single
    click on the Command button marked "OK".
 
5)  Enter the User name and password if necessary and single click
    on the Command button marked "OK".
 
6)  Choose File|Save As and save the report to a new name or
    single click on the "disk" icon to save changes.
 
 
 
Method 2
 
1)  Ensure the new source database is installed in the ODBC 
    Administrator and the old database is removed.  If the old
    database is allowed to remain in the ODBC Administrator,
    the report will attempt to connect the old database.
 
2)  Start Crystal Reports and choose the File menu.  Open the report 
    you wish to transfer to a different database.
 
3)  Chooses Databases|Set Location.  The dialog box marked 
    "Set Location" gives information about the database on which
    the report is attached.
 
4)  Choose the Set Location Command Button.  Since the datasource
    on which the report was based is no longer in the ODBC
    administrator, a dialog box marked "SQL Data Sources" will
    appear with all data sources defined in the ODBC Administrator.
    If the list of datasources from the ODBC Administrator does 
    not display, you know that the source database is still listed 
    there.
 
5)  Highlight the new datasource and click on the Command marked
    "OK".  You will be prompted to enter a User name and password.  
    Enter this information if necessary then single click on the
    Command button marked "OK".
 
6)  A dialog box marked "Choose SQL Table" is displayed.  Under
    SQL Tables, choose the destination table on which the report
    will be based.  This will be the same as the driving table in 
    the source database.
 
7)  Click the Command button marked "OK".  Note that the
    information at the bottom of the dialog box marked "Set 
    Location" has changed to reflect the new location of the
    report.
 
8)  Click the Command button marked "Done".
 
 
9)  Choose File|Save As and save the report to a new name or
    single click on the "disk" icon to save changes.
 
 
- Note:  This procedure discribes the transfer of single table reports.
         It is necessary to Set Location for each table of the report.