RS Matrix Rendering Performance - help required

Dear All,
I am currently trialling MS Reporting Services and have so far been highly
impressed with the flexibility and functionality of the software. It
certainly out classes all of the other reporting solutions I have seen. That
is with one exception! I have so far designed several matrix based reports,
all of which render to the screen in <5 seconds and look superb. The
problems start to occur when I try and render the reports to PDF.
As an example, I have one matrix based report with 4 column header fields
and 8 row header fields producing a report of approx 150 pages. When I view
the report as HTML it takes approx 5s to run. If I then attempt to render it
as a PDF, the server CPU usage hits 100% (aspnet_wp.exe) and after several
hours is still attempting to render the report. If take exactly the same
report and remove 4 of the row header fields (doesn't shorten the report as
fields I remove are uniquely defined by a reference which remains) the report
now renders as a PDF in approx 20s !!?
I think this a superb product but desperately require a solution to this
problem. Most of our reporting is high level management reporting, to which
matrix based reports naturally lend themselves. Being restriced to 3-4 row
header fields is quite unworkable for our reporting needs, but I'd be loathed
to have to resort to another solution (e.g. crystal)
Any help would be much appreciated.Just to follow up on the previous posting, we are running MS Reporting
Services SP1 on a 2.4Ghz Single Processor machine with 1Gb Ram
"AndyC" wrote:
> Dear All,
> I am currently trialling MS Reporting Services and have so far been highly
> impressed with the flexibility and functionality of the software. It
> certainly out classes all of the other reporting solutions I have seen. That
> is with one exception! I have so far designed several matrix based reports,
> all of which render to the screen in <5 seconds and look superb. The
> problems start to occur when I try and render the reports to PDF.
> As an example, I have one matrix based report with 4 column header fields
> and 8 row header fields producing a report of approx 150 pages. When I view
> the report as HTML it takes approx 5s to run. If I then attempt to render it
> as a PDF, the server CPU usage hits 100% (aspnet_wp.exe) and after several
> hours is still attempting to render the report. If take exactly the same
> report and remove 4 of the row header fields (doesn't shorten the report as
> fields I remove are uniquely defined by a reference which remains) the report
> now renders as a PDF in approx 20s !!?
> I think this a superb product but desperately require a solution to this
> problem. Most of our reporting is high level management reporting, to which
> matrix based reports naturally lend themselves. Being restriced to 3-4 row
> header fields is quite unworkable for our reporting needs, but I'd be loathed
> to have to resort to another solution (e.g. crystal)
> Any help would be much appreciated.
>