CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Hybrid View

  1. March 24th, 2009, 02:56 PM #1
    drhoades32
    drhoades32 is offline Junior Member
    Join Date
    Nov 2008
    Posts
    6

    drop down parameter with stored proc?

    Crystal Reports XI, SQL Server 2005
    I have a report that calls a complex stored proc in SQL Server as the datasource (it has 8 parameters). We've been asked to make one of the parameters a dynamic drop-down but the only examples and info I've seen used tables as the data source. Is it possible to use a dynamic drop down with a stored procedure and if so, suggestions on implementation? Everything I have tried has returned an error. Thanks.
    Reply With Quote Reply With Quote
  2. March 26th, 2009, 04:48 AM #2
    Bill Crawley
    Bill Crawley is offline Senior Member
    Join Date
    Aug 2000
    Location
    Essex, Uk
    Posts
    1,214

    Re: drop down parameter with stored proc?

    easiest way would be to front the report with a vb/c# front end then pass the parameters as a part of the call to the report.
    If you find my answers helpful, dont forget to rate me
    Reply With Quote Reply With Quote
  3. March 26th, 2009, 11:22 AM #3
    jggtz
    jggtz is offline Senior Member
    Join Date
    Jul 2005
    Posts
    1,083

    Re: drop down parameter with stored proc?

    Could You edit that parameter in Crystal Reports as Allow Multiple Values and Set Default Values
    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