Solved

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

Posted on 2008-10-17
7
547 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…

738 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