Retaining stored procedure parameters
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4

Thread: Retaining stored procedure parameters

  1. #1
    Join Date
    Nov 2011
    Posts
    3

    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.

  2. #2
    Join Date
    Nov 2011
    Posts
    3

    Re: Retaining stored procedure parameters

    Here I am talking about crystal reports

  3. #3
    Join Date
    Jul 2005
    Posts
    1,075

    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 ...

  4. #4
    Join Date
    Nov 2011
    Posts
    3

    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
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center