Solved

Reporting service 2005, Report footer contains all unreadable (jumbled) text when exported to pdf.

Posted on 2008-10-17
7
535 Views
Last Modified: 2012-05-05
Hi all,

Hope anyone can help. please!....

We have some probelms regarding the report footer in the report that gerenated by reporting service 2005. Some of our customer have exported their reports to pdf. when they opened the pdf file and the report footer text contains all unreadable (jumbled) characters. If they opened it again, the jumbled text will changed slightly. When they open it again and again, the footer will eventurally 'corrected itself'. It started with the first page footer first, then the other pages' footers when open the file again.

They first have the problem when they have adobe reader version 7 installed. We have told them to install the version 9 but the problem is till happening.

Please help.  Thanks...

Update ...........................

After a further investigation, this problem occurred after we applied some windows updates to our live server.
one of this is
Hotfix 3282 for SQL Server Reporting Services 2005 ENU (KB953752)

We have a similar test server with the same reporting services hotfix 3282 applied.

The PDF file generated after the hotfix installed can be viewed Ok in adobe reader version 9, but not with some other pdf file viewers. (e.g pdf complete) The text in header and footer becomes unreadable.

If we un-installed the hotfix. The PDF file generated can now be viewed by adobe reader version 9 and other pdf file viewers.

????

0
Comment
Question by:porsonw
  • 4
  • 3
7 Comments
 
LVL 51

Expert Comment

by:Mark Wills
ID: 22746451
I would be inclined to get on to Microsoft immediately...  because before installing 3282 it is broken, then installing 3282 helps a bit, then uninstalling fixes... Kind of implicates 3282 pretty much - and there is a fair bit of reporting resource libraries included.

CU9 has a TON of stuff in it, so will be difficult to ascertain. It could be something as simple as unicode laguage content being misinterpreted by the font substitution algorithms in PDF, or, something more diabolical.

Would be worth  having a look at what is left on disk and see if any match those date/times and size of the CU9 release - that will be the culprit...

0
 

Author Comment

by:porsonw
ID: 22756461
Hi mark_wills,

thanks for the reply.
I have tried to replaced the Microsoft.ReportingServices.ImageRendering.dll file - version 9.0.3282 (which installed by the hotfix) with the previous version version 9.0.3042.
The exported PDF file then works fine with other pdf viewers. This seems to be the file that caused the problem and we are thinking to replace this dll alone to correct the problem on or live server temperary but not sure whether there is any side effects.

Regarding open an support issue on Microsoft, it cost £199 + VAT for reporting an bug.......

0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 22756922
What ? That is a bit bizzare - they don't normally charge for bonafide bugs... Especially when it can be so accurately described...

If it were me, I would be inclined to replace it, or roll back that CU9 (depending on why you have installed it) and wait for the SP to arrive. Would be inclined to go to the SSRS team blog http://blogs.msdn.com/sqlrsteamblog/ submit the specifics of your problem and the fix and ask them if there is a risk of reverting to Microsoft.ReportingServices.ImageRendering.dll in isolation - they take a bit more pride than just a "support" call.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:porsonw
ID: 22758910
I just come across this

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=4023042&SiteID=17&mode=1

This seems very interesting.......
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 22759566
Very - If you are not PSYW (first and last initial seem to match) then, I would be inclined to also post your proposed fix on that thread immediately, or open a new thread, and see if it will cause any problems...  Meaning, instead of uninstalling CU9, what about reverting to Microsoft.ReportingServices.ImageRendering.dll in isolation (and maybe making it read-only to avoid accidental overrides until it is fixed) what problems will that cause.

Told ya that the SSRS Team Blog took more pride in their work...
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 250 total points
ID: 22759599
Now, if they could also apply that pride to get it right for every version, for every instance, for every combination, then it would be rather excellent.
0
 

Author Closing Comment

by:porsonw
ID: 31507084
Thank you for Mark_Wills, seems to be a solution can be find in this link.
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=4022195&SiteID=1&mode=1
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now