The issue is probably the view itself. A view is a SQL statement that can be used like a table. The database runs the SQL in the view at the time of the refresh. Generally, views are not indexed so when you link to them from a table, there is no index available to speed up the processing. I would look at a couple of things:
1. Make sure that the SQL in the view is optimized so that it runs fast.
2. If that doesn't work, think about creating a view or command that includes the tables that your using in your report - so you have a single SQL statement that uses all tables and doesn't connect to the view.
Also, make sure that you have the following options turned on for your report:
Use indexes or server for speed
Perform Grouping on server
These setting will push the processing to the database server which is usually much faster than having Crystal download all of the data and to the processing in memory.
-Dell
IP Logged
