Tuesday, August 7, 2018

SSRS Report - Workaround for resolving the color changes/column merging issue

Workaround for resolving the color changes/column merging issue in SSRS report:
1. Status color changes while exporting to excel
2. Column merging while accessing the report via sharepoint site.

There is a need to upgrade the SQL Server Reporting Service in envrionment.
We went through various blogs /MSDN forums and found that this seems to be an anomaly in the product which is fixed in SQL server 2012 Service Pack1 CU3.
Following are the blogs/forum links that brief about this issue:
https://support.microsoft.com/en-us/kb/2818780

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a11e0ca8-098b-4467-9325-5efeade6e8d7/ssrs-2012-conditional-formatting-color-issues-when-exporting-to-excel?forum=sqlreportingservices 

https://support.microsoft.com/en-us/kb/2812412
Microsoft Bug ID and KB Article:
VSFT Bug# 1200058
KB Article# 2818780
Description FIX: Incorrect background color returned if you export an SSRS 2012 report to Microsoft Excel
 So we need to install the SQL server patch to fix the issue in WCALQK8B server.
Following is the link to download the service pack and cumulative update:-
1. (http://hotfixv4.microsoft.com/SQL%20Server%202012/sp1/SQLServer2012_SP1_CU3_2812412_11_0_3349_/11.0.3349.0/free/460763_intl_i386_zip.exe)

2.       (http://hotfixv4.microsoft.com/SQL%20Server%202012/sp1/2012_SP1_PPExcel_CU3_2812412_11_0_3349_x/11.0.3349.0/free/460765_intl_i386_zip.exe)

1 comment:

  1. In this tutorial, we will learn How to use Scale Break features in your chart report. A scale break is a stripe drawn across the plotting area of a chart to denote a break in continuity between the high and low values on a value axis (usually the vertical, or y-axis). Use a scale break to display two distinct ranges in the same chart area.
    scale break to display two distinct ranges in the same chart area

    ReplyDelete