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

Report prompting for stored proc parameter twice

I have a report that connected to a stored proc that didn't initially require a parameter. I had to modify the sp so that it now requires a date input @report_date. Back at the crystal report, i've verified the database and was promped to enter a value for @report_date. A parameter named @report_date was also automatically generated under the 'Parameter Field' which I cannot remove but can rename. Now, whenever I refresh the data I get prompted for a @report_date value and then the report parameter dialog display where it prompts me again for the report Parameter Fields including @report_date(which I've since renamed).

Is there any way I can edit my report so that it doesn't prompt for that same stored proc parameter twice? It seems unnecessary since whatever I put in for @report_date the first time is overridden by the Parameter Field @report_date value.

Thank you,

JL

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Dec 19, 2008 at 09:38 PM

    Hi Jesse,

    The parameter in Crystal was created because it's linked to the Stored Procedure so you can use it in the report. I'm pretty sure if you rename it back to it's original name you will not be prompted twice.

    Good luck,

    Brian

    Add a comment
    10|10000 characters needed characters exceeded

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.