Crystal Report

[vishalakshi]

We have been working on Crystal reports for quite a few months and only the recently done reports are opening faster but older ones have become very slow to work with. We tried in all methods like Re-installing Crystal-Reports etc., Actually we changed the SQL-server in-between. We are using DSN and have changed the server name in DSN also.:confused: :confused:

[sramprasath]

1. Chech the table links in the Visual linking expert.
2. Try with "Convert Database Driver" option in the Database menu. Select the appropriate driver. we are using ODBC. It's very good for us.

[vishalakshi]

We checked the table links.We are also using ODBC .
We used Convert database driver also.
But the same thing.
our new reports are working faster.
but old ones are very...very slow.

So if u have any other solution for this then please let us know.

[sramprasath]

I hope you are telling crystal report execution is slow, not the calling of crystal report from VB.

In reports "Show SQL Query" , check the joins.
You can use "Full outer"join instead of "inner" join. Before changing the joins, please make sure that it won't affect the result set.