One pipeline, groups and multiple columns

rbuser

Maybe someone can help with this kind of report:

I've one pipeline wich gives me the following dataset:
articleid, article, personid, person, barcode

an example is:
1, dress, 1, john, 1111
1, dress, 1, john, 1112
1, dress, 2, charles, 1113
1, dress, 2, charles, 1114
2, coat, 1, john, 1115
2, coat, 2, charles, 1116
2, coat, 2, charles, 1117
2, coat, 2, charles, 1118
2, coat, 2, charles, 1119

Now I want the dataset grouped by articleid and personid, and as much
barcodes on one line as possible.
So the layout should be something like

dress
john 1111, 1112
charles 1113, 1114
coat
john 1115
charles 1116, 1117, 1118, 1119

Splitting of the dataset into a master-detail dataset is not very easy,
because of the joins I need to create it.

I've tried to use a sub-report with mutliple columns, and I've tried to use
the crosstab component. Both didn't work as I expected, or maybe I just
don't understand them.

Can anybody help me please ?

Thanks,

Diederik

digitalmetaphors

You can perform your joins, but then you need to sort the data by articleid
and then personid. Now the fun part. You'll need to print multiple barcode
records on one line. Create a lookup query on the fly and traverse through
its records yourself when the detail band prints. You will want to have a
number of barcode components arlready created and in the band. Then you can
set the visibility of the barcodes that you want to have in the band, and
assign each one of them a value from the lookup query as you traverse
through it.

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Sorry, pushed the reply button, instead of the reply group button...

Thanks, this set me on a new track. However, this approach is little
difficult because of the master detail needed.

I'll try to traverse the main query until all my labels on the detail band
are filled, or until the next group is reached, in wich case I'll try to
traverse back.

(That's possible, isn't it ?)

Diederik