Power Bi Report Builder(Paginated Report) Dynamic

[SaulGarcia]

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

[v-tejrama]

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!

[v-tejrama]

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.

[v-tejrama]

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.

[jaineshp]

Hey @v-tejrama,

Thank you for the kind recognition - always happy to contribute to our community's success!

Best Regards,
Jainesh Poojara | Power BI Developer

[jaineshp]

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

[SaulGarcia]

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