on 12-17-2013 4:44 PM
I've got a report that I'm running from an Oracle database using .NET 2010 and the associated Crystal drivers. The report SQL returns in a fraction of a second in TOAD. When I run the report from the web interface it takes two to three minutes for a nine page report to build the display and another three minutes after I click the Print icon before the printer dialog is displayed. The report has two subreports that return about 6 record each and only appear on the first page. I turned on NoPrint in all the reports. What else can I do. My customer is, to say the least, not very happy.
I should mention that I can run the report in the old VB6 environment and it takes about 20 seconds to build the display and a fraction of second to print.
tia
Chris
Hi Chris,
Check out below doc.
http://scn.sap.com/docs/DOC-21984
Try using http sessions to store an reuse report object.
Ideally it takes a little bit longer to load the report first time as the app loads CR assemblies, DB drivers etc however subsequent loads are faster.
Also, if you have any subreports indetails section, move them to header or footer.
Thanks,
Bhushan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Make sure you're on SP 7 or SP 8.
What version of Oracle?
How are you connecting (ODBC, OLE DB, etc.)?
How long does it take for CR to process the report in the CR designer?
Can you attach the report (no saved data needed).
- Ludek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.