I have developed a CR 9 (Standard edition) report that uses a SQL Server parameterized stored procedure as a datasource (it creates a table). It is located on a Development box. Everything works fine there. It is now necessary to move the stored procedure to the Production Box, and point CR 9 to the new datasource on the Production box. The stored procedure in both databases are identical except for the code that points to the database name. The databases are on the same server. The field names and datatypes are identical.
Go to Database>Set Location does not work. Attempting to update the datasource (a new connection to the Production database datasource exists) brings up the 'Map Fields' dialog box, although no field names or datatypes have been altered. Each stored proc references the same source data from a data warehouse and each creates identical tables, except the original report pointed to the DEV database, and I need it to point to the stored proc datasource on the the PRODUCTION box.
Any assistance will be appreciated, and I apologize for the long-winded question. BTW - could this be a short-coming of the Standard version of Crystal Reports 9.0?
Go to Database>Set Location does not work. Attempting to update the datasource (a new connection to the Production database datasource exists) brings up the 'Map Fields' dialog box, although no field names or datatypes have been altered. Each stored proc references the same source data from a data warehouse and each creates identical tables, except the original report pointed to the DEV database, and I need it to point to the stored proc datasource on the the PRODUCTION box.
Any assistance will be appreciated, and I apologize for the long-winded question. BTW - could this be a short-coming of the Standard version of Crystal Reports 9.0?