topic Re: Paginated Report - Parent/Child Datasets in Report Server

Paginated Report - Parent/Child Datasets

dkernen — Fri, 27 Aug 2021 12:58:43 GMT

I have three datasets: ReferralCase table ("parent"), SurveyResponse table ("child"), and ReferralsInDateRange (taken from a slicer in Desktop). They are all created in DAX from Desktop, but then I modifed them for the multi-select.

The parameters I have set are a start date and and end date, from which the Referrals parameter populates based on the referrals in range. Then the user can multi-select which referrals to select.

I have the initial header section working fine with the multi-select, but I don't know how to get the detail information from the SurveyResponses to populate right after each respective group (referral). The tutorials I have found online all show data only from a single dataset. I would like to know how to utilize the key value (Referral_ID) and pass the respective parameter value to the detail table. Then each referral selected would show the referral/case detail followed by the zero, 1 or more responses on one page, then the next referral with its responses, etc.

Do I use a list or a subreport? How do I tell the list/subreport which Referral's survey responses to pull? Do you have a step-by-step resource to walk me through the steps? I have attached my RDL. I am really stumped. Thank you so very much!

https://mwtn-my.sharepoint.com/:u:/g/personal/dkernen_mwtn_org/ETeHifJn0idOmwsIAl1ShbMBzw6N3qlbcRXQqesxNc23Eg?e=l8KaUk

@multi-select, @paginatedreport, @parentchild

Re: Paginated Report - Parent/Child Datasets

v-henryk-mstf — Mon, 30 Aug 2021 09:46:25 GMT

Hi dkernen ,

It is not very clear, whether you can further clarify your needs. Such as screenshots of expected results, etc. Looking forward to your reply.

Best Regards,
Henry

Re: Paginated Report - Parent/Child Datasets

AbhiSSRS — Mon, 30 Aug 2021 13:18:36 GMT

As much I understand this case it would need a subreport implementation. I have done one for the Paginated visual so that may help :

https://www.linkedin.com/pulse/power-bi-multiselect-paginated-visual-abhinav-singh/?trackingId=iVMEoCyKQDOJqsYS3OFu3g%3D%3D

Re: Paginated Report - Parent/Child Datasets

dkernen — Mon, 30 Aug 2021 15:39:45 GMT

v-henryk-mstf Is this helpful?

https://mwtn-my.sharepoint.com/:i:/g/personal/dkernen_mwtn_org/EVTsnSa1o41CgDEe5hSeN3oBjarVOeo4V-fIN1WG0My4lQ?e=EjhBvt