Forum Discussion
Power Bi Report Builder(Paginated Report) Dynamic
Hi SaulGarcia
Thanks for getting back with more details. Let me try to clear the confusion step by step. In Report Builder, when you insert a List control, it will look empty at first that is normal. Think of the List as a container, inside which you can place your header (rectangle with student details), a table for the body, and another rectangle for the footer. The grouping is done on StudentID so that each student gets their own section.For the 3-column layout, you won’t find that setting inside the table properties. Instead, go to Report → Report Properties → Layout, and there you can set the number of columns (for example, 3) and adjust the spacing. Once this is done, the rows from your table will automatically flow across the page in three columns. For page breaks, just enable “between each instance of a group” on the StudentID group. The footer can either go inside the list (if it’s student-specific) or in the report’s Page Footer section (if it’s the same across pages).
I’d suggest first trying with 2–3 students to check the behaviour before running it on the full dataset. This way, you’ll clearly see how the header, body in three columns, and footer repeat per student.
Thank you,Tejaswi.
hi , jaineshp good day, please excuse me for not writing sooner, but now , i am able to tell you.
I have followed the step you indicated me, it seem confused.
and could not continus.
at step 2, in the list place header, body and foot, Who can i do it. when drag and drop the list control, just put a list alone.
at step 4 body section , add a table , inside the list control
i do not see the properties columns and column spacing
Could you attach a example file, please?
remember that i am using Windows Application Power BI Report Builder v15.7.1806.11
Best Regards
Hi SaulGarcia
Thanks for getting back with more details. Let me try to clear the confusion step by step. In Report Builder, when you insert a List control, it will look empty at first that is normal. Think of the List as a container, inside which you can place your header (rectangle with student details), a table for the body, and another rectangle for the footer. The grouping is done on StudentID so that each student gets their own section.
For the 3-column layout, you won’t find that setting inside the table properties. Instead, go to Report → Report Properties → Layout, and there you can set the number of columns (for example, 3) and adjust the spacing. Once this is done, the rows from your table will automatically flow across the page in three columns. For page breaks, just enable “between each instance of a group” on the StudentID group. The footer can either go inside the list (if it’s student-specific) or in the report’s Page Footer section (if it’s the same across pages).
I’d suggest first trying with 2–3 students to check the behaviour before running it on the full dataset. This way, you’ll clearly see how the header, body in three columns, and footer repeat per student.
Thank you,
Tejaswi.