Summary:
This article troubleshoots an issue that occurs when viewing merged cells with nested expansions in the Portal due to rendering limitations.
Symptoms:
When a user designs a report in Excel with nested expansion and has merged cells in order to align text to the center uploads the report to Portal, the report will not render correctly. The rendered report will not center the text in the merged cells correctly. This particular scenario applied to a Portal 4.6.50203 version.
As seen in Excel:
As seen in the Portal:
Causes:
This is because in Portal, we use an Excel rendering service, not Excel itself to render the reports. This service does not take into account nested expansions and merged cells, resulting in the issue with Portal.
Resolution:
One workaround is to not use merged cells, but instead use the Center Across Selection option in Format Cells. This will center the text across the selected cells while keeping the cells unmerged.
As now seen in Portal:
Properties:
Reporting Web Portal 4x