I'm having a difficult problem and I'm not sure how to solve it.
I have a list of orders with items and each item has a handful of details. So a report looks like...
1001,001,item1,detailline1
1001,001,item1,detailline2
1001,001,item1,detailline3
1001,002,item2,detailline1
1001,002,item2,detailline2
etc.
But I'm looking to get those detail lines to go more like this...
1001,001,item1,detailline1,detailline2,detailline3
The detailline is a "description" field and I could use the selection expert to pick which from the sequence number field "1,2,3" but then I only get one description line, otherwise they pile down making the order number(1001), line item number(001) and item duplicate to match up. Of course I'm using a simple example here... my report is similar just with more fields.
Anybody got a clue as to how I can have the details lines/description lines stand shoulder to shoulder? I'd deeply appreciate it.
Edited by Kite - 20 Jul 2010 at 4:46am