Add field to Crystal Reports report

Ruben_Corral_Yrureta · October 1, 2020, 10:46pm

Hi Guys,

In order to show Purchase Order number ( sent to supplier) and the invoice (sent to customer) in the packing slip, i have added the OrderRel and the InvcHeadShip tables to the RDD. I have created the links and now everytime I generate the report the XML is showing the required information.

my problem is in the Crystal Reports side, i’m not being able to see the new tables in the DatabaseFields list… as you can see i’m completely new to Crystal Reports.

Arul · October 2, 2020, 10:33am

Check advanced.crystal.reports pdf document is available in EpicWeb under Epicor 9.

Nancy_Hoyt · October 2, 2020, 12:15pm

Hi Ruben,

You need to tell the report to add the table and how it is related to the existing tables. See screenshot below.

Nancy

Ruben_Corral_Yrureta · October 2, 2020, 1:02pm

Thank you Nancy!! that was it!!!

Ruben_Corral_Yrureta · October 2, 2020, 1:19pm

Hi Arul,

regarding that, should you have an idea on how to find that pdf? i haven´t been able to locate the pdf you are telling me