solution to improve the speed while generating report

[143Aroul]

I have written an application in VB6/MS-Access/Crystal Report 8.5
is a multiuser one. one server 6 client machine using
the application. The server is HP Server, server 2003 installed
all the other client machine using win-2000 and all are very near,
properly networked.


now the size of the database is 100MB, the problem starts
(in the sense, it takes verylong time) when generating report

any solution for improving the speed of generating report.
i am using crystal report control, and tried for using crystal viewer
still it is slow.

 

[synapsevampire]

When you say the problem "starts when generating report", do you mean when runing the report, or when developing the report?

The biggest problem developers experience is in not knowing how to determine if they have constructed the report properly, hence they don't know how to optimize.

The biggest factor for you is that you have a lot of data in a non-mission critical database, and depending upon the connectivity used (Native, ODBC?), you may be doing much of the processing within Crystal, which is a bad idea.

You didn't mention if you're leveraging Access Queries to distill the data down to match the report requirements, but that should be the intent.

If you turn on the Options->Views so that you can see the Access Queries, you can select an Accesss Query and get Access to do the work rather than Crystal, which will be slow.

As your database grows, you will suffer more and more as Access does not scale well.

Consider upsizing to a real SQL database, you're overdue now...

-k