Sage 100

Client really wants to see the PO number on the Inventory Valuation Report. The IM_ValuationReportWrk file combines the ReceiptType and the ReceiptNo fields and calls this ReceiptNo, so of course links don't work to PO ReceiptHistoryDetail. Question: is it possible to link two fields using a formula in the Database Expert / Link area? I don't see it.

I've added a subreport and linked it to a formula field.

Either use a sub-report, or unlinked / fake join with enforced matches using report selection criteria (formula field for the substring equals the other table value). I've done both methods, and just end up using whatever runs faster.

Thanks to you both. I went with the subreport approach and it works great.