I am using Crystal Reports .NET 2005 to generate a report in a databse software. The thing is that one of my reports respond very slow.  understand the issue but is this much of slowness normal????

I suggest grabbing a book on CR that discusses SQL optimization. There are so many factors that could affect this. But one thing that jumps out at me is to ask how many rows are in our final report? You have so many tables and it looks like there might be a many to many relationship. If so, this can create a cartesian product on the report side and the report will have tons of data to churn through as it builds the report. If so, the is putting quite a load on your reporting control. I would look at typical optimization factors about using a SQL command so that the join is done on the server and CR only gets the final resultset. Also check out if you have any selection filters or grouping which could be optimized by using SQL Expressions or passing more work to the server.

Thanks for the update. I've never encountered SQL running a view in chunks like that. Maybe your server is multi-processing your request with others and sharing the process time across queries? I don't know. But very interesting behavior.

Re the report, sounds like you probably have things optimized. It's just a damn big report! However, there is still the possibility that you are showing the total number of pages at the bottom of each page and this slows down the display of the first page b/c it has to internally create the entire report beforehand. Get rid of 'Page N of M' and the first page will load up much faster. There are various other optimization techniques, but without knowing your report design there is no telling which ones apply to you. Hmmm... Do you have any formulas that can be calculated using SQL Expressions? That would help. Also, are you concatenating fields within a text object? It's faster to do that with a formula. And using the Count summary function slows things down too. But either way, you just have a really big report and it takes time to process.

Let us know if you make any other optimization techniques help things out.

Another thing that will slow down a report is using a formula as a group, a sort, or a selection criteria.  Crystal doesn't pass those along to the server, it will bring ALL of the records to the workstation where the report is being processed and then churn through them there to complete the report.