2 replies
by jerom
by sjvfp
The parent file has 1 record for each invoice. 1 child file has multiple records for each invoice depending on the # of line items, the 2nd child file has 1 record for each line of note per invoice (i.e. if an invoice has a note with 5 lines of information there would be 5 records with an invoice # field and a comment field.
I tried adding additional groups but this is where the problem comes in, with the 'comment' field in the detail section all records are displayed, but it comes up after each item. When placing the "comment" in a summary section I only get 1 record of 'comments' associated with the invoice #? I also turned off the repeat duplicate feature, however with each note field being different I imagine it doesn't see the 'group' of them as duplicates. I wonder if it is possible to attach the records together and store it as a memory variable (or array) and call it back in a different section of the report? I think I'll try that.
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending