Erratic formating in an Nprinting Pivot Table

[julioarriaga]

Hi,

Whenever I assign black borders to a table, the format looks good on the Designer (a), but in the preview (b) looks awful.

Is there a way to solve this?

Thanks as always.

a) Black borders format in Designer

B) Preview with the erratic format applied

[Lech_Miszkiewicz · Accepted solution]

I am not an expert, but in my opinion "hard-formatting" of pivot tables will not work (regardles if it is in NPrinting or just in excel with dynamic query pulling and refreshing data)

My approach to do this would be to create a table style which would be applied to whole table:

1. Design-->Expand dropdown and choose "New PivotTable Style..."
2. It opens "New PivotTable Style..."
3. Choose which element of Pivot Table you wish to format
4.  Apply reqired format

That way you are creating style which will be applied to Pivot table object and not to cell range which in pivot table is dynamic and will always change

cheers