SSRS Grouped Report/ Subreport on Side

I’m looking to take the scheduled shipments report, group it by customer and part number. That parts pretty simple. I’ve got a request to also see info on the quantities on hand. I could build this as a linked subreport and have that be at the part number totals. However, I’d like to have this side by side with the order release data, kind of like this:
image

Obviously, there are times when I’ll have a lot more open orders (the left side) than bin/lot information (right side). And times where it’s switched.

Is it possible to do this with SSRS?

1 Like

Sure, you just need to use multiple Tablixes. Might be tough to get the totals to line up though.

Yeah, I didn’t know if there was a way to link data in one tablix to another. Kind of like you’d do with a subreport. I could do the subreport, but not sure if I can have that span across multiple rows within the Part Number grouping.

I think I’m at the point of realizing it likely COULD be done, but would probably involve a whole lot more effort than it’s worth.