Printing very slow from java viewer - BOE XI 1

[eyeswideclosed]

This happened with CE 10 too, on a multi-page report it will print about 1 page per minute instead of all at once, it's like it doesn't send all the pages to the printer all at once, just one at a time, pretty annoying.

 

[Turkbear]

Hi,
Try this:
When viewing the report, go to the last page then print..

May help...





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[eyeswideclosed]

Wow that was quick, thanks!

 

[Turkbear]

Hi,
No problem..glad to help.
The way I underestand it ( and that is open to question )the viewers are essentially page-on-demand , so by going to the last page, you force it to retrieve all the data from the database before having it sent to the printer - this is faster, obviously, since database access is the slowest part of report activity.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Another trick is to place the totalpagecount on the first page, this forces Crystal to run the entire report to determine how many pages there are.

So a formula of:

"Page: " & totext(pagenumber,0,"") &" of " & totext(totalpagecount ,0,"")

in the page footer should net the same results, only you won't need to go to the last page PRIOR to printing.

-k

 

[eyeswideclosed]

CR XI is noticeably slower than CR 10 too, we've seen, especially pulling back large recordsets, this is not good.

 

[synapsevampire]

I haven't seen this behavior, it may be that you need to change how you're retrieving the data, connectivity or otherwise.

Saying it's slow without posting the database/connectivity, your means for retrieving data (Add Command? Crystal database Expert? View on the database? What's in Database->Show SQL Query, and what's in Report->Selection Formula(s)?) won't help anyone determine your problem, you need to take the time to describe what you're doing.

-k

 

[eyeswideclosed]

I just tested it, I ran a CR 10 sp3 report and then the exact same report written in XI sp1, same connection method, CR 10 is about twice as fast pulling the records, 800k records on this one. oh well.

 

[eyeswideclosed]

odbc

 

[Turkbear]

Hi,
Check the Sql ( Database..Show Sql) generated by each version..Look for any differences, especially in the Where clauses..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

...

ODBC isn't a database, it's a form of connectivity.

If your appraoch to resolving this problem emulates your approach to describing your environment, I think that you'll have difficulty.

Again, post your DATABASE TYPE.

As Turk suggests, check the Database->Show SQL Query to determine that the same SQL is being passed, and make sure that the Perform Grouping on Server and the Use Indexes or Server for Speed settings are the same in each version.

I haven't seen a degradation in performance here, but I use Oracle native connectivity.

-k