I started to develop a pdf rendering problem when switching to my new Dell
830 notebook. The same matrix type report now have text running over cell
boundary lines - it never happened before. I even tried to change the
resolution back to 1024x768 - using 1920x1200 now - it didnt have any affect.
I use Adobe 8 and SQL Reporting Services as part of the SQL 2005 Express
edition, Windows XP Professional SP2.On Jul 24, 6:34 am, Dawie <Da...@.discussions.microsoft.com> wrote:
> I started to develop a pdf rendering problem when switching to my new Dell
> 830 notebook. The same matrix type report now have text running over cell
> boundary lines - it never happened before. I even tried to change the
> resolution back to 1024x768 - using 1920x1200 now - it didnt have any affect.
> I use Adobe 8 and SQL Reporting Services as part of the SQL 2005 Express
> edition, Windows XP Professional SP2.
If you are not using the SP2 version of SQL Server 2005 Express
Edition w/Advanced Services, this might help. Also, if there are
updates available for Adobe Reader, you might want to look into those.
Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
Showing posts with label matrix. Show all posts
Showing posts with label matrix. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
PDF Export Very SLOW ! MS Rerporting Services TEAM Where Are you ??
Hi,
I have a matrix report that produce 79 pages on the HTML browser in 30
seconds, but
if I try to export the report in a PDF format it take more than 1 our !!!
The system configuration is:
IBM Server with 2 Pentium Xeon of 2.4 Ghz
1 Gb of RAM
Fast network HD
Windows 2003 Server SP1 (SBS)
SQL Server 2000 SP4
Rerpoting Services SP2
Do you have any idea about this problem ?
I've saw there are some old messages about this problem on this newsgroup,
but nobody of the
Microsoft Rerpoting Service Team has reply !!!
I think this is a very important issue, that can KILL the reportin services
system on a
Serious Real World company application.
Thanks.
Cesar Augusto Flavio De Min.
MCSDEven 30 seconds for HTML is very slow. PDF definitely is much much slower.
Everything is done in RAM. 1 GB of RAM is pretty minimal. Is your data on
this server as well or just RS? Can you add more RAM to it. Perhaps bring it
up to 2 Gig. Also, an 80 page report while not huge is most likely taking
time due to complexity. You could try splitting it up into multiple reports.
I don't know if RS 2005 has improved performance of PDF rendering or not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Cesar Augusto Flavio De Min" <cdemin_news@.yahoo.com> wrote in message
news:emEEYAO7FHA.2012@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a matrix report that produce 79 pages on the HTML browser in 30
> seconds, but
> if I try to export the report in a PDF format it take more than 1 our !!!
> The system configuration is:
> IBM Server with 2 Pentium Xeon of 2.4 Ghz
> 1 Gb of RAM
> Fast network HD
> Windows 2003 Server SP1 (SBS)
> SQL Server 2000 SP4
> Rerpoting Services SP2
> Do you have any idea about this problem ?
> I've saw there are some old messages about this problem on this newsgroup,
> but nobody of the
> Microsoft Rerpoting Service Team has reply !!!
> I think this is a very important issue, that can KILL the reportin
> services system on a
> Serious Real World company application.
> Thanks.
> Cesar Augusto Flavio De Min.
> MCSD
>
I have a matrix report that produce 79 pages on the HTML browser in 30
seconds, but
if I try to export the report in a PDF format it take more than 1 our !!!
The system configuration is:
IBM Server with 2 Pentium Xeon of 2.4 Ghz
1 Gb of RAM
Fast network HD
Windows 2003 Server SP1 (SBS)
SQL Server 2000 SP4
Rerpoting Services SP2
Do you have any idea about this problem ?
I've saw there are some old messages about this problem on this newsgroup,
but nobody of the
Microsoft Rerpoting Service Team has reply !!!
I think this is a very important issue, that can KILL the reportin services
system on a
Serious Real World company application.
Thanks.
Cesar Augusto Flavio De Min.
MCSDEven 30 seconds for HTML is very slow. PDF definitely is much much slower.
Everything is done in RAM. 1 GB of RAM is pretty minimal. Is your data on
this server as well or just RS? Can you add more RAM to it. Perhaps bring it
up to 2 Gig. Also, an 80 page report while not huge is most likely taking
time due to complexity. You could try splitting it up into multiple reports.
I don't know if RS 2005 has improved performance of PDF rendering or not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Cesar Augusto Flavio De Min" <cdemin_news@.yahoo.com> wrote in message
news:emEEYAO7FHA.2012@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a matrix report that produce 79 pages on the HTML browser in 30
> seconds, but
> if I try to export the report in a PDF format it take more than 1 our !!!
> The system configuration is:
> IBM Server with 2 Pentium Xeon of 2.4 Ghz
> 1 Gb of RAM
> Fast network HD
> Windows 2003 Server SP1 (SBS)
> SQL Server 2000 SP4
> Rerpoting Services SP2
> Do you have any idea about this problem ?
> I've saw there are some old messages about this problem on this newsgroup,
> but nobody of the
> Microsoft Rerpoting Service Team has reply !!!
> I think this is a very important issue, that can KILL the reportin
> services system on a
> Serious Real World company application.
> Thanks.
> Cesar Augusto Flavio De Min.
> MCSD
>
PDF Export For Matrix And Chart
I have a very simple report with a matrix and a subreport chart.
2 rows in a table object, Row 1 has Matrix, Row 2 has Chart.
When I export to PDF, the Page always breaks before I get the chart.
If I put the chart in Row 1 and the Matrix in Row 2, no problem with
page break.
Any ideas?
I've posted quite a few times re: the PDF exporting of Reporting
Services, I see this as the major weakness of the product. Does MS
have any plans to correct the PDF engine so it robust enought?
Thanks.
Tim Heuer
heuert@.comcast.netI have run into similar sounding problems and have had little response. It
appears there are a number of known issues with PDF and Excel for that
matter, but I havent heard if and when they are going to address them.
"teem60004" wrote:
> I have a very simple report with a matrix and a subreport chart.
> 2 rows in a table object, Row 1 has Matrix, Row 2 has Chart.
> When I export to PDF, the Page always breaks before I get the chart.
> If I put the chart in Row 1 and the Matrix in Row 2, no problem with
> page break.
> Any ideas?
> I've posted quite a few times re: the PDF exporting of Reporting
> Services, I see this as the major weakness of the product. Does MS
> have any plans to correct the PDF engine so it robust enought?
> Thanks.
> Tim Heuer
> heuert@.comcast.net
>
2 rows in a table object, Row 1 has Matrix, Row 2 has Chart.
When I export to PDF, the Page always breaks before I get the chart.
If I put the chart in Row 1 and the Matrix in Row 2, no problem with
page break.
Any ideas?
I've posted quite a few times re: the PDF exporting of Reporting
Services, I see this as the major weakness of the product. Does MS
have any plans to correct the PDF engine so it robust enought?
Thanks.
Tim Heuer
heuert@.comcast.netI have run into similar sounding problems and have had little response. It
appears there are a number of known issues with PDF and Excel for that
matter, but I havent heard if and when they are going to address them.
"teem60004" wrote:
> I have a very simple report with a matrix and a subreport chart.
> 2 rows in a table object, Row 1 has Matrix, Row 2 has Chart.
> When I export to PDF, the Page always breaks before I get the chart.
> If I put the chart in Row 1 and the Matrix in Row 2, no problem with
> page break.
> Any ideas?
> I've posted quite a few times re: the PDF exporting of Reporting
> Services, I see this as the major weakness of the product. Does MS
> have any plans to correct the PDF engine so it robust enought?
> Thanks.
> Tim Heuer
> heuert@.comcast.net
>
Monday, February 20, 2012
Passing subreport matrix values to the main report
Hello everybody,
I'm trying to pass the values of a subreport matrix to my main report.
For example, I have a matrix subreport like this:
USA CANADA FRANCE GERMANY
Client1Sales $100 $200
Client2Sales $600 $50 $300
What I would like to do is to pass the USA Sales Amount of Client1 (e.g $100) to my main report.
Is there any way to do this?
Thanks in advance for your answers!
Zoz
Does anyone have an idea on this topic? I hope I am not the only one who needs this...
|||Sorry to ask again, but I really need to find a work arouround for this. Does anyone see a solution?
Thanks in advance.
Subscribe to:
Posts (Atom)