I have a bunch of SSRS reports that have a couple of stored procs as data sets:
ds_rsp_report_name --> The detail section of my report, with a PK and at least 1k rows.
ds_rsp_report_name_header --> One record with the PK and a bunch of columns that will appear only once in a header section. I'm trying to avoid including them in the detail to cut down on network traffic.
Q: How can I include both of these data sets into a single grouping of PK, with a page break at the end, so I can generate reports that have the header section + detail for each PK with a page break?
My research (Google) up until now always speaks to grouping within a single tablix control, but never across multiple data sets.
Thanks in advance.