×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Crystal 8.5 and 9 Reports looping

Crystal 8.5 and 9 Reports looping

Crystal 8.5 and 9 Reports looping

(OP)
Using 8.5 I fill a table with a stored proc and then use the data in the table for a report.  The table is being filled twice with identical data.  The proc ran alone fills the table only once.  I traced this to the 'verify on every print' option.  When selected it runs the proc twice.  I copied over the report so that I have two versions (verify on and verify off).  I then opened the reports in Crystal 9 on another PC.  There is no option to turn the verify on or off so I expected that both reports would fill the table once.  Both filled the table TWICE.  I have reviewed every option I can find in 9 but cannot find the reason for this.  I then saved a copy of the report as a version 9 one and the issue remains.

Virtually every report is running twice.  Any help would be greatly appreciated.

RE: Crystal 8.5 and 9 Reports looping

From this file:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr_database_menu.pdf

"In Crystal Reports 8.5, the Verify on Every Print command sends a SQL call statement to the database to verify changes every time the report is print-previewed or printed.
The Verify on Every Print command is not available in Crystal Reports 9 in the Report Designer. However, it is possible to use this command in a development
application."

-k

RE: Crystal 8.5 and 9 Reports looping

(OP)
Thank you for the information.  The 'verify on every print',when checked, runs the proc and accounts for the double run in 8.5 version.  When not checked in this version the report runs once as expected.  As I earlier noted, I ran both versions in 9 and had a double run on both 8.5 versions.  How could this be if that option cannot be set in 9?  When converted to version 9 reports, the double runs still occur.  This raises the question of 'why, if unable to set verify in version 9, does it run twice?'.  One would expect one result set returned.  I assume there is a setting somewhere in Crystal 9 that is causing the double run.  Where that setting is, report designer or query engine, or what that setting is, I am unable to find.  Since the 'Differences' documentation states that the 'Verify on Every Print command is not available in the designer but can be used in a development app' one would have expected both 8.5 versions to run once in Crystal 9.  Since both versions ran twice I suspect some setting is causing the Verification to be run as a default by the new query engine or the report.

RE: Crystal 8.5 and 9 Reports looping

I agree, it is odd, which implies that CR 9 does this by default.

When you saved the report, did it have Verify on Every Print selected?

-k

RE: Crystal 8.5 and 9 Reports looping

(OP)
I had one version with 'verify' checked and one version with it not checked.  The 'unchecked' version should not have run twice.  I am continuing to look into the issue.  If Crystal is using a 'forward only' recordset the  double read will happen whereas a dynamic recordset will not loop.

RE: Crystal 8.5 and 9 Reports looping

I believe CR 9.0 is set to verify on every print and cannot be changed.  I have seen it verify the database when printing.  This may be causing your problem.

RE: Crystal 8.5 and 9 Reports looping

(OP)
Thanks for your thoughts.  Our guess is in agreement with you.  If Seagate is using a 'forward only' cursor it will cause the multiple runs.  We found that by changing our development application to a 'dynamic' cursor AND using Sybase 12's latest update and Crystal 8.5 it does not run multiple times.  Using the 'dynamic' cursor on the last version of Sybase didn't help anything.  Nor did changing to Crystal 9.  If our suspicions are correct we are going to have to think long and hard about going to Crystal 9.  We have NOT tried Crystal 9 on the latest version of Sybase with a 'dynamic' cursor.

RE: Crystal 8.5 and 9 Reports looping

Crystal 9 now uses the Verify on First Refresh option.  Did you check your Report Options to see if this has been enabled, and therefore saved?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close