Showing posts with label matrix. Show all posts
Showing posts with label matrix. Show all posts

Wednesday, March 28, 2012

PDF Rendering Problem

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

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
>

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
>

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.