?
Solved

Crystal Reports Stored Procedure Prompts Twice Runs Twice

Posted on 2009-04-07
2
Medium Priority
?
1,862 Views
Last Modified: 2012-08-14
I am working on some legacy Crystal Reports and was not around when they were created (they could have been created in Crystal Reports XI SP1 but we currently develop in Crystal Reports SP5 so these could have been initially created by SP1-SP5).

I have added some code to each of the Oracle Stored Procedures to audit every time they run to enable me to get stats on usage and time taken.  Some of the reports are calling the same Stored Procedure twice (about 8 reports do this out of 50 I am working with and there appears to be no difference in the type of reports they are and none have sub-reports).  I know this because there are two distinct entries in my audit table, one starting immediately after the other.  When I run the reports , I get two 'Enter Values' prompts for the parameters, one after the other, prompting for the same parameters.  It is almost as if it is verifying the data source before actually running the Stored Procedure but is actually carrying out the Stored Procedure run both times and returning records both times.  The number of records is correct ultimately so it is not combining info, just doing a second call to the same Stored Procedure.  I have looked at the Parameter fields and there is only one copy of each (so nothing obvious like duplicate parameters).  There is only reference to one Stored Procedure in each report.   If I rebuild the report again from scratch, it only runs once as I want but surely there must be something hidden in Crystal which is telling it to run twice which I can simply change to stop this happening.  Any suggestions where I might look?
0
Comment
Question by:hydev
[X]
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 Comments
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 2000 total points
ID: 24087800
Some things to check:

1)  Navigate to File|Report Options and see if either "Verify on first Refresh" or "Verify Stored Procedures on First Refresh" are checked.  You'll need to do this for each report that has the issue, because report options are specific to each report.

2)  Are you sure there aren't any hidden subreports?  I've seen people design a subreport so small that you can't tell what the object is.  An easy way to see if there's a subreport is to navigate to Edit|Subreport Links

~Kurt
0
 

Author Closing Comment

by:hydev
ID: 31567523
Kurt,

top job!  Both were checked.  I had looked at those as well, they just didn't register in my head.  Easy when you know how...

Thanks again.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses
Course of the Month8 days, 2 hours left to enroll

765 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