We have a shipping application that uses CR 8.5 to print a packing slip. We are having an itermittent problem where the packing slips take up to 30 seconds to print. This is unacceptable. If I run the SP that pulls the data in Query Analyzer it pulls the data in less that a second. What could be causing this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Crystal called in application
- Thread starter JohnEck
- Start date
John,
Do you get the same time delay when opening the report in Crystal? IN other words, is the delay only in the application or in Crystal?
If in Crystal, use Database, Show SQL Query to make sure the WHERE clause is passing the record selection criteria to the DBMS (in the WHERE clause).
If it doesn't, show us the record selection formula of the report.
hth,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
Do you get the same time delay when opening the report in Crystal? IN other words, is the delay only in the application or in Crystal?
If in Crystal, use Database, Show SQL Query to make sure the WHERE clause is passing the record selection criteria to the DBMS (in the WHERE clause).
If it doesn't, show us the record selection formula of the report.
hth,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question