Skip to main content

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

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Aaryan
Former Employee
Former Employee

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

Last Update:

Nov 9, 2021 7:04:51 AM

Updated By:

Aaryan

Created date:

Nov 9, 2021 6:59:02 AM

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 )

Aaryan_0-1636458105925.png

 

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) .

Aaryan_1-1636458594691.png

 

Internal Investigation ID

QB-6492

Contributors
Version history
Last update:
‎2021-11-09 07:04 AM
Updated by: