Hello,
In order to get a Purchase Order Entry report to do what was asked, I had to create a join on the subreport POForm_PORelPart.rdl table called TranGLC to report as:
LEFT OUTER JOIN EpicorSQL1.Epicor10Prod.Erp.TranGLC T5 on
T3.Company = T5.Company AND T5.key1 = cast(T3.PONum as varchar) and T5.key2 = cast(T3.POLine as varchar) and T5.key3 = cast(T3.PORelNum as varchar) AND T5.RelatedToFile = ‘PORel’
Now that we moved to the cloud, I am unsure on how to change the part: LEFT OUTER JOIN EpicorSQL1.Epicor10Prod.Erp.TranGLC
to point to the cloud instance.
Any ideas?