Merge Cells

Valdir Sola

Hi.

My query returns:
1 B VALUE
1 C VALUE
1 D VALUE
1 E VALUE
2 B VALUE
2 C VALUE
3 B VALUE
3 C VALUE
3 D VALUE
3 E VALUE
3 F VALUE

I need the following:

HOME GROUP
1 B VALUE
C VALUE
D VALUE
E VALUE
2 B VALUE
C VALUE
3 B VALUE
C VALUE
D VALUE
E VALUE
F VALUE
GROUP END
.
.
.
.
1, 2 AND 3 MUST BE Merged and centered.

If SuppressRepeated use not sure gives as does the merge of duplicates, only hides the information.

I could not do using DBCross.

Could anyone help me with this?


Thanks

gpi

Try to use subreports. See sample in the attach