I have been searching the boards and cannot see a simple solution for a simpleton on this. I am trying to create a report where my detail are in columns under the group header. Specifically I have a number of boxes 1-30 that have 150 serialized items in each. I can get the columns but not seperate from the box
my report looks like this:
1 (box no) 1235 2344
4555 4574 150 (count)
1235 1234 2 (box number)
1254 1657 2144
1254 2134 6584
What I want is
Box Number: 1 Count in Box: 150
1235 2548
2458 2584
6544 1474
6584 1448
Box Number: 2 Count in Box: 150
2548 4587
2584 4568
2548 3857
I hope this is clear and someone can help. Apologize if this is really basic I just cant figure it out