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.
Re: Retaining stored procedure parameters
Here I am talking about crystal reports
Re: Retaining stored procedure parameters
Are the Stored Procedures also saved in the new database ?
Re: Retaining stored procedure parameters
Yes, stored procedures are also saved in the new database.