Custom format of dynamically generated pivot table in NPrinting is not uniform for all the elements

Aaryan — Tue, 09 Nov 2021 12:04:51 GMT

Description

In Pivot Table ,Custom format of Pivot Table in excel report is not applied uniformly to all the elements.

Select the fields in rows and values in a pivot table. Drag the dimensions in the columns and rows and measures .Click on the pivot table , go to Design ,Create a custom format for the report. Click on Total and select a color for the text and background .

In the preview, Total are not of Blue for all rows. (check image below )

Environment

NPrinting Designer(All Version)

Resolution

The problem is due to some conflict between the custom style applied to the pivot table and the formats applied to the cells.
To solve the issue ,modify the custom style by adding the borders to the cells, apply it with the "Apply and Clean Formatting" option (see below image) .

Internal Investigation ID

QB-6492

article Custom format of dynamically generated pivot table in NPrinting is not uniform for all the elements in Official Support Articles

Custom format of dynamically generated pivot table in NPrinting is not uniform for all the elements

Description

Environment

Resolution

Internal Investigation ID