jercisneros
Technical User
I am having a problem trying to place the comments below the detail section that show the products purchased. I am using two tables; Sales Order Table that is grouped by {Sales_Order.Order_Number} and the Comments Table that contains the field: {Comment.Description} whith multiple lines. The detail section is grouped by the item number from the order table. I would like it to show the following way:
Item: Product Description: Order Qty:
0100 XYZ Product 200
0200 ZYX Product 100
0300 YZX product 150
==========================================
(Multiple Line Comments
should go here)
==========================================
Instead I get this...
Item: Product Description: Order Qty:
0100 XYZ Product 200
==========================================
Line 1 Comment
==========================================
0200 ZYX Product 100
==========================================
Line 2 Comment
==========================================
0300 YZX product 150
==========================================
Line 3 Comment
==========================================
Also If I add the comments field to the group footer it only gives me Line 1 Comment
Please help...
Item: Product Description: Order Qty:
0100 XYZ Product 200
0200 ZYX Product 100
0300 YZX product 150
==========================================
(Multiple Line Comments
should go here)
==========================================
Instead I get this...
Item: Product Description: Order Qty:
0100 XYZ Product 200
==========================================
Line 1 Comment
==========================================
0200 ZYX Product 100
==========================================
Line 2 Comment
==========================================
0300 YZX product 150
==========================================
Line 3 Comment
==========================================
Also If I add the comments field to the group footer it only gives me Line 1 Comment
Please help...