I am having difficulty making an amendment to a pre-existing crystal report file.

Our in house crystal expert has unexpected left the company and I have yet to have training.

We run SAP Business One 9.1 and Accellos WMS.

This crystal report is used by Accellos, to generate a delivery note based on information provided by SAP Business One.

Looking at the Database Expert in Crystal Reports, the report is using a view table called NER_DelNote which contains only the fields necessary for this report.

I wish to add the field U_PO_number from RDR1 table in SAP sales order onto this crystal report, on a product line level.

My initial though was to create a new connection in Database Expert and add the ORDR and RDR1 tables in but I cannot link these to any of the fields in the NER_DelNote view/table because the 'data types are not compatible'

Is there an alternative way to achieve what I am trying create?