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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
garythomannCoGC
Impactful Individual
Impactful Individual

Paginated Report Builder - rendered layout objects staying together

Have a power bi paginated report builder report that I created that is formatting causing 'blank page'.

I understand that the 'blank page' is caused by the layout objects staying together, RB throws the group of layout objects to the next page.

Going through the process of detirmining control and playing around with layout properties.  ie turning off the usual suspects and checking the effect

 

Screenshot of the layout

garythomannCoGC_0-1687933440071.png

 

Screenshots of the running report

page 2

 

garythomannCoGC_1-1687933528781.png

page 3

garythomannCoGC_2-1687933551452.png

page 4

garythomannCoGC_3-1687933612632.png

 

Resolution approach

>  turn property off till we notice an effect :}

>>  RB needs a layout explorer  (see usefull links sections)

+  keeptogether

-   turn everything off = no effect!

+  repeatwith

-   turn everything off = no effect!

+  ‘header’

-   fixedcolumnheader  fixedrowheader, repeatcolumnheader  repeatrowheader

+  pagebreak

-   disable

+  de-construction testing

-   remove layout objects from the bottom up

+  the main tablix is using a rectangle object as a container

-   the rectangle container is needed for Council Plan section which is made up of separate text objects to group them together

-   try splitting this out from one large rectangle container to smaller containers for each section

-   deleting the default created textbox within the cell and inserting a rectangle maxs out to the matrix size

.    there are no anchor points to be able to minimise so can not create multiple containers as needed 

>   insert child rectangle containers into the unmoveable single cell parent rectangle container

 

Usefull links

+  pbi community forums

-   Power BI Paginated Report Builder - layout zindex parent properties

-   Report Builder - Undocumented error - matrix row group

+  other

-   Rendering report items in paginated reports (Report Builder)

-   Add a rectangle or container to a paginated report (Report Builder)

-   Paginated Report Builder - how to find layout object type if Name property is changed

 

 

Questions

Will Visual Studio be of help?   ie RB has no layout explorer, would VS assist in this regards.  {cant answer this one yet as the autocratic IT department wont install and no portable to get around this road-block}

Could this issue be a result of overlapping layout objects?  unlike other paginated report tools like Crystal Reports and Oracle Reports where this is less of an issue

What is the 'front runner' reporting tool that works with DAX?  Jasper?  BIRT?

Why does the rectangle container object in the screenshot below not have anchor points?  Because it is placed in/over the matrix governing one cell. 

garythomannCoGC_0-1688010132580.png

Interact with the report design surface  so it is a cell with its textbox replaced with a rectangle 

 

 

 

2 REPLIES 2
bluehenve
Frequent Visitor

>Will Visual Studio be of help?   ie RB has no layout explorer, would VS assist in this regards
With the Visual studio extension 'Report Server Project', you can see the name list:

bluehenve_0-1702588109651.png

 

Thank you for your input and yes would be interesting but current environ not allowing VS for my role and do not have admin rights for install  to test :}

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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