Sdílet prostřednictvím

SQL Server Reporting Services 2012 SP2 CU3 Report Rendering Issues

  • Článek

I wanted to make you aware of an issue that we’ve seen on a few support cases this week.  In these cases, the PDF, Print Preview, and TIFF rendering formats are affected.  If you apply SQL Server 2012 SP2 CU3 or CU4, you may see a behavior where the first row of a tablix will have an extended row height and text within the tablix is clipped because the bottom row of the tablix does not expand its height.

          

One option is to uninstall CU3 and revert back to the build you were on before installing CU3.  If you prefer to keep CU3 installed, other workarounds are available.

  1. Export the report to a Word document and then print the report or save the Word document to PDF
  2. Follow these steps that have been tested and approved by the product team:
    1. Stop the Reporting Services service
    2. Find the Microsoft.ReportingServices.HPBProcessing.dll file located in the C:\Program Files\Microsoft SQL Server\MSRS11.<instance name>\Reporting Services\ReportServer\bin folder
    3. Rename the Microsoft.ReportingServices.HPBProcessing.dll file to Microsoft.ReportingServices.HPBProcessing_CU3.dll
    4. Copy the SQL Server 2012 SP2 CU2 version of Microsoft.ReportingServices.HPBProcessing.dll into the bin folder
    5. Start the Reporting Services service

We have a fix prepared that we plan to release in an upcoming cumulative update.

Matt Jones

SQL Server Tiger Team

Comments

  • Anonymous
    February 04, 2015
    Nice but there are more important rendering issues like with the Excel rendering: if you have 2 tablix on a report one above another then there will be a hidden column where the smaller (less wide) tablix ends.

  • Anonymous
    February 05, 2015
    Hello Janos, This is definitely a well known issue, here is a blog describing some workarounds for Excel rendering. blogs.msdn.com/.../659545.aspx Thanks, Matt

  • Anonymous
    February 17, 2015
    Where can you find the CU2 version of Microsoft.ReportingServices.HPBProcessing.dll ? I downloaded the SP2 CU2 hotfix, and extracted the executable. I do not see that DLL in any of the extracted files. Thanks

  • Anonymous
    February 19, 2015
    Hello Andy, The best process to acquire this DLL, is to install SP2, then apply CU2, and then retrieve the DLL from <SQL Server Root>Reporting ServicesReportServerbin directory. Thanks, Matt