Skip to Content

Stored procedure in Crystal report

Hi,

I have a stored procedure with three parameters[ two string and one date parameter] which is connected to the crystal report. When I create the Crystal report I have selected this stored procedure as Data Source. When I finished the Report creation Wizard, The parameters are already set as of the Stored Procedure Parameter.

What I need is :

The parameter prompted as a simple text field, I need date time picker for date parameter, and other two parameter with CFL of Customer and List of Currency respectively. Is there any option to do so ?

Please Help, Thanks in advance !!!!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jan 31, 2013 at 05:06 AM

    Hi Vibin,

    When you create a report against a stored procedure, the parameters are always prompted as simple text fields; meaning date/datetime parameters will not show the calendar picker.

    To show the calendar picker, follow these steps:

    1) Create a blank report (you may point its datasource to an excel file too)

    2) Go to the Field Explorer > Right-click Parameter Fields > Create New parameter. Choose the datatype as "DateTime" and type as "Static"

    3) Go to Insert > Subreport. Choose the stored procedure as the Datasource of this Subreport. Follow the wizard and you might need to enter the values for the first time. Once you're back to the report canvas go to the Main Report's design Page.

    4) Right-click the Subreport > Select Change Subreport Links > Choose the DateTime parameter from the Pane on the left and move to the Fields to link to Pane on the right.

    5) From the drop-down on the bottom left-side where it says "Subreport Parameter field to use", choose the DateTime prompt from the Subreport's source.

    6) Next for the other two parameters, you can simply create them manually in the Subreport just like you did in the Main Report. Only this time the datatype will be different and you might have to manually type in the List of Values in the Parameter creation screen.

    Let me know how this goes!

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Sir

      I tried the above method and it works perfectly fine in design mode.But has i import report in SAP ,

      SAP Business one preview, I am not seeing the drop down boxes for my parameters. What is the reason