Changing Passed Parameter Values in Crystal Reports for a Stored Procedure

Posted on 2004-10-26
Last Modified: 2012-06-22
Ok, Just needing a Quick response.... I have a SQL Stored procedure that requires two values to be passed to it, these are @QueryDate and @PrevWeekLoop.

When i first specify the Stored Procedure in Crystal it comes up with a box where i set up the Parameter Values, i.e. i specify 18/06/2004 for @QueryDate and @PrevWeekLoop as Zero, after taking both of then off Default to Null.

Now, i work on the Report for a while, previewing it a few times, but also updating the SQL Stored Proc a few times too, Clicking Update Database every time. The Crystal Report will always find the changing and update itself.

Now, After a while, after changing the SQL Stored Procedure, the @QueryDate and the @PrevWeekLoop are now suddenly defaulting to Null and i can't find a Screen to specify any defaults. Also, When i press the Refresh Report Data button, it prompts me with 'Do i want to use the current parameter Values or do i want to Prompt for new parameter Values' ... After selecting the Latter, no box appears and my blank report appears in the Preview screen (Which is being caused by Nulls being passed for both Values)

How do i edit the values that are being passed to my stored procedure??

I'm using XP and CR10.
Question by:Cloud9_User
    LVL 28

    Accepted Solution

    I haven't experienced that behavior before but take a look to see if you have Saved Data With Report et.

    If File, Saved Data With Report is checked, then select to remove the check.
    After this, you should have to provide values to run the report.
    LVL 100

    Assisted Solution

    I haven't seen that either but I don't use Stored Procedures very often and most of my reports stay relatively static as far as data structure changes.


    Author Comment

    Well.... it seems to have stopped since i selected Refresh Store Procedure on PReview in the main options.

    Either way, You both had a go so i'll split the points

    Thanks for the Effort!
    LVL 100

    Expert Comment

    Glad i could help


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    857 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now