Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
garythomannCoGC
Impactful Individual
Impactful Individual

Report Builder pdf export treating headers as static

Issue with report running and looking fine in preview but when exported to PDF the shrunk header portions do not work anymore.

 

On the Page Header section have setup two sections; one for printing on the first page and another section for every page printing.

Initially had an enclosing container rectangle object for both of these sub-sections.  The blank space in the PDF output relates to the first page only objects area.  

 

For all objects within the container the properties are as follows:

<object>.Hidden =IIf(Globals!PageNumber <> 1, True, False)   or the other way round for the other sub-section.

<object>.CanShrink, .CanGrow  set to True.    Unfortunately these properties are not available with the Rectangle object.  Why?  Where can we vote for this feature?

Report.ConsumeContainerWhitespace is set to True

Are there other properties that need to be set for this to work maybe?

PageHeader.Height   property   Is this a fixed value?   I mean is this the issue that is fixed when exported to PDF as the Print Layout button toggled to ON shows.

 

This works in preview.   Please note that I have tested removing the Rectangle containers with the same pdf export result of blank space where the headers exist.

 

Have tried some of the relevant ideas from this post  How to get rid of blank pages in PDF exported from SSRS 

1 ACCEPTED SOLUTION
garythomannCoGC
Impactful Individual
Impactful Individual

9 REPLIES 9
garythomannCoGC
Impactful Individual
Impactful Individual

garythomannCoGC
Impactful Individual
Impactful Individual

Work around in the meantime is to have the page header 'repeat on every page except page 1' objects overlaid to the page header 'display only on first page' objects.  This saves vertical space and gets messy on the report layout side of things.

 

Note that either by design or is a bug; hidden objects whether in the veritcal or horizontal plane where more than one object exist can move the displayed objects around as hidden object space is reclaimed the Report Builder  layout engine.

 

In my report I now have the Layout Preview looking smick but in the normal preview looking a bit weird due to the overlaid objects.

garythomannCoGC
Impactful Individual
Impactful Individual

garythomannCoGC
Impactful Individual
Impactful Individual

+ compare 'test' report to the 'start from scratch' report
+ try removing objects from the 'start from scratch' report
- remove header objects = no
- remove matrix and insert simple table like that of the 'test' report = no

- add textbox to cover page header, section 1 area objects over vertical space, which only prints on first page

garythomannCoGC
Impactful Individual
Impactful Individual

Screenshots of reports in Print Layout mode.  The red box denotes the wasted space in question.

 

COP PDF export.scenario.works.rdl

garythomannCoGC_0-1648709569567.pnggarythomannCoGC_1-1648709642890.png

 

copy objects to blank report.rdl

garythomannCoGC_5-1648710629076.pnggarythomannCoGC_7-1648710901369.png

garythomannCoGC
Impactful Individual
Impactful Individual

Update to post and still not found answer to this yet.

+ create test report
- 2 header sections,  first section for page one display only, second section all pages display
- simple body object
> works, note did not use rectables as containers 
> rectangles cannot shrink, grow, tablix idea cannot be used and textbox do not have parent-child functionality so cannot act as containers

+ test cut down of report
- remove objects till working = fail

+ create new report copying objects 
- with no rectangle container objects use in header   = also fail

v-yetao1-msft
Community Support
Community Support

Hi , @garythomannCoGC 

You can refer your ideas to Ideas .

https://ideas.powerbi.com/ideas/ 

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors