Create a report per Worker ID with different datasets feeding different tablix
I'm working for a client migrating from oracle reports to PowerBI reports. I took the queries already written for a specific report and created 3 datasets: Header - includes info about the worker, including a WorkerID Earnings - inludes info per worker, per day, per earning type, of sums of earnings. Also has worker ID. Deductments - inludes info per worker, per day, per deductment type, of sums of deductments. Also has worker ID. Now what i need should look like this, per worker: Now i tried to make a list with textboxes and tables nested. However, since the header info comes from one dataset, the earnings from another and deductments from another, I was unable to make them repeat together. When i nest a table of earnings into the list where the header is already built, the dataset changes automatically from Earnings to Header. This is a oracle DB and there is no connection between datasets. Can someone share a workaround or a solution? I'm pretty sure its a common request but I can't seem to find much info online about it.
multiple Tablixes per page
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 this works, but i’d like to try to utilize 2 Tablixes for this process if possible utilize a Subreport 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 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?
