cancel
Showing results for 
Search instead for 
Did you mean: 

How to speed up a small report

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member188030
Active Contributor
0 Kudos

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

Answers (1)

Answers (1)

former_member183750
Active Contributor
0 Kudos

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