[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Changing Passed Parameter Values in Crystal Reports for a Stored Procedure

Posted on 2004-10-26
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 28

Accepted Solution

bdreed35 earned 1000 total points
ID: 12409818
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 101

Assisted Solution

mlmcc earned 1000 total points
ID: 12410503
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

ID: 12410543
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 101

Expert Comment

ID: 12417748
Glad i could help


Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

656 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