i have 2 dataset

the first is a list of courses, terms, and grades per student id

studentId	course	term	grade
1	Math	Semester 1	90
1	Science	Semester 1	80
1	Math	Semester 2	80
1	Science	Semester 2	85
2	English	Semester 1	50
2	Art	Semester 1	100
2	English	Semester 2	90
2	Art	Semester 2	95

then i have a list of student demographics including name, site, and birthdate

studentId	name	site	birthdate
1	John Doe	Harvard	3/11/2000
2	Sally Johnson	MIT	2/1/2000

and i want to create a report card that has 2 tablixes that each repeat on each page to get me something like:

Page 1:

student id	1	name	John Doe
site	Harvard	birthdate	3/11/2000

course	term	grade
Math	Semester 1	90
Science	Semester 1	80
Math	Semester 2	80
Science	Semester 2	85

Page 2:

student id	2	name	Sally Johnson
site	MIT	birthdate	2/1/2000

course	term	grade
English	Semester 1	50
Art	Semester 1	100
English	Semester 2	90
Art	Semester 2	95

i have the bottom Tablix exporting correctly—each page is a different student, but i can’t seem to get the top Tablix setup correctly such that it will repeat at the top of each page before the grades

i have tried 2 workarounds, and 1 works, the other i cannot get to work:

utilize Text boxes within the Header
1. this works, but i’d like to try to utilize 2 Tablixes for this process if possible
utilize a Subreport
1. i cannot get this to work unless i make the Sub report and the 1 Tablix side-by-side. if i stack them 1 on top of the other, Power BI separates them onto different pages
2. also, i can’t seem to match them up, even though i set a parameter in the subreport to match the same id number of the current page

thoughts?

Forum Discussion

multiple Tablixes per page

Exporting in multiple pages

Change format tablix

Power BI Report Builder - Tablix Page brake

Filters on multiple pages

Tooltip page