Displaying Attached Documents in a Crystal Report

admin

This can be done if the connected objects are not stored in the database as blob fields. We have our connected objects stored on a shared network drive. The view you would want to look at is ifsinfo.documents_connect_objects.

If you don’t have this view you can create an IAL that has select statement that would look something like this:

SELECT

DR.KEY_REF,

substr((substr(DR.key_ref,((instr(DR.key_ref,'^ORDER_NO='))+10),((instr(DR.key_ref,'^REL_NO='))-((instr(DR.key_ref,'^ORDER_NO='))+10)))),1,12) ORDER_NO,

substr((substr(DR.key_ref,((instr(DR.key_ref,'^LINE_NO='))+9),((instr(DR.key_ref,'^ORDER_NO='))-((instr(DR.key_ref,'^LINE_NO='))+9)))),1,4) LINE_NO,

substr((substr(DR.key_ref,((instr(DR.key_ref,'^REL_NO='))+8),((LENGTH (DR.key_ref))-((instr(DR.key_ref,'^REL_NO='))+8)))),1,4) REL_NO,

DR.LU_NAME,

DC.DOC_NAME,

DR.DOC_CLASS,

DR.DOC_NO,

DR.OBJID

FROM

IFSAPP.DOC_REFERENCE_OBJECT DR,

IFSAPP.DOC_CLASS DC

WHERE

DR.LU_NAME = 'CustomerOrderLine'

and

DR.DOC_CLASS = DC.DOC_CLASS

The select statement shown above would be used find objects connected to customer order lines.