I am developing a report to print our packing list and I have an issue that I am not sure how to handle. I have all the data consolidated into one data source. The problem I have is with the order notes. We have multiple orders on one packing list and they each could have different order notes on them. So I have my report grouped by order number and then line number to filter out all the duplicate data. Since the order notes are on each line they need to print on the detail section in order to get them all printed. When I place them in this section then I get them printed after each order line item since it is grouped by line. Is there a way that I can suppress them based on what the next record value is. My though is to suppress when order number is not equal to next order number. I have not been able to figure out how to do this though. Has anyone done this or know if it is possible?
You have two basic choices.
1) Save the notes in variables as you're reading the items for the order, then output those variables at the end of the order.
2) Use a subreport to output the notes.
A subreport would probably be the easiest solution. The subreport would output just the notes. You'd put it in the order group footer and pass it the order number (and anything else needed to find the right order), and it would read the items for that order and output all of the notes.
James