Tabular report in pdf - issue with page breaks

[bsharma_velcro]

Hi,

I am trying to create a tabular report with output in pdf. I have created a excel template with raw data as straight table, and using excel's pivot table feature to create pivot tables out of the straight tables. The issue is no matter how much I try to fix the print area, page breaks, etc. in the template, the columns of the table are not coming in one sheet in the output.

1. How can we make sure the page breaks appear in the output same as they appear in the template while using Pivot table in Tabular report.
2. How can we dynamically ensure that the print area is expanded/collapsed as per the data in the pivot table (I tried with dynamic named range in excel pivot, that's not working)

Regards,

Bhaskar S.

[David_Friend]

@bsharma_velcro you may need to do this in Pixel Perfect to get that level of control, is that possible or do you need Excel for the pivot table?

[bsharma_velcro]

I need it in excel... Need to be able to share the report both in excel and in pdf formats.

[bsharma_velcro · Accepted solution]

@David_Friend - The issue is resolved. There's a setting in PivotTable options, which autofits the column width every time data is updated. As a result the bagebreak you apply goes for a toss after the report is refreshed as the columns would have readjusted themselves.

The solution is to uncheck this option.   

Regards,

Bhaskar S.