Retaining stored procedure parameters

Hi,


I have created a report using stored procedure with 5 parameters. Out of these parameters, 3 parameters are dynamic and linked to a sql query using command. This report is working fine in my development environment. We are connected to SQL Server using OLEDB.

Now when we are deploying the report in our UAT environment. We are changing the database and we are losing the parameters properties like prompt text, values, dynamic queries etc.

Suggestions are appreciated.

Thanks.

Here I am talking about crystal reports

Are the Stored Procedures also saved in the new database ?

Yes, stored procedures are also saved in the new database.