CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. November 3rd, 2011, 01:27 AM #1
    nitin6139
    nitin6139 is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. November 3rd, 2011, 07:03 AM #2
    nitin6139
    nitin6139 is offline Junior Member
    Join Date
    Nov 2011
    Posts
    3

    Re: Retaining stored procedure parameters

    Here I am talking about crystal reports
    Reply With Quote Reply With Quote
  3. November 3rd, 2011, 09:52 AM #3
    jggtz
    jggtz is offline Senior Member
    Join Date
    Jul 2005
    Posts
    1,083

    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 ...
    Reply With Quote Reply With Quote
  4. November 3rd, 2011, 11:28 PM #4
    nitin6139
    nitin6139 is offline Junior Member
    Join Date
    Nov 2011
    Posts
    3

    Re: Retaining stored procedure parameters

    Yes, stored procedures are also saved in the new database.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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

Featured