Skip to Content
avatar image
Former Member

how do you pass a parameter to a stored procedure in Crystal 11

I have a Crystal 11 report with a parameter.I've added a stored procedure to that report. When I added the stored procedure Crystal added another parameter to the report. I would like to pass the parameter I already have in the report to the stored procedure. This is very simple to do in SSRS. How do I do this in Crystal?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • May 30, 2012 at 05:47 PM

    Create a Record Selection Formula

    NewParam = OrgParam

    Don

    Add comment
    10|10000 characters needed characters exceeded

  • May 30, 2012 at 08:37 PM

    Hello James,

    When you added the stored proc to the report and noticed that it added another parameter to the report that was in fact the stored proc parameter coming into the report. It sounds like you had already created a "Crystal Report" parameter but you should use the stored proc parameter as the values will be passed to the stored proc that way.

    Regards,

    Graham

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi James,

      What is the result of executing the stored procedure from SQL plus / TOAD?

      It seems that you want to get all columns from CNVHANSEN_I.CNV_HANSEN_PAYROLL table where APPROVALNUM = PARAM_APPROVAL.

      Do you really need a stored procedure with a cursor for that?

      As per my understanding, a cursor is supposed to return one row at a time. Also, the cursor does not seem to be advanced or looped or incremented to fetch all rows.

      Secondly, if you want to change a report's datasource from a 'View' to a 'stored procedure' then both should return similar number of columns. Although, I still doubt whether its a good practice.

      Thanks,

      Prathamesh