-
November 3rd, 2011, 01:27 AM
#1
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.
-
November 3rd, 2011, 07:03 AM
#2
Re: Retaining stored procedure parameters
Here I am talking about crystal reports
-
November 3rd, 2011, 09:52 AM
#3
Re: Retaining stored procedure parameters
Are the Stored Procedures also saved in the new database ?
JG
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
-
November 3rd, 2011, 11:28 PM
#4
Re: Retaining stored procedure parameters
Yes, stored procedures are also saved in the new database.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|