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.
Virtually every report is running twice. Any help would be greatly appreciated.
RE: Crystal 8.5 and 9 Reports looping
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
RE: Crystal 8.5 and 9 Reports looping
When you saved the report, did it have Verify on Every Print selected?
-k
RE: Crystal 8.5 and 9 Reports looping
RE: Crystal 8.5 and 9 Reports looping
RE: Crystal 8.5 and 9 Reports looping
RE: Crystal 8.5 and 9 Reports looping