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

Crystal 2008, SQL stored procedure with a parameter from within report?

I created a report that uses an SQL stored procedure with a parameter. However, i do not want the end user to input a value. I want the report to send an ID value or use the input parameter to the report. I have not been able to figure out how to do that. Is there a way to set an SQL input parameter to a value already in the report and NOT have the end user input a value?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2009 at 09:41 AM

    Hello Linda,

    I recommend to post this query to the [Crystal Reports Design|SAP Crystal Reports; forum.

    This forum is dedicated to topics related to the creation and design of Crystal Report documents. This includes topics such as database connectivity, parameters and parameter prompting, report formulas, record selection formulas, charting, sorting, grouping, totaling, printing, and exporting but also installation and registering.

    It is monitored by qualified technicians and you will get a faster response there.

    Also, all Crystal Reports Design queries remain in one place and thus can be easily searched in one place.

    Best regards,

    Falk

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2009 at 06:04 PM

    You could add the procedure based report as a subreport. Then link the subreport to the main report by the parameter (in the stored procedure based subreport) and the field/formula (with custom value) you want to pass to the procedure.

    Edited by: James Pretorius (CCLTD) on Jul 20, 2009 7:05 PM

    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.