Cross tab

Tkalpetis

Hello i face a problem with the DB cross tab object. I want to put to master data codes like 21001,21002,21003 and to detail data to DB Cross Tab rows with colour, and columns with size.
But each code to appear each DB cross - tab .EG code 21001 master data then detail band with the colour and the size of this code in cross tab object then again the next code then again the db cross tab . Each master with only one cross tab object per detail band. Not all together. is it possible?

gpi

Use Master dataset for MasterData band, Detail dataset - for DBCrosstab

Tkalpetis

gpi wrote: »

Use Master dataset for MasterData band, Detail dataset - for DBCrosstab

I did it already this test.And i get if i have 2 codes ,
this result
10001
colour extrasmall small medium large etxra large
10001 1 10 10
10002 2 30 20

10002
colour extrasmall small medium large etxra large
10001 1 10 10
10002 2 30 20


intead of this result
10001
colour extrasmall small medium large etxra large
10001 1 10 10

10002
colour extrasmall small medium large etxra large
10002 2 30 20

Tkalpetis

Tkalpetis wrote: »

show previous quotes

Tkalpetis wrote: »

Use Master dataset for MasterData band, Detail dataset - for DBCrosstab

I did it already this test.And i get if i have 2 codes ,one per line each lines the Crosstab brongw me two coes to each line.
It doesn't break one code to each crosstab .
Eg Codes 10001 and code 10002
I get this result
10001
colour extrasmall small medium large etxra large
10001 1 10 10
10002 2 30 20

10002
colour extrasmall small medium large etxra large
10001 1 10 10
10002 2 30 20


intead of this result
10001
colour extrasmall small medium large etxra large
10001 1 10 10

10002
colour extrasmall small medium large etxra large
10002 2 30 20