[Solved] Grouping Line Items

[bdixon]

I have a db in which each record is a line item in an order:

Code: Select all

Order#        Purchaser           SKU                  Description             
1234          Frank Jones         SKU_1                A New Book      
1234          Frank Jones         SKU_2                Another Book
1235          Doria Williams      SKU_1                A New Book 
1236          Andy Taylor         SKU_3                Someone Else's Book
1236          Andy Taylor         SKU_2                Another Book
1236          Andy Taylor         SKU_4                My Book

I'm basically trying to create a Packing List -- I would like the order # and Purchaser to print as the header, then the line items to print in the detail, then start a new page whenever the order # changes. I'm using Sun Report Builder and am new to it and OpenOffice -- any help is appreciated!

[r4zoli]

The layout what you want to achive not possible with SRB 1.1.0., cross table reports not supported, now.

Only this can be reached on separate pages:
Order#
1234
Purchaser
Frank Jones
SKU Description
SKU_1 A New Book
SKU_2 Another Book

Order#
1235
Purchaser
Doria Williams
SKU Description
SKU_1 A New Book

Order#
1236
Purchaser
Andy Taylor
SKU Description
SKU_3 Someone Else's Book
SKU_2 Another Book
SKU_4 My Book

Create new Grouping selecting Field one Order# and second with Purchaser.
One Order# properties set the "Force New Page" to "Before Section".

[bdixon]

That did it. Hate to admit it but I was using the wrong field for order number. Thanks for your help!!

Bob