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.
Hey SaulGarcia,
Based on your requirements for handling multiple students with paginated reports, here are the recommended steps:
1. Dataset Structure
- Ensure your DAX query returns all required fields: StudentID, StudentName, Year, Subject details
- Order the dataset by StudentID first, then by any subject sequence you need
- Include all header information (student details) in each row to avoid lookup issues
2. Report Layout Configuration
- Create a List control as your main container
- Set the List to group by StudentID - this is crucial for the dynamic behavior
- Inside this List, place your header, body table, and footer elements
3. Header Implementation
- Place header elements in the List header section
- Use expressions like =First(Fields!StudentName.Value, "YourDatasetName") for student info
- This ensures each student page shows their specific details
4. Body Section (3 Columns)
- Add a Table/Matrix inside the List for subject details
- In Table properties, set Columns = 3 and configure column spacing
- Alternatively, use 3 separate Table controls side by side with filtering expressions
5. Page Break Configuration
- Go to List Group Properties → Page Breaks tab
- Enable "Between each instance of a group"
- This creates separate pages per student automatically
6. Footer Setup
- Place footer content in the page footer section of the report
- It will render consistently across all student pages
Testing Recommendation: Start with 2-3 students first to verify the grouping logic works correctly before running the full 100+ records.
This approach should handle your massive data scenario while maintaining the dynamic header requirement.
Fixed? ✓ Mark it • Share it • Help others!
Best Regards,
Jainesh Poojara | Power BI Developer
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.