How to Use Media Objects with Crystal Reports
In order to use Media Objects, the Enable Support for Media Objects Option in the DSN must be checked on. See in DSN Options.
JD Edwards OneWorld and EnterpriseOne supports media and text objects.
Unity’s new version 3.0 ODBC drivers for JD Edwards OneWorld and EnterpriseOne now expose E1 media and text objects just like any other table and column.
Access to Crystal Reports, authority to your jde database and file authority to the objects repository is a prerequisite.
The Media Objects tables are available in the database views. However, due to limitations of Windows and Crystal and the large number of both tables and views in JDE, scrolling down the views does not display the Media Objects (MO) views. You will need to select the Options screen by right clicking on the Data Source as shown below.
Enter the required search criteria in the options, Data Explorer, table name LIKE box. In the above example MO% has been entered. But any selection criteria may be used.
Select OK to Options and OK to Database Expert and F5 to refresh.
Select the JDE file and open views to select the MO_GT file required. See Item Master example below.
Select the MO_GT4101_Picture_of_item to link with the JDE F4101_Item_Master.
The high level Keys will be presented in the GT table, join using all the associated parent table keys. In this example IMITM (in MO_GT4101) is keyed to IMITM_Item_Number_Sht (in F4101_Item_Master).
Make the file link/s and accept.
Select the MO Columns you require for your report.
Ten Column options are displayed in this example. (There will be as many Key Fields listed as Keys in the JDE master file linked to the MO_GT file).
See the Media and Text Objects section of the Help Manual for a full explanation of the columns listed.
In this example the item Picture (IMMOCRYSTAL) and file links (IMMOLINK) have both been selected.
An example report is available here.