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:
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.
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.