Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2007
    Location
    Orlando,FL
    Posts
    35

    Unanswered: Stored Prod Parms

    Using SQL Server 2005 with Crystal Report XI. I have a report that is using a stored prod. The stored prod needs to parm passed to it. Not sure how to pass the parm from crystal to the stored prod. Thank you for your help. David

  2. #2
    Join Date
    Oct 2007
    Posts
    10
    How will you be deploying the report?

    Do you only need the stored procedure parameters passed when you are designing the report?

  3. #3
    Join Date
    Jul 2007
    Location
    Orlando,FL
    Posts
    35

    Stored Proc

    Will be using Crystal Enterprise. Yes, stored procedure parameters need to be passed when designing the report.

  4. #4
    Join Date
    Oct 2007
    Posts
    10
    I am still working with CR9 until my machine is updated, but most of the menu options should be similiar .. in the designer :
    (assuming connect to MSSQL)

    Database->Set DataSource Location->

    Create New Connection -> OLEDB(ADO) ->

    (Follow property page to set SQL connection info)

    //

    When you select a stored procedure, you should be prompted for parameters. This is partially because a procedure can potentially return different column information from different parameters. After you have set the parameters at least once, they will appear in the "Parameter Fields" section of the "Field Explorer" . If you need to reset parameters, either use "Verify Database" or preview the report and refresh the report information and you will be prompted for parameters again.

    Hope this helps.. i don't know exactly your setup, so i;m using mine as a reference..

    EDIT : Also, CR treats stored procs as if they were tables.
    Last edited by devbloch; 10-23-07 at 11:44.

  5. #5
    Join Date
    Jul 2007
    Location
    Orlando,FL
    Posts
    35
    Thank you. David

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •