I have a field on the Customer Shipment Entry summary section called Pickup Number. We have invoices with multiple packs, but when I bring the Pickup Number onto the SSRS for AR Invoice, it only brings the first pack num’s pickup number. We have a section on the SSRS where we are able to view all pack num, item num, description, quantity, price, etc. But the Pickup Number is outside of that section because it does not apply to all customers. Is there a way to list all Pickup Numbers rather than just the first one. See attached rdl file.
Why can’t you create a new section down where the details are going to be, instead of at the grouping for the invoice number, and still use the same Row Visibility formula that you have?
It is only showing the first one since your T15 (shiphead) is linked to your T1 (invoice header). I would join your T15 into the line instead of the header. AND T1.Calc_PackNum = T15.PackNum becomes T2.PackNum = T15.Packnum
Caviat is if there are other things in the shiphead you need to reference at the invoice header level then you can simply use another alias to shiphead (ie. LEFT OUTER JOIN ShipHead_" + Parameters!TableGuid.Value + " T18
ON T1.Company = T18.Company
AND T2.PackNum = T18.PackNum "
You then can add in the pickup number as a column in your detail section.
**Note this assumes you have invdtl.packnum selected in your data definition. It also assumes one shipment per item/invoice line. ** If you have multiple invoice lines and shipments per item and you want to keep them grouped, then you will need to do either a subreport or subquery where you generate a comma separated list.
I tried doing that, but it still would not give me what I was wanting it to. Maybe I am misunderstanding how to approach it. Would it be possible for you to modify the rdl file I sent so I know where exactly you are expecting this change?
Just wanted to see if you had any other recommendations to getting this issue to fix. I ended up moving the Pickup Number section to the table details section to show the corresponding Pickup Number next to the Pack Num. I still only get the first Pickup Number to show up. Attached is the latest rdl file: