Speed & Crystal Reports

[bobmorane]

Hello
I have reports integrated in VB6, with over 2000 formulas/running totals, and refreshing, takes a long, long, long time !
is there a way to speed up all that ???
I read the faqs, and found that i had to leave the "use indexes or server for speed" option checked... but i have the error "-2147192179 (8004728d) : error detected by the database DLL", and on crystaldecisions.com they advice to uncheck it, that's what i did.
I also read to use selection formulas to use only the records i need, but the database is managed by another application (Cimplicity) that allow to keep only a certain number of days (in my case) or entries in the db. And i need 38 days (around 55000 entries), because i have to display all 31 days for a month, with 7-days averages (i keep 1-2 more days as a security)

So... any hope that my reports will run faster or may i buy some books; so as i have something to do during that long, long, long time ??? ;-)
regards,
bob

 

[synapsevampire]

I agree, Ido, if you're building a summary subreport, you can do the same thing, only faster, using an SP or View.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com