Web Development

Ask something
Discussion Locked

VB6 and crystal report

0 helpful
6 replies

by whyong 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

when i develop a vb6 program, it's running well but when i generate the .EXE file, it become very Slow, anyone could advise??

And when i print a crystal report 8 from my program, it took more than 30 seconds to come out, (i am using the Access 97database), anyone have better suggestions if i want my report to come out less than 10 seconds.

6 replies

by fofa

When you create the .EXE, what are you running on compared to the development machine. Is one local and the other over the LAN?

THe best way to improve Crystal Reports is to make sure the query is optimized. Usually it is better to put the SQL in and not use Crystals selectivity. An other option is to use Crystal SQL generator and use then use the Crystal Query as the base for the report. However I have not used version 8 so I don't know if that has changed.

by spankil

Hi,
Crystal Report 8 is very Faster than the Previous version 7 according to me as far as I have used it.
To optimize the O/P So that it works faster is that u can create a Query in your Access DB and use Only one Table in the Crystal Report. if not possible than Uncheck 'Perform Grouping on Server' in the File/Report Option.
Hope this may work.

Regards
Pankil.

This discussion is closed to new replies.