After installing SQL Server 2005 SP2 all of our server reports are being rendered with a black background and white text, which needless to say is reversed of how they were being drawn before installing SP2. This only happens when the report viewer is displaying the report in “Print Layout” mode. Normal mode shows the report as expected.
Has anyone else had this problem or suggest a solution? Thanks in advance.
It turned out that this is an issue introduced with SP2 that affects certain video cards. I am also experiencing the same problem but t never occurred to me that this could be actually a bug during the SP2 testing so I never reported it back
. The RS team is reviewing currently this issue. Please contact product support and request a hotfix when available.|||user hotfix :
Replace the "Microsoft.ReportingServices.ImageRendering.dll" from SP2 with "Microsoft.ReportingServices.ImageRendering.dll" from SP1.
The directory is "x:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\bin"
Thanks for the feedback on this Michael. I thought this might work but afer replacing the ImageRendering.dll I get the following error:
"An attempt has been made to use a rendering extension that is not registered for this report server."
Did you get a similar result when you replaced this DLL with the original from SP1?
|||I am having the same problem: Reports in Print Layout are rendered in a black background
|||As a workaround, you should be able to fix this issue by changing the background color to White instead of Transparent.|||Yes, this work.
Tanks
|||Hi,Does anyone know if there's a list yet of cards that have not been affected?
Cheers,
Martin
|||
I haven't heard of a resolution that is acceptable yet, with the exception of geting back through all the server reports and deliberatly making the background color white. I'm not too convinced this is nessesarily a video card issue, since every single machine we have seen this on is doing the back background.
Does anyone know if some sort of hotfix has been made available? Just copying in the old DLL from SP1 dosen't work.
|||Hello,
This issue was indeed introduced in Yukon SP2. It only affects Report Designer preview, it doesn't matter what video card you have, the workaround is to specify background = white in the RDL, and we're working on a QFE.
Regards.
Mike
|||I am also having the problem ;(
I was a beta tester for SP2, how did we let this slip through? I guess I don't normally use the print preview mode in the report viewer, but apparently my users do!
|||By the way, I have tried making the background white on these reports but there is still a lot of ugly black showing thorugh. I only see options to make the body, header, and footer white. Is there some other background property that I'm missing that would make the entire background of the report white including the margins?|||It didn't resolve the issue for me either. I am also getting blank pages on reports that worked fine before.|||Is there any timeframe for the hotfix on this? There seems to be nothing that we can do to eliminate the black in the margins of the reports and cannot roll back to SP1 in any way. Seems like the only open we have is to completely remove SQL Server and reinstall with SP1.|||I've contacted Microsoft Support about this and they said they couldn't offer a hotfix until there was a KB article number to go by. Is there any work being done to get this fixed? Our clients have been suffering with this problem for weeks now and the response from Microsoft has been mute. Any information would help.
No comments:
Post a Comment