Forum Discussion
Power Bi Report Builder(Paginated Report) Dynamic
Hi! good day everyone, i have question, this is the environment :
* Power bi Report builder
* Datasource is from semantic model
* to create dataset is with queries dax
i am trying to créate a report in power bi report builder,
with this sections:
* header
* body ( with 3 page columns )
* footer
the data is about students, and it must be displayed by year,
one year have at least 100 records
these records are
* header (the generic data student )
* body ( the body is the data subject, and it has to be displayed in 3 columns page)
* footer
Example
At this point, i am able to run one year that has only one student and get header and details
but when the year has more one record, i don know how to run massive
I want to make a dynamic header for each studentId page, and details
Can any one please help me on this?
Thanks in advance
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.
7 Replies
Hi SaulGarcia ,
Thank you jaineshp for the response provided!
Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Thank you for your understanding!Hi SaulGarcia ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.Thank you,
Tejaswi.
Hi SaulGarcia ,
I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.
Thank you.
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 Developerhi , 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.11Best 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.
