Stored Procedure as datasource for crystal reports

Discussion in 'ASP .Net' started by Versteijn, Apr 1, 2004.

  1. Versteijn

    Versteijn Guest

    Hello all

    I want to define a crystal report and assign the stored procedure
    GetOpenQuestions() as it's datasource and provide a set of parameters.

    How does this work? My target situation is that I provide a server
    name, stored procedure name and it's parameters, and make crystal
    connect to the database itself. So I don't want to get the data myself
    and bind it to the report manually.

    Is this possible? How would I do this?
    Thank you in advance.

    Regards,

    Freek Versteijn
     
    Versteijn, Apr 1, 2004
    #1
    1. Advertising

  2. Versteijn

    Joy Guest

    > Is this possible?
    most certainly yes. sp's can be treated as datasource's

    >> How would I do this?

    not sure what what u mean by that. if the developing point to a sp (not
    shown by default) in the new report wizard in cr designer.

    or is your questions related to publishing the report ???



    Versteijn wrote:
    > Hello all
    >
    > I want to define a crystal report and assign the stored procedure
    > GetOpenQuestions() as it's datasource and provide a set of parameters.
    >
    > How does this work? My target situation is that I provide a server
    > name, stored procedure name and it's parameters, and make crystal
    > connect to the database itself. So I don't want to get the data myself
    > and bind it to the report manually.
    >
    > Is this possible? How would I do this?
    > Thank you in advance.
    >
    > Regards,
    >
    > Freek Versteijn
     
    Joy, May 7, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. kavitha N via .NET 247

    passing parameters to stored procedure from crystal reports

    kavitha N via .NET 247, Jun 8, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    10,824
    galahad
    Feb 15, 2011
  2. Peri
    Replies:
    1
    Views:
    2,991
    =?Utf-8?B?Um90aGFyaWdlcg==?=
    Jul 21, 2005
  3. Replies:
    3
    Views:
    13,959
    raghav
    Sep 6, 2006
  4. Saravanan

    Crystal Reports in ASP.NET using Stored Procedure

    Saravanan, Apr 7, 2005, in forum: ASP .Net Datagrid Control
    Replies:
    3
    Views:
    380
    Elton Wang
    Apr 11, 2005
  5. Burak Gunay
    Replies:
    0
    Views:
    131
    Burak Gunay
    Jun 21, 2006
Loading...

Share This Page