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.
>
Showing posts with label functionality. Show all posts
Showing posts with label functionality. Show all posts
Wednesday, March 7, 2012
Saturday, February 25, 2012
RS enhancements planned for VS 2005?
I just downloaded SQL Server 2005 Beta 2 and looked over the RS
functionality. Though the report designer is available from the Business
Intelligence Development Studio rather than VS.Net, I can't find any
significant enhancements in this rev of RS over the SQL 2000 SP 1 (i.e.
support for rich text in text boxes, XML data source support, custom control
support, improved wizards, etc.).
Is this correct? Are there enhancements to RS planned before final release?
When will the RS release plan for SQL 2005 be announced? Will Beta 3 be
feature-complete?
Thanks.
Jeff DavisRS in SQL 2005 Beta 2 is primarily a port of RS2K SP1.
All new reporting services feature work is being done in a separate code
branch and will be merged in for Beta 3.
If you have additional questions and comments on SQL 2005 Beta 2, your best
source of information is the beta newsgroups rather than here.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Jeff Davis" <jeff.davis@.tamtron.nospam.com.invalid> wrote in message
news:u52Q5PMdEHA.1040@.TK2MSFTNGP10.phx.gbl...
> I just downloaded SQL Server 2005 Beta 2 and looked over the RS
> functionality. Though the report designer is available from the Business
> Intelligence Development Studio rather than VS.Net, I can't find any
> significant enhancements in this rev of RS over the SQL 2000 SP 1 (i.e.
> support for rich text in text boxes, XML data source support, custom
control
> support, improved wizards, etc.).
> Is this correct? Are there enhancements to RS planned before final
release?
> When will the RS release plan for SQL 2005 be announced? Will Beta 3 be
> feature-complete?
> Thanks.
>
> Jeff Davis
>
functionality. Though the report designer is available from the Business
Intelligence Development Studio rather than VS.Net, I can't find any
significant enhancements in this rev of RS over the SQL 2000 SP 1 (i.e.
support for rich text in text boxes, XML data source support, custom control
support, improved wizards, etc.).
Is this correct? Are there enhancements to RS planned before final release?
When will the RS release plan for SQL 2005 be announced? Will Beta 3 be
feature-complete?
Thanks.
Jeff DavisRS in SQL 2005 Beta 2 is primarily a port of RS2K SP1.
All new reporting services feature work is being done in a separate code
branch and will be merged in for Beta 3.
If you have additional questions and comments on SQL 2005 Beta 2, your best
source of information is the beta newsgroups rather than here.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Jeff Davis" <jeff.davis@.tamtron.nospam.com.invalid> wrote in message
news:u52Q5PMdEHA.1040@.TK2MSFTNGP10.phx.gbl...
> I just downloaded SQL Server 2005 Beta 2 and looked over the RS
> functionality. Though the report designer is available from the Business
> Intelligence Development Studio rather than VS.Net, I can't find any
> significant enhancements in this rev of RS over the SQL 2000 SP 1 (i.e.
> support for rich text in text boxes, XML data source support, custom
control
> support, improved wizards, etc.).
> Is this correct? Are there enhancements to RS planned before final
release?
> When will the RS release plan for SQL 2005 be announced? Will Beta 3 be
> feature-complete?
> Thanks.
>
> Jeff Davis
>
Labels:
available,
beta,
business,
database,
designer,
downloaded,
enhancements,
functionality,
intelligence,
microsoft,
mysql,
oracle,
planned,
report,
server,
sql
Subscribe to:
Posts (Atom)