Skip to Content
author's profile photo Former Member
Former Member

Regarding prompt panel not appearing in Business Objects while using stored procedures in Crystal

Hi Guys,

I am using a stored procedure as a data source in Crystal. I am not able to use the prompt panel in Business objects when i save the report to Business objects. If I do not use a stored procedure, the prompt panel appears. But the requirement needs a stored procedure and when I use it, the prompt panel does not appear in Business Objects. In this case, the user needs to open the report each time he or she wants to enter new values for the parameters.Is there a way to make the prompt panel appear in Business objects while using stored procedures in Crystal? Any help will be much appreciated.

Thanks and regards,


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 25, 2016 at 07:27 AM

    Hi Ashwin,

    It should as for a input parameter when you have input parameters in your stored procedure. Can you to Schedule it instead of viewing ? and see whether you will be able to see parameters.


    May be you are saving the report data so, when you go in BO it shows the same results or may be you are trying to click on View option this will also give you the saved data results.

    Go in report remove check for 'Save Data with report' from File menu and try to save the report on BO.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Abhilash Kumar

      Hi Abhilash,

      I figured it out. I embedded the stored procedure in a sub report and linked my parameters in the main report to those of the stored procedure in the subreport. This removed the set to null issue and also allowed the prompt panel to appear.



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.