Displaying Attached Documents in a Crystal Report
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 FROMIFSAPP.DOC_REFERENCE_OBJECT DR,IFSAPP.DOC_CLASS DC WHEREDR.LU_NAME = 'CustomerOrderLine'andDR.DOC_CLASS = DC.DOC_CLASS The select statement shown above would be used find objects connected to customer order lines.
頁:
[1]