Hi,

someone doing some reports for me using Reporting Services is getting some problems.

This is what he stated the problem as: "There is a ASP.NET service which eats up all of the memory until the report system crashes"

By removing as many of the views as possible and using tables directly, the report successfully ran (in a bit over two minutes, processing 300,000 records), however, when doubling the amount of data to be included, the report wouldn't run again.

Has anybody come across a similar problem and have any advice?

Thanks,