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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is Crystal calling to subreports asynchronously?

Status
Not open for further replies.

olitvinov

Programmer
Oct 21, 2004
47
CA
I wonder how Crystal calls subreports and if it’s multithreaded(or makes DB calls simultaneously).
I’m using Crystal XI. There is a main report with 6 subreports in it.
My concern is the speed of processing(how slow it is).
Each subreport would be pulled by Crystal by its own stored procedure based on a parameter.
So the question is if crystal makes multithreaded calls to all subreports or it makes sequential calls?
And if it’s sequential, can I configure it to be multithreaded to perform multiple simultaneous calls to DB?

I would appreciate any input or suggestion or best practices.
Thanks,
Oleg
 
Why can't you have a single stored procedure for all of the data? Much more efficient, since it does the SQL operations just once for the report, and with the server doing most of the work.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top