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?
Add comment