Get BL Invoice data AND Comment Attachment on one Crystal Report

 0 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Lance Kelley
Advanced Member
Posts: 24
Advanced Member

    Issue:I need to produce a BL Invoice from Crystal Reports (CR) AND include BL comments to help explain the reason for the invoice to our customers.

    Using the OLE DB connector within Crystal Reports (CR) 2008, I can pull up the table info with a DME Query, and separately, I can pull up one associated BL Invoice attachment with a getattachrec Query, but I can't seem to put the two together on one report.  Anyone done this before?

    BL recurring invoice comments are stored in (BL30.1 -> BL32.1 -> Comments (as attachments).


    Detail:  I use a DME Query to to get all the info except the comments.
    I can use a getattachrec Query to to get a single comment using the index with the 4 key fields as (for example): BMCSET1&K1=100&K2=ADAMSON&K3=&K4=1 where K1 "100" is our Company, K2 "ADAMSON" is an example RECUR-INVOICE, K3 is the Line No. (not nec.), and K4 "1" is the first Sequenced Comment.

    What I need to do is replace the hard-coded K2 with the variable OEINVOICE.RECUR-INVOICE from the table, and link these two tables OEINVOICE and BLRIMCOMM in the links tab. How?  Thanks!