Data Don't populate immediately

[fanghua]

i am runing a report of 3000 pages, after i see all the records show up, i notice that the fourth page, which require some calculation and formular field, don't show up properly, i had to refresh the page to see the result. is there any way i can see the results immediately or i just have to wait? thanks

 

[hilfy]

You'll have to wait.

Some easy things that you can do to speed up the reports:

- Avoid subreports
- Don't use "Page N of M" in long reports (all the pages have to be rendered so that this can populate correctly).


-D

 

[synapsevampire]

Speed is based on many factors, technical in nature, which you've shared nothing about.

Crystal version
Database and connectivity used

Another reason why reports will be slow is based on having Crystal performing calculations and filtering rather than letting the database do the work.

Whatever is in the report->Edit Selection Formula->Reord (or Group) should be reflected in the Database->Show SQL Query

If you want help with improving performance, try posting something about the environment, in addition to the aforementioned, add in any complex formulas.

For the best results, rather than asking people to fix some nebulous problem, show example data and what your intended output is, that way they can analyze how to best implement, rather than guessing at what "don't show up properly" might mean.

-k