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.

Hi hilfy,

Thanks for replying.

I am doing the same thing. I am trying to set new data source location. But when I do that, stored procedure doesn't get updated. If I click on stored procedure and then try to update it, parameters of the procedure are getting lost and new parameters are being generated.

Please try to help me.


Thanks